Katherine Gonzalez
Katherine Gonzalez
Katherine Gonzalez
RELACION DE TIEMPOS
TIEMPO DE TIEMPO DE
LLEGADA SERVICIO
No. (Minutos) (Minutos)
1 2.49 0.93
2 0.89 4.99
3 0.16 1.71
4 0.77 2.61
5 0.19 0.05
6 1.98 3.62
7 3 2.6
8 0.82 0.14
9 1.34 3.69
10 2.03 4.79
11 2.26 3.02
12 2.65 0.38
13 1.68 2.78
14 0.61 4.66
15 0.85 0.06
16 1.08 4.59
17 0.48 3.24
18 1.33 0.64
19 0.1 4.44
20 2.88 4.71
21 0.05 4.83
22 0.29 2.62
23 2.59 4.82
24 0.51 2.46
25 1.08 3.98
26 2.06 2.68
27 2.02 4.29
28 1.74 2.36
29 0.82 4.87
30 2.73 4.21
31 1.21 2.71
32 1.12 1.86
33 1.41 1.46
34 1.09 3.07
35 1.45 1.54
36 1.08 0.43
37 0.58 0.1
38 2.51 1.64
39 1.35 0.02
40 0.21 0.46
41 1.97 1.26
42 2.51 2.83
43 2.86 3.53
44 0.37 2.51
45 1.37 0.83
46 2.18 0.68
47 1.46 3.02
48 2.81 3.67
49 0.93 1.89
50 2.79 0.26
51 2.61 3.67
52 2.49 1.27
53 1.33 0.42
54 1.26 0.17
55 1.35 3.76
56 1.99 0.48
57 0.95 4.63
58 0.41 0.49
59 1.99 3.69
60 1.04 2.07
61 2.36 1.55
62 1.28 1.93
63 1.66 3.04
64 1.63 3.68
65 1.55 3.87
66 0.29 3.27
67 1.18 2.16
68 2.35 0.05
69 1.93 3.25
70 0.6 4.47
71 2.71 4.74
72 2.16 0.3
73 0.87 4.07
74 0.07 0.47
75 0.28 4.07
76 1.95 0.01
77 1.74 4.18
78 0.95 3.52
79 1.5 4.36
80 1.42 2.78
81 2.61 3.97
82 2.54 3.08
83 0.94 1.84
84 2.97 3.33
85 2.76 1.71
86 0.53 1.15
87 0.21 3.04
88 2.03 1.03
89 0.9 0.76
90 1.84 0.46
91 0.89 4
92 2.36 3.89
93 0.48 1.87
94 2.01 1.19
95 2.48 1.11
96 2.76 3.1
97 2.21 0.86
98 0.62 1.79
99 0.62 0.4
100 2.63 0.94
101 2.83 2.5
102 1.45 4.81
103 1.56 0.18
104 0.16 3.69
105 2.23 3.47
106 0.46 2.92
107 0.02 0.83
108 1.2 1.21
109 2.17 0.9
110 2.02 1.37
111 2.27 2.06
112 1.22 2.08
113 0.57 1.17
114 1.51 3.58
115 0.91 4.95
116 1.86 3.28
117 2.62 1.37
118 1.67 4.59
119 2.01 2.81
120 1.31 1.57
121 0.62 4.56
122 2.42 0.75
123 2.39 0.33
124 0.54 3.66
125 2.88 1.29
126 1.79 0.46
127 2.85 2.62
128 2.87 3.95
129 2.96 1.39
130 2.53 3.09
131 0.59 4.75
132 0.97 2.71
133 1.2 1.09
134 0.76 2.03
135 0.88 4.77
136 1.24 3.1
137 1.73 1.75
138 0.8 0.17
139 1.69 3.07
140 2.24 4.86
141 0.98 3.97
142 2.07 4.29
143 2.87 1.07
144 3 0.27
145 2.18 1.72
146 2.59 2.77
147 2.31 0.63
148 1.44 1.7
149 2.61 1.42
150 0.14 2.04
151 0.98 0.26
152 0.67 1.19
153 1.53 3.63
154 2.27 3.15
155 2.92 2.56
156 1.2 3.46
157 1.1 1.75
158 0.62 3.67
159 0.98 2.68
160 0.27 3.04
161 2.4 3.55
162 1.51 3.08
163 0.2 3.82
164 1.42 1.26
165 2.47 1.61
166 1.06 3.25
167 0.66 2.11
168 1.56 2.57
169 0.41 3.72
170 1.14 4.12
171 1.65 2.88
172 2.41 2.56
173 0.07 1.88
174 1.29 2.92
175 0.79 1.27
176 0.79 2.4
DISTRUBUCION EMPIRICA Máximo 3
Número total de datos 176 Minimo 0.02
Cantidad de clases 13.266649 Amplitud 0.22923076923077
m 13
TIEMPO DE
LLEGADA
(Minutos)
2.49
0.89
0.16
0.77
1.98
3 1 0.020 0.249 0.135
0.82 2 0.249 0.478 0.364
1.34 3 0.478 0.708 0.593
2.03 4 0.708 0.937 0.822
2.26 5 0.937 1.166 1.052
2.65 6 1.166 1.395 1.281
1.68 7 1.395 1.625 1.510
0.61 8 1.625 1.854 1.739
0.85 9 1.854 2.083 1.968
1.08 10 2.083 2.312 2.198
0.48 11 2.312 2.542 2.427
1.33 12 2.542 2.771 2.656
0.1 13 2.771 3 2.885
2.88 TOTAL
0.05
0.29
2.59
0.51
FRECUENCIA
1.08 1.2
2.06
1
2.02
1.74 0.8
0.82
2.73 0.6
0.4
0.2
0.8
0.6
1.21
0.4
1.12
1.41 0.2
1.09
1.45 0
1 2 3 4 5
1.08
0.58 FRECUENCIA RELATIVA ACUM
2.51
1.35
0.21
N° CLASE LIMITE INFERIOR LIMITE MARCA DE CLASE
SUPERIOR
1.97
2.51 1 0.02 0.24923077 0.13461538461539
2.86 2 0.24923077 0.47846154 0.36384615384615
0.37 3 0.47846154 0.70769231 0.59307692307692
1.37 4 0.70769231 0.93692308 0.82230769230769
2.18 5 0.93692308 1.16615385 1.05153846153846
1.46 6 1.16615385 1.39538462 1.28076923076923
2.81 7 1.39538462 1.62461538 1.51
0.93 8 1.62461538 1.85384615 1.73923076923077
2.79 9 1.85384615 2.08307692 1.96846153846154
2.61 10 2.08307692 2.31230769 2.19769230769231
2.49 11 2.31230769 2.54153846 2.42692307692308
1.33 12 2.54153846 2.77076923 2.65615384615385
1.26 13 2.77076923 3 2.88538461538461
1.35 TOTAL
1.99
0.95
0.41
FRECUENCIA RELATIVA ACUMULADA FRECUENCIA ACUMULADA
1.99
1.2
1.04
2.36
1
1.28
1.66
0.8
1.63
1.55 0.6
0.29
1.18 0.4
2.35
1.93 0.2
0.6
2.71 0
1 2 3 4 5 6 7 8 9
2.16
0.87
0.07
0.28
1.95
1.74 DISTRIBUCION CHI
0.95 LIMITE MARCA DE
N° CLASE LIMITE INFERIOR FRECUENCIA OBSERVADA
SUPERIOR CLASE
1.5
1.42 1 0 0.24923077 0.13461538 12
2.61 2 0.24923077 0.47846154 0.36384615 8
2.54 3 0.47846154 0.70769231 0.59307692 16
0.94 4 0.70769231 0.93692308 0.82230769 15
2.97 5 0.93692308 1.16615385 1.05153846 16
2.76 6 1.16615385 1.39538462 1.28076923 17
0.53 7 1.39538462 1.62461538 1.51 14
0.21 8 1.62461538 1.85384615 1.73923077 11
2.03 9 1.85384615 2.08307692 1.96846154 15
0.9 10 2.08307692 2.31230769 2.19769231 11
1.84 11 2.31230769 2.54153846 2.42692308 15
0.89 12 2.54153846 2.77076923 2.65615385 12
2.36 13 2.77076923 1E+11 2.88538462 14
0.48 TOTAL 176
2.01
2.48
2.76 GRADOS DE LIBERTAD 11 ALPHA
2.21 1-ALPHA
0.62
0.62 VALOR CRITICO
2.63 TABLA 19.68
2.83
1.45
1.56
0.16
2.23
0.46
0.02
1.2
2.17
2.02
2.27
1.22
0.57
1.51
0.91
1.86
2.62
1.67
2.01
1.31
0.62
2.42
2.39
0.54
2.88
1.79
2.85
2.87
2.96
2.53
0.59
0.97
1.2
0.76
0.88
1.24
1.73
0.8
1.69
2.24
0.98
2.07
2.87
3
2.18
2.59
2.31
1.44
2.61
0.14
0.98
0.67
1.53
2.27
2.92
1.2
1.1
0.62
0.98
0.27
2.4
1.51
0.2
1.42
2.47
1.06
0.66
1.56
0.41
1.14
1.65
2.41
0.07
1.29
0.79
0.79
FRECUENCIA OBSERVADA FRECUENCIA RELATIVA DATOS
EMPIRICA
MEDIA DE LA
DISTRUBUCION
EXPONENCIAL
0.6577131819
FRECUENCIA
FRECUENCIA OBSERVADA EXPONENCIAL FRECUENCIA ACUMULADA
EXPONENCIAL TEORICA
TEORICA
FRECUENCIA ACUMU
12 0.601983857114 0.0847319565478598 0.9
8 0.517734483595 0.212826353684162
0.8
16 0.445276052398 0.322993571241654
0.7
15 0.382958387208 0.417742569602958
16 0.329362258633 0.499231172923502 0.6
1 0.0681818181818
2 0.1136363636364
3 0.2045454545455
4 0.2897727272727
5 0.3806818181818
6 0.4772727272727
7 0.5568181818182
8 0.6193181818182
9 0.7045454545455
10 0.7670454545455
7 8 9 10 11 12 13
11 0.8522727272727
12 0.9204545454545
13 1
DISTRIBUCION CHI CUADRADO
AGRUPAMIENTO FRECUENCIA TEORICA AGRUPAMIENTO PRUEBA
0.05
0.95
CUENCIA ACUMULADA EXPONENCIAL TEORICA
3 4 5 6 7 8 9 10 11 12 13
FRECUENCIA
ACUMULADA
EXPONENCIAL
TEORICA
0.084731956548
0.212826353684
0.322993571242
0.417742569603
0.499231172924
0.569315211657
0.629590787444
0.681430622906
0.726015324182
0.764360268185
0.797338726904
0.825701755403
0.850095296424
DISTRUBUCION EMPIRICA Máximo
Número total de datos 176 Minimo
Cantidad de clases 13.266649 Amplitud
m 13
TIEMPO DE
SERVICIO
(Minutos)
0.93
4.99
1.71
2.61
N° CLASE LIMITE INFERIOR LIMITE SUPERIOR
0.05
3.62 1 0.01 0.39307692308
2.6 2 0.3930769230769 0.77615384615
0.14 3 0.7761538461538 1.15923076923
3.69 4 1.15923076923077 1.54230769231
4.79 5 1.54230769230769 1.92538461538
3.02 6 1.92538461538462 2.30846153846
0.38 7 2.30846153846154 2.69153846154
2.78 8 2.69153846153846 3.07461538462
4.66 9 3.07461538461539 3.45769230769
0.06 10 3.45769230769231 3.84076923077
4.59 11 3.84076923076923 4.22384615385
3.24 12 4.22384615384616 4.60692307692
0.64 13 4.60692307692308 4.99
4.44 TOTAL
FRECUENCIA RELATIVA A
4.71 FRECUENCIA RELATIVA ACUMULADA EX
Linear (FRECUENCIA RELATIVA ACUMU
4.83
1.2
1
2.62
4.82
2.46 0.8
0.630
0.6
0.534090909090
1
0.8
3.98
0.630
2.68
0.6
4.29 0.534090909090
2.36 0.454545454545455
4.87 0.409090909090909
0.4
4.21 0.318181818181818
2.71
0.232954545454545
1.86 0.170454545454545
0.2
1.46
0.0909090909090909
3.07
1.54 0
0.43 1 2 3 4 5 6 7
0.1
1.64
DISTRIB
0.02
0.46
N° CLASE LIMITE INFERIOR LIMITE SUPERIOR
1.26
2.83 1 0.01 0.39307692308
3.53 2 0.3930769230769 0.77615384615
2.51 3 0.7761538461538 1.15923076923
0.83 4 1.15923076923077 1.54230769231
0.68 5 1.54230769230769 1.92538461538
3.02 6 1.92538461538462 2.30846153846
3.67 7 2.30846153846154 2.69153846154
1.89 8 2.69153846153846 3.07461538462
0.26 9 3.07461538461539 3.45769230769
3.67 10 3.45769230769231 3.84076923077
1.27 11 3.84076923076923 4.22384615385
0.42 12 4.22384615384616 4.60692307692
0.17 13 4.60692307692308 4.99
3.76 TOTAL
0.48
4.63
0.49
3.69 1.2
1
2.07
1.55
0.8
1.93
3.04
3.68 0.6
3.87
3.27 0.4
2.16
0.2
0
1 2 3 4 5 6
0.6
0.4
0.05 0.2
3.25
4.47 0
1 2 3 4 5 6
4.74
0.3 FRECUENCIA RELATIVA ACUMULADA EMPIRICA
4.07
0.47
4.07
0.01
4.18
N° CLASE LIMITE INFERIOR LIMITE SUPERIOR
3.52
4.36 1 0 0.39307692308
2.78 2 0.3930769230769 0.77615384615
3.97 3 0.7761538461538 1.15923076923
3.08 4 1.15923076923077 1.54230769231
1.84 5 1.54230769230769 1.92538461538
3.33 6 1.92538461538462 2.30846153846
1.71 7 2.30846153846154 2.69153846154
1.15 8 2.69153846153846 3.07461538462
3.04 9 3.07461538461539 3.45769230769
1.03 10 3.45769230769231 3.84076923077
0.76 11 3.84076923076923 4.22384615385
0.46 12 4.22384615384616 4.60692307692
4 13 4.60692307692308 10000000000
3.89 TOTAL
1.87
1.19
1.11 GRADOS DE LIBERTAD 11
3.1
0.86
1.79 VALOR CRITICO
0.4 TABLA 19.68
0.94
2.5
4.81
0.18
3.69
3.47
2.92
0.83
1.21
0.9
1.37
2.06
2.08
1.17
3.58
4.95
3.28
1.37
4.59
2.81
1.57
4.56
0.75
0.33
3.66
1.29
0.46
2.62
3.95
1.39
3.09
4.75
2.71
1.09
2.03
4.77
3.1
1.75
0.17
3.07
4.86
3.97
4.29
1.07
0.27
1.72
2.77
0.63
1.7
1.42
2.04
0.26
1.19
3.63
3.15
2.56
3.46
1.75
3.67
2.68
3.04
3.55
3.08
3.82
1.26
1.61
3.25
2.11
2.57
3.72
4.12
2.88
2.56
1.88
2.92
1.27
2.4
4.99
0.01
0.38307692
3
1
0.920454545454545
0.875
0.806818181818182
0.698863636363636
0.630681818181818
0.534090909090909
0.920454545454545
0.875
0.806818181818182
0.698863636363636
0.630681818181818
0.534090909090909
0.454545454545455
0.409090909090909
81818181818
45
4 5 6 7 8 9 10 11 12 13
DISTRIBUCIÓN EXPONENCIAL
MARCA DE FRECUENCIA OBSERVADA FRECUENCIA EXPONENCIAL TEORICA FRECUENCIA RELATIVA ACUMULADA EXPONENCIAL
CLASE TEORICA
4 5 6 7 8 9 10 11 12 13
4 5 6 7 8 9 10 11 12 13
0.20153846 16 16 26.1320103393013
0.58461538 14 14 21.7291090612917
0.96769231 11 11 18.5786418957117
1.35076923 15 15 15.8849556930972
1.73384615 16 16 13.5818225459151
2.11692308 8 8 11.612616820133
2.5 14 14 9.92892293765058
2.88307692 17 17 8.48934501402711
3.26615385 12 12 7.25848908484332
3.64923077 19 19 6.20609289735969
4.03230769 12 12 5.30628187222654
4.41538462 8 4.53693294206068
4.79846154 14 22 26.754778896382
176 176
ALPHA 0.05
1-ALPHA 0.95
DATOS
0.0183216783216783
0.0465034965034965
0.0604807692307692
0.115122377622378
0.157622377622378
0.0962237762237762
0.198863636363636
0.278479020979021
0.222692307692308
0.393951048951049
0.27493006993007
0.200699300699301
0.381695804195804
MEDIA DE LA
DISTRUBUCION EMPIRICA 2.45
MEDIA DE LA
DISTRUBUCION
EXPONENCIAL
0.41
FRECUENCIA ACUMULADA EXPONENCIAL TEORICA
Column K Logarithmic (Column K)
1
0.9
0.
0.8077215412
0.8 0.775115984003854
0.736981350028098
0.692380047881093
0.7
0.640215494407914
0.6 0.579205153721283
0.507849004327372
0.5
0.42439265907471
0.4
0.326784231180392
0.3
0.21262388582671
0.2
0.0791048369861453
0.1
0
1 2 3 4 5 6 7 8 9 10 11
FRECUENCIA ACUMULADA
N° CLASE FRECUENCIA RELATIVA ACUMULADA EMPIRICA EXPONENCIAL TEORICA
1 0.0909090909090909 0.079104836986145
2 0.170454545454545 0.21262388582671
3 0.232954545454545 0.326784231180392
4 0.318181818181818 0.42439265907471
5 0.409090909090909 0.507849004327372
6 0.454545454545455 0.579205153721283
7 0.534090909090909 0.640215494407914
8 0.630681818181818 0.692380047881093
9 0.698863636363636 0.736981350028098
10 0.806818181818182 0.775115984003854
11 0.875 0.80772154120646
12 0.920454545454545 0.835599673225986
13 1 0.859435801529783
AGRUPAMIENTO PRUEBA
26.1320103393013 3.92842464788544
21.7291090612917 2.74926720248098
18.5786418957117 3.09149685460563
15.8849556930972 0.0493011497089311
13.5818225459151 0.43054473578019
11.612616820133 1.12386385353569
9.92892293765058 1.66923125012281
8.48934501402711 8.53201845025567
7.25848908484332 3.09732858942988
6.20609289735969 26.3747355474856
5.30628187222654 8.44392805602736
31.2917118384427 2.75906634109389
62.249206678412
IAL TEORICA
K)
0.859435801529783
0.835599673225986
0.80772154120646
0.775115984003854
6981350028098
093
9 10 11 12 13
TAREA 2 - SOLUCION DE MODELOS PROBABILISTICOS DE DECISION
DEMANDA
PERIODICA
Periodo (unidades) TENDENCIA (unidades)
1 6134 587
2 6688 COEFICIENTES
3 6717 α = 2/n+1
4 6509 β = 2α
5 5876 PERIODOS
6 5825 n = 10
7 6485
8 5239
9 5282
10 5269
α 0.181818
PERIODO PRONOSTICO Ft
No existe
11 6134
12 6134
13 6234.727
14 6322.413
15 6356.338
16 6269.004
17 6188.276
18 6242.226
19 6059.821
20 5918.399
2. MODELO DE PRONOSTI
COEFICIENTE DE SUAVIZA
α
β
PRON
PERIODO t
1
2
3
4
5
6
7
8
9
10
11
. MODELO DE PRONOSTICO SUAVIZACION EXPONENCIAL DOBLE.
COEFICIENTE DE SUAVIZACION
0.181818
0.36363636363636
PRONOSTICO EXPONENCIAL DOBLE
(UNIDADES) Dt TENDENCIA N
periodica (UNIDADES) PRONOSTIC PRONOSTICO
(unidades) Dt Tt O At AJUSTADO Ft+1
6134 587 6134 NO EXISTE
6688 548.190 6614.273 6721
6717 516.821 7076.197 7162.463
6509 458.902 7433.742 7593.017
5876 367.422 7641.072 7892.644
5825 226.430 7620.768 8008.494
6485 92.731 7479.525 7847.198
5239 20.846 7374.574 7572.257
5282 -121.727 7003.344 7395.420
5269 -227.487 6590.778 6881.617
6363.291