Instructions

Follow carefully these instructions and do not manipulate, unprotect or change the names of the ones you are given .
Any other case, your work WILL NOT BE EVALUATED.

1º.- Look for your student code (column "CODIGO" in the gradings for this assigment in the section
"Assignments" > "Assingment Revisions" in Blackboard) and write it in the next cell:
54493223
STUDENT López Cuevas, Jorge

2º.- If your name has appeared, it is a confirmation that your code is right. In the sheet "Datos" you will find the data for
your work. To keep your data safe, (avoid accidents) the sheet "Datos" is protected.

3º.- As you can check, you have a sheet with the name of each question. You have to solve each question in its
corresponding sheet. So begin copying ALL your data in the sheet ".Pregunta_1" (Seleccionar - Copiar - Pegado especial -
Valores) and start solving Question 1.

4º.- Keep on solving each question in their corresponding sheet; As soon as you have the answer write them in the
corresponding cells below in this same sheet in "Answers".

5º.- When you finish, save this file with the option "Guardar como" > "Libro de Excel",
[Link]
with the following name:
6º Send the file before deadline through the option "Submit" available in "Assignmetnts" for this assignment in
Blackboard.

Answers:
1 2 3 4 5 6 7

8 9 10

Questions:
(give always the probabilities "per unit" and the time in the format hh:mm:ss)
ALUMNO: López Cuevas, Jorge
Codigo: 54493223 Hora de apertura: ###
Hora de cierre: ###
Datos:
Llegada a la Cola Longitud de Espera en la Espera en la ¿Paga con
Cliente de la Caja la Cola Cola Caja Tarjeta?
00001 09:01:09 AM 0 ### 12:00:48 AM 0
00002 09:01:52 AM 1 ### 12:02:01 AM 1
00003 09:03:31 AM 1 ### 12:02:05 AM 1
00004 09:03:37 AM 2 ### 12:02:41 AM 1
00005 09:06:26 AM 1 ### 12:01:00 AM 0
00006 09:08:01 AM 2 ### 12:02:21 AM 1
00007 09:16:37 AM 0 ### 12:01:02 AM 0
00008 09:18:14 AM 0 ### 12:02:32 AM 1
00009 09:20:23 AM 1 ### 12:02:28 AM 1
00010 09:28:30 AM 0 ### 12:00:52 AM 0
00011 09:29:59 AM 0 ### 12:02:46 AM 1
00012 09:32:55 AM 0 ### 12:01:43 AM 1
00013 09:33:51 AM 1 ### 12:02:16 AM 1
00014 09:36:20 AM 1 ### 12:03:13 AM 1
00015 09:37:47 AM 1 ### 12:00:35 AM 0
00016 09:38:09 AM 2 ### 12:01:02 AM 0
00017 09:42:50 AM 0 ### 12:02:15 AM 1
00018 09:43:39 AM 1 ### 12:02:13 AM 1
00019 09:44:11 AM 2 ### 12:02:27 AM 1
00020 09:47:38 AM 1 ### 12:02:22 AM 1
00021 09:48:46 AM 2 ### 12:00:48 AM 0
00022 09:49:50 AM 2 ### 12:01:02 AM 0
00023 09:51:54 AM 3 ### 12:02:29 AM 1
00024 09:57:22 AM 0 ### 12:02:28 AM 1
00025 09:57:50 AM 1 ### 12:01:04 AM 0
00026 09:58:25 AM 2 ### 12:02:55 AM 1
00027 09:59:11 AM 3 ### 12:00:54 AM 0
00028 10:00:37 AM 3 ### 12:00:35 AM 0
00029 10:02:27 AM 3 ### 12:00:51 AM 0
00030 10:02:41 AM 4 ### 12:02:01 AM 1
00031 10:11:21 AM 0 ### 12:02:02 AM 1
00032 10:11:50 AM 1 ### 12:01:07 AM 0
00033 10:13:31 AM 1 ### 12:02:26 AM 1
00034 10:15:13 AM 1 ### 12:02:14 AM 1
00035 10:17:09 AM 1 ### 12:02:45 AM 1
00036 10:21:08 AM 1 ### 12:02:49 AM 1
00037 10:22:02 AM 1 ### 12:02:45 AM 1
00038 10:22:16 AM 2 ### 12:00:43 AM 0
00039 10:25:15 AM 2 ### 12:02:03 AM 1
00040 10:28:15 AM 2 ### 12:02:14 AM 1
00041 10:28:15 AM 3 ### 12:02:18 AM 1
00042 10:30:00 AM 3 ### 12:00:28 AM 0
00043 10:34:24 AM 2 ### 12:00:39 AM 0
00044 10:34:51 AM 3 ### 12:02:16 AM 1
00045 10:38:05 AM 1 ### 12:02:12 AM 1
00046 10:38:06 AM 2 ### 12:01:40 AM 1
00047 10:41:47 AM 1 ### 12:03:04 AM 1
00048 10:44:44 AM 1 ### 12:00:49 AM 0
00049 10:45:36 AM 1 ### 12:02:44 AM 1
00050 10:47:02 AM 1 ### 12:02:06 AM 1
00051 10:49:01 AM 1 ### 12:02:02 AM 1
00052 10:52:24 AM 1 ### 12:01:35 AM 1
00053 10:54:20 AM 1 ### 12:01:02 AM 0
00054 10:58:36 AM 0 ### 12:01:49 AM 1
00055 10:58:38 AM 1 ### 12:01:00 AM 0
00056 11:06:23 AM 0 ### 12:00:55 AM 0
00057 11:16:23 AM 0 ### 12:00:54 AM 0
00058 11:17:02 AM 1 ### 12:00:52 AM 0
00059 11:18:54 AM 0 ### 12:02:19 AM 1
00060 11:19:26 AM 1 ### 12:02:33 AM 1
00061 11:22:39 AM 1 ### 12:02:07 AM 1
00062 11:28:13 AM 0 ### 12:02:35 AM 1
00063 11:29:47 AM 1 ### 12:02:19 AM 1
00064 11:30:50 AM 1 ### 12:02:24 AM 1
00065 11:31:03 AM 2 ### 12:02:20 AM 1
00066 11:33:44 AM 2 ### 12:00:45 AM 0
00067 11:38:35 AM 1 ### 12:00:49 AM 0
00068 11:38:47 AM 1 ### 12:01:53 AM 1
00069 11:41:50 AM 0 ### 12:01:54 AM 1
00070 11:41:56 AM 1 ### 12:01:01 AM 0
00071 11:42:54 AM 2 ### 12:02:05 AM 1
00072 11:45:01 AM 1 ### 12:02:37 AM 1
00073 11:45:25 AM 2 ### 12:00:43 AM 0
00074 11:52:40 AM 0 ### 12:00:46 AM 0
00075 11:53:19 AM 1 ### 12:02:20 AM 1
00076 11:53:46 AM 1 ### 12:02:59 AM 1
00077 11:57:32 AM 1 ### 12:03:07 AM 1
00078 12:07:27 PM 0 ### 12:02:17 AM 1
00079 12:08:08 PM 1 ### 12:02:40 AM 1
00080 12:09:13 PM 2 ### 12:02:27 AM 1
00081 12:15:05 PM 0 ### 12:02:09 AM 1
00082 12:17:07 PM 1 ### 12:02:07 AM 1
00083 12:19:46 PM 0 ### 12:02:51 AM 1
00084 12:25:02 PM 0 ### 12:00:55 AM 0
00085 12:25:31 PM 1 ### 12:02:47 AM 1
00086 12:26:23 PM 1 ### 12:02:16 AM 1
00087 12:27:37 PM 2 ### 12:02:01 AM 1
00088 12:43:45 PM 0 ### 12:03:22 AM 1
00089 12:44:58 PM 1 ### 12:02:02 AM 1
00090 12:45:18 PM 2 ### 12:00:47 AM 0
00091 12:54:03 PM 0 ### 12:02:26 AM 1
00092 12:55:12 PM 1 ### 12:02:14 AM 1
00093 01:09:30 PM 0 ### 12:00:57 AM 0
00094 01:11:15 PM 0 ### 12:02:20 AM 1
00095 01:12:13 PM 1 ### 12:02:54 AM 1
00096 01:14:49 PM 1 ### 12:02:32 AM 1
00097 01:16:22 PM 2 ### 12:01:02 AM 0
00098 01:17:13 PM 2 ### 12:02:44 AM 1
00099 01:19:26 PM 2 ### 12:02:12 AM 1
00100 01:19:27 PM 3 ### 12:02:06 AM 1
00101 01:23:18 PM 2 ### 12:02:25 AM 1
00102 01:28:23 PM 1 ### 12:00:31 AM 0
00103 01:31:32 PM 0 ### 12:01:10 AM 0
00104 01:34:26 PM 0 ### 12:01:07 AM 0
00105 01:35:30 PM 1 ### 12:01:02 AM 0
00106 01:40:44 PM 0 ### 12:04:10 AM 1
00107 01:45:00 PM 0 ### 12:01:16 AM 0
00108 01:46:52 PM 0 ### 12:02:39 AM 1
00109 01:47:12 PM 1 ### 12:03:18 AM 1
00110 01:47:48 PM 2 ### 12:02:28 AM 1
00111 01:47:55 PM 3 ### 12:02:46 AM 1
00112 01:50:40 PM 3 ### 12:02:43 AM 1
00113 01:51:37 PM 4 ### 12:01:13 AM 0
00114 01:55:28 PM 3 ### 12:02:31 AM 1
00115 01:59:46 PM 3 ### 12:02:20 AM 1
00116 02:00:15 PM 4 ### 12:01:58 AM 1
00117 02:02:24 PM 3 ### 12:02:18 AM 1
00118 02:03:34 PM 4 ### 12:01:03 AM 0
00119 02:08:43 PM 3 ### 12:00:54 AM 0
00120 02:09:36 PM 3 ### 12:02:29 AM 1
00121 02:10:47 PM 4 ### 12:02:38 AM 1
00122 02:11:57 PM 4 ### 12:02:29 AM 1
00123 02:13:02 PM 4 ### 12:01:10 AM 0
00124 02:17:26 PM 3 ### 12:00:35 AM 0
00125 02:19:06 PM 3 ### 12:00:43 AM 0
00126 02:20:51 PM 3 ### 12:02:32 AM 1
00127 02:22:51 PM 2 ### 12:00:43 AM 0
00128 02:27:57 PM 0 ### 12:02:43 AM 1
00129 02:32:57 PM 0 ### 12:02:24 AM 1
00130 02:34:39 PM 1 ### 12:00:59 AM 0
00131 02:35:23 PM 1 ### 12:00:50 AM 0
00132 02:38:04 PM 0 ### 12:02:29 AM 1
00133 02:44:31 PM 0 ### 12:00:53 AM 0
00134 02:54:23 PM 0 ### 12:01:00 AM 0
00135 02:54:44 PM 1 ### 12:03:16 AM 1
00136 02:58:36 PM 1 ### 12:00:52 AM 0
00137 03:04:47 PM 0 ### 12:01:52 AM 1
00138 03:06:04 PM 1 ### 12:03:13 AM 1
00139 03:10:34 PM 0 ### 12:02:03 AM 1
00140 03:13:42 PM 0 ### 12:02:45 AM 1
00141 03:15:21 PM 1 ### 12:02:26 AM 1
00142 03:24:24 PM 0 ### 12:01:15 AM 0
00143 03:25:14 PM 1 ### 12:02:37 AM 1
00144 03:27:44 PM 1 ### 12:02:19 AM 1
00145 03:29:15 PM 1 ### 12:00:48 AM 0
00146 03:30:29 PM 2 ### 12:01:51 AM 1
00147 03:32:28 PM 1 ### 12:03:00 AM 1
00148 03:32:59 PM 2 ### 12:02:16 AM 1
00149 03:35:07 PM 2 ### 12:01:07 AM 0
00150 03:36:31 PM 2 ### 12:01:14 AM 1
00151 03:37:13 PM 3 ### 12:01:56 AM 1
00152 03:38:00 PM 4 ### 12:02:22 AM 1
00153 03:39:31 PM 4 ### 12:02:23 AM 1
00154 03:42:31 PM 3 ### 12:01:48 AM 1
00155 03:42:58 PM 3 ### 12:02:32 AM 1
00156 03:44:53 PM 4 ### 12:02:27 AM 1
00157 03:45:50 PM 4 ### 12:00:54 AM 0
00158 03:48:24 PM 4 ### 12:02:23 AM 1
00159 04:05:00 PM 0 ### 12:01:17 AM 1
00160 04:12:06 PM 0 ### 12:00:58 AM 0
00161 04:14:46 PM 0 ### 12:01:16 AM 0
00162 04:16:16 PM 0 ### 12:01:01 AM 0
00163 04:18:24 PM 0 ### 12:00:54 AM 0
00164 04:18:29 PM 1 ### 12:02:48 AM 1
00165 04:24:57 PM 0 ### 12:02:27 AM 1
00166 04:25:17 PM 1 ### 12:01:03 AM 0
00167 04:32:36 PM 0 ### 12:02:51 AM 1
00168 04:34:25 PM 1 ### 12:00:41 AM 0
00169 04:35:51 PM 1 ### 12:01:48 AM 1
00170 04:36:17 PM 1 ### 12:03:16 AM 1
00171 04:41:25 PM 0 ### 12:02:04 AM 1
00172 04:44:34 PM 0 ### 12:02:38 AM 1
00173 04:47:28 PM 0 ### 12:02:56 AM 1
00174 04:47:56 PM 1 ### 12:00:42 AM 0
00175 04:53:08 PM 0 ### 12:02:29 AM 1
00176 04:57:31 PM 0 ### 12:03:00 AM 1
00177 05:00:07 PM 1 ### 12:01:17 AM 0
00178 05:00:37 PM 1 ### 12:01:02 AM 0
00179 05:03:16 PM 0 ### 12:02:16 AM 1
00180 05:04:23 PM 1 ### 12:01:57 AM 1
00181 05:08:40 PM 0 ### 12:01:18 AM 0
00182 05:10:09 PM 0 ### 12:02:17 AM 1
00183 05:10:22 PM 1 ### 12:01:05 AM 0
00184 05:10:58 PM 2 ### 12:01:10 AM 0
00185 05:16:53 PM 0 ### 12:01:14 AM 0
00186 05:21:53 PM 0 ### 12:02:30 AM 1
00187 05:23:06 PM 1 ### 12:02:11 AM 1
00188 05:25:42 PM 1 ### 12:02:15 AM 1
00189 05:29:41 PM 0 ### 12:00:36 AM 0
00190 05:30:01 PM 1 ### 12:00:51 AM 0
00191 05:31:04 PM 1 ### 12:02:24 AM 1
00192 05:32:13 PM 1 ### 12:01:02 AM 0
00193 05:32:33 PM 2 ### 12:02:54 AM 1
00194 05:35:03 PM 1 ### 12:03:08 AM 1
00195 05:38:15 PM 1 ### 12:03:04 AM 1
00196 05:38:53 PM 2 ### 12:02:05 AM 1
00197 05:40:26 PM 3 ### 12:03:14 AM 1
00198 05:44:32 PM 2 ### 12:00:50 AM 0
00199 05:47:01 PM 2 ### 12:03:44 AM 1
00200 05:52:18 PM 1 ### 12:02:13 AM 1
00201 05:54:40 PM 1 ### 12:03:32 AM 1
00202 06:01:58 PM 0 ### 12:01:57 AM 1
00203 06:05:22 PM 0 ### 12:02:18 AM 1
00204 06:07:52 PM 0 ### 12:03:41 AM 1
00205 06:08:11 PM 1 ### 12:02:55 AM 1
00206 06:12:12 PM 1 ### 12:00:55 AM 0
00207 06:19:10 PM 0 ### 12:00:55 AM 0
00208 06:21:19 PM 0 ### 12:02:49 AM 1
00209 06:24:11 PM 0 ### 12:03:07 AM 1
00210 06:24:46 PM 1 ### 12:02:58 AM 1
00211 06:30:32 PM 0 ### 12:02:02 AM 1
00212 06:42:36 PM 0 ### 12:02:28 AM 1
00213 06:44:46 PM 1 ### 12:00:53 AM 0
00214 06:46:01 PM 0 ### 12:01:48 AM 1
00215 06:47:10 PM 1 ### 12:01:01 AM 0
00216 06:49:34 PM 0 ### 12:02:06 AM 1
00217 06:52:21 PM 0 ### 12:01:52 AM 1
00218 06:53:02 PM 1 ### 12:02:03 AM 1
00219 06:54:12 PM 2 ### 12:02:06 AM 1
00220 06:55:35 PM 2 ### 12:00:51 AM 0
00221 07:04:09 PM 0 ### 12:03:25 AM 1
00222 07:05:37 PM 1 ### 12:02:14 AM 1
00223 07:07:12 PM 2 ### 12:02:53 AM 1
00224 07:07:15 PM 3 ### 12:02:41 AM 1
00225 07:08:30 PM 3 ### 12:01:55 AM 1
00226 07:10:27 PM 3 ### 12:00:59 AM 0
00227 07:27:26 PM 0 ### 12:02:51 AM 1
00228 07:32:00 PM 0 ### 12:01:15 AM 0
00229 07:33:20 PM 0 ### 12:02:24 AM 1
00230 07:35:22 PM 1 ### 12:00:58 AM 0
00231 07:38:38 PM 0 ### 12:03:23 AM 1
00232 07:42:39 PM 0 ### 12:02:24 AM 1
00233 07:47:34 PM 0 ### 12:03:31 AM 1
00234 07:48:10 PM 1 ### 12:04:10 AM 1
00235 07:49:10 PM 2 ### 12:02:33 AM 1
00236 07:51:08 PM 2 ### 12:01:03 AM 0
00237 07:53:36 PM 3 ### 12:02:48 AM 1
00238 07:56:44 PM 3 ### 12:00:44 AM 0
00239 08:00:29 PM 2 ### 12:02:29 AM 1
00240 08:00:29 PM 3 ### 12:02:03 AM 1
00241 08:02:37 PM 2 ### 12:01:21 AM 0
00242 08:03:07 PM 3 ### 12:02:17 AM 1
00243 08:03:34 PM 4 ### 12:02:54 AM 1
00244 08:11:47 PM 1 ### 12:02:29 AM 1
00245 08:12:45 PM 2 ### 12:02:28 AM 1
00246 08:13:03 PM 3 ### 12:02:38 AM 1
00247 08:13:17 PM 4 ### 12:02:47 AM 1
00248 08:14:24 PM 4 ### 12:01:20 AM 0
00249 08:19:58 PM 3 ### 12:02:47 AM 1
00250 08:22:44 PM 3 ### 12:03:26 AM 1
Salida de la
Caja
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
###
1.- If X is a random variable with a distribution Poisson( 11,2 ) Which would be the probability of P( 10 < X <= 14 )?
< X <= 14 )?
2.- If X is a random varible that follows a distribution Normal( 3,8 ; 2,1 ) Which is the probability that P( 3,8 < X <= 6,1 ) ?
P( 3,8 < X <= 6,1 ) ?
3.- If the decission on how to pay follows a Bernouilli random variable with a common probability p=0,3 to pay with credit card
them and they are independent, which would be the probability that between 31 customers randomly chosen, less than 17 d
with credit card?
,3 to pay with credit card for all of
y chosen, less than 17 decide to pay
4.- If the number of customers that want to pay cash follows a Poisson distribution with average 32,2 customers per hour, wh
the probability that in the interval of 30 minutes inmediatelly after 19:00 arrive more than 21 customers?
customers per hour, which would be
ers?
5.- Assuming that the waiting time in the queue for a customer that wants to pay before 14:00 hours is normally distributed w
of 5 minutes and a standard deviation of 6 minute, which would be the probability that in that time interval this is less than 6
s normally distributed with an average
terval this is less than 6 minutes?
6.- If the decission on the payment method after 15:00 follows a Bernouilli random variable with the same parameter 'p' for al
customers and they are independent, which would be the estimation of the share of this kind of customers that decide to pay
ame parameter 'p' for all of the
mers that decide to pay cash?
7.- Assuming that the waiting time in the queue for the customers that want to pay between 14:00 and 20:30 is normally distr
standard deviation unknown, which is the point estimation of the mean of such waiting time?
d 20:30 is normally distributed with a
8.- Assuming that the waiting time in the queue for the population of customers that want to pay between 14:00 and 20:30 is
distributed with a standard deviation equal to 90 seconds, estimate a confidence interval for the average waiting time of this p
give as solution the interval lower limit, with a confidence level of 90%.
ween 14:00 and 20:30 is normally
age waiting time of this population and
9.- Assuming that the distribution of the waiting time in the queue for the population of customers that want to pay between
20:30 is unknown, estimate a confidence interval for the average waiting time of this population of customers and give as solu
interval lower limit, with a confidence level of 99%.
at want to pay between 14:00 and
stomers and give as solution the
10.- Assuming that the waiting time distribution in the cashier for the population of customers that want to pay with credit ca
decide if we can admit at 5% significance level, the hypothesis that the mean waiting time for this population is greater than 1
give as solution the sample significance that you used to take the decission.
ant to pay with credit card is unknown,
ulation is greater than 15 seconds; and