Estimations par Médias Mobiles
Estimations par Médias Mobiles
1 110.06
2 107.72 108.89
3 110.18 108.95 108.89 1.29 109.32
4 111.44 110.81 108.95 2.49 109.78 109.32 2.12 109.85
5 109.1 110.27 110.81 -1.71 110.24 109.78 -0.68 109.61 109.85 -0.75
6 107.96 108.53 110.27 -2.31 109.50 110.24 -2.28 109.67 109.61 -1.65
7 110.42 109.19 108.53 1.89 109.16 109.50 0.92 109.73 109.67 0.75
8 108.08 109.25 109.19 -1.11 108.82 109.16 -1.08 108.89 109.73 -1.65
9 108.14 108.11 109.25 -1.11 108.88 108.82 -0.68 108.65 108.89 -0.75
10 110.6 109.37 108.11 2.49 108.94 108.88 1.72 109.31 108.65 1.95
11 109.46 110.03 109.37 0.09 109.40 108.94 0.52 109.07 109.31 0.15
12 110.72 110.09 110.03 0.69 110.26 109.40 1.32 109.73 109.07 1.65
13 110.78 110.75 110.09 0.69 110.32 110.26 0.52 110.39 109.73 1.05
14 112.04 111.41 110.75 1.29 111.18 110.32 1.72 110.75 110.39 1.65
15 112.1 112.07 111.41 0.69 111.64 111.18 0.92 111.41 110.75 1.35
16 113.36 112.73 112.07 1.29 112.50 111.64 1.72 112.07 111.41 1.95
17 111.02 112.19 112.73 -1.71 112.16 112.50 -1.48 112.13 112.07 -1.05
18 108.68 109.85 112.19 -3.51 111.02 112.16 -3.48 111.29 112.13 -3.45
19 112.34 110.51 109.85 2.49 110.68 111.02 1.32 111.35 111.29 1.05
20 112.4 112.37 110.51 1.89 111.14 110.68 1.72 111.11 111.35 1.05
21 113.66 113.03 112.37 1.29 112.80 111.14 2.52 111.77 111.11 2.55
22 112.52 113.09 113.03 -0.51 112.86 112.80 -0.28 112.73 111.77 0.75
23 111.38 111.95 113.09 -1.71 112.52 112.86 -1.48 112.49 112.73 -1.35
24 110.24 110.81 111.95 -1.71 111.38 112.52 -2.28 111.95 112.49 -2.25
25 112.7 111.47 110.81 1.89 111.44 111.38 1.32 111.71 111.95 0.75
26 112.76 112.73 111.47 1.29 111.90 111.44 1.32 111.77 111.71 1.05
27 114.02 113.39 112.73 1.29 113.16 111.90 2.12 112.43 111.77 2.25
28 114.08 114.05 113.39 0.69 113.62 113.16 0.92 113.39 112.43 1.65
29 114.14 114.11 114.05 0.09 114.08 113.62 0.52 113.75 113.39 0.75
30 113 113.57 114.11 -1.11 113.74 114.08 -1.08 113.81 113.75 -0.75
31 111.86 112.43 113.57 -1.71 113.00 113.74 -1.88 113.27 113.81 -1.95
32 110.72 111.29 112.43 -1.71 111.86 113.00 -2.28 112.43 113.27 -2.55
33 111.98 111.35 111.29 0.69 111.52 111.86 0.12 111.89 112.43 -0.45
34 113.24 112.61 111.35 1.89 111.98 111.52 1.72 111.95 111.89 1.35
35 109.7 111.47 112.61 -2.91 111.64 111.98 -2.28 111.41 111.95 -2.25
36 109.76 109.73 111.47 -1.71 110.90 111.64 -1.88 111.17 111.41 -1.65
37 109.82 109.79 109.73 0.09 109.76 110.90 -1.08 110.63 111.17 -1.35
38 113.48 111.65 109.79 3.69 111.02 109.76 3.72 110.69 110.63 2.85
39 114.74 114.11 111.65 3.09 112.68 111.02 3.72 111.95 110.69 4.05
40 112.4 113.57 114.11 -1.71 113.54 112.68 -0.28 112.61 111.95 0.45
41 120.252 117.0768 109.53
42
43
44
45
Mt (r=3) at=Zt-Mt Mt (r=4) at=Zt-Mt MEDIAS MÓVILES SIMPLES
114
112
110
108
106
113.54
1.45 104
1 3 5 7 9 11 13 15 17 19 21
112.61 Zt
1.80
120.25 Con r=4 se obtiene mayor precisión que con r=2 y r=3
117.08
109.53
9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39
Zt Mt (r=3)
α=0.2 α=0.5 α=0.8
t Zt Zt* Zt-1(1) Zt-Zt-1(1) Zt* Zt-1(1) Zt-Zt-1(1) Zt*
1 125 125.00 125.00 125.00
2 123.3 124.66 125.00 -1.70 124.15 125.00 -1.70 123.64
3 125.1 124.75 124.66 0.44 124.63 124.15 0.95 124.81
4 126.1 125.02 124.75 1.35 125.36 124.63 1.47 125.84
5 124.3 124.87 125.02 -0.72 124.83 125.36 -1.06 124.61
6 123.5 124.60 124.87 -1.37 124.17 124.83 -1.33 123.72
7 125.3 124.74 124.60 0.70 124.73 124.17 1.13 124.98
8 123.6 124.51 124.74 -1.14 124.17 124.73 -1.13 123.88
9 123.6 124.33 124.51 -0.91 123.88 124.17 -0.57 123.66
10 125.5 124.56 124.33 1.17 124.69 123.88 1.62 125.13
11 124.6 124.57 124.56 0.04 124.65 124.69 -0.09 124.71
12 125.5 124.76 124.57 0.93 125.07 124.65 0.85 125.34
13 125.6 124.93 124.76 0.84 125.34 125.07 0.53 125.55
14 126.5 125.24 124.93 1.57 125.92 125.34 1.16 126.31
15 126.6 125.51 125.24 1.36 126.26 125.92 0.68 126.54
16 127.5 125.91 125.51 1.99 126.88 126.26 1.24 127.31
17 125.8 125.89 125.91 -0.11 126.34 126.88 -1.08 126.10
18 124 125.51 125.89 -1.89 125.17 126.34 -2.34 124.42
19 126.8 125.77 125.51 1.29 125.98 125.17 1.63 126.32
20 126.8 125.97 125.77 1.03 126.39 125.98 0.82 126.70
21 127.7 126.32 125.97 1.73 127.05 126.39 1.31 127.50
22 126.9 126.44 126.32 0.58 126.97 127.05 -0.15 127.02
23 126 126.35 126.44 -0.44 126.49 126.97 -0.97 126.20
24 125.2 126.12 126.35 -1.15 125.84 126.49 -1.29 125.40
25 127 126.30 126.12 0.88 126.42 125.84 1.16 126.68
26 127.1 126.46 126.30 0.80 126.76 126.42 0.68 127.02
27 128 126.76 126.46 1.54 127.38 126.76 1.24 127.80
28 128.1 127.03 126.76 1.34 127.74 127.38 0.72 128.04
29 128.1 127.25 127.03 1.07 127.92 127.74 0.36 128.09
30 127.3 127.26 127.25 0.05 127.61 127.92 -0.62 127.46
31 126.4 127.09 127.26 -0.86 127.01 127.61 -1.21 126.61
32 125.5 126.77 127.09 -1.59 126.25 127.01 -1.51 125.72
33 126.5 126.71 126.77 -0.27 126.38 126.25 0.25 126.34
34 127.4 126.85 126.71 0.69 126.89 126.38 1.02 127.19
35 124.8 126.44 126.85 -2.05 125.84 126.89 -2.09 125.28
36 124.8 126.11 126.44 -1.64 125.32 125.84 -1.04 124.90
37 124.9 125.87 126.11 -1.21 125.11 125.32 -0.42 124.90
38 127.6 126.22 125.87 1.73 126.36 125.11 2.49 127.06
39 128.6 126.69 126.22 2.38 127.48 126.36 2.24 128.29
40 126.8 126.71 126.69 0.11 127.14 127.48 -0.68 127.10
59.87 59.57
45
α=0.8 para α=0,5
Zt-1(1) Zt-Zt-1(1) Zt-Zt*
0.00 SUAVIZACIÓN EXPONENCIAL SIMPLE
125.00 -1.70 -0.85
123.64 1.46 0.47 1)Para α=0,2; 0,5 y 0,8 obtenga los valores suavizados de Zt mediante
124.81 1.29 0.74 2) Elija utilizando el backforecasting (predicción a u paso) el valor mas
125.84 -1.54 -0.53 3) Obtenga un IC del 95% para Z45
124.61 -1.11 -0.67
123.72 1.58 0.57 SOLUCION:
124.98 -1.38 -0.57 1)
123.88 -0.28 -0.28
123.66 1.84 0.81
125.13 -0.53 -0.05
124.71 0.79 0.43 2) para α=0,2 59.87
125.34 0.26 0.26 para α=0,5 59.57
125.55 0.95 0.58 para α=0,8 63.37
126.31 0.29 0.34
126.54 0.96 0.62
127.31 -1.51 -0.54 3)
126.10 -2.10 -1.17
124.42 2.38 0.82
126.32 0.48 0.41
126.70 1.00 0.65
127.50 -0.60 -0.07 para α = 0.5
127.02 -1.02 -0.49 Z0.975= 1.96
126.20 -1.00 -0.64 IC 126.4423
125.40 1.60 0.58
126.68 0.42 0.34
127.02 0.98 0.62
127.80 0.30 0.36
128.04 0.06 0.18
128.09 -0.79 -0.31
127.46 -1.06 -0.61
126.61 -1.11 -0.75
125.72 0.78 0.12
126.34 1.06 0.51
127.19 -2.39 -1.04
125.28 -0.48 -0.52
124.90 0.00 -0.21
124.90 2.70 1.24
127.06 1.54 1.12
128.29 -1.49 -0.34
63.37 0.38
a los valores suavizados de Zt mediante la suavización exponencial simple
sting (predicción a u paso) el valor mas adecuado de α.
Con α=0,5 se optiene una mayor exactitud que con α=0,2 y α=0,8. Por lo tanto, es el valor mas adecuado para
h
65 90.9684 1
66 89.3285 2
67 87.6886 3
68 86.0487 4
69 84.4088 5
α=0,75
b1,t b2,t Zt (1) Zt-Zt-1(1)=at SUAVIZACIÓN EXPONENCIAL LINEAL DE BROWN
144.2 0
152.825 5.175 144.2 9.2
146.375 -1.8 158 -12.4
152.2859375 2.82656 144.575 8.2
149.38203125 -0.61172 155.112 -6.1
153.86064453 2.44248 148.77 5.4
154.51894531 1.37197 156.303 -1.9
149.99318237 -2.16667 155.891 -6.3
139.3641571 -7.24408 147.827 -9.0
142.32000465 -1.12412 132.12 10.9
144.94974251 1.12819 141.196 4.0
131.37987096 -7.69065 146.078 -15.7
132.98057657 -2.11583 123.689 9.9
145.80404635 6.84775 130.865 15.9
147.35323714 3.66861 152.652 -5.7 1) Obtenga los valores de b1,t y b2,t a través de la suavizacón exp
136.18886567 -5.23118 151.022 -15.8 2) determine el valor de α más adecuado
135.12235552 -2.73238 130.958 4.4 3) Obtenga el valor estimado de Z69
127.89937365 -5.42674 132.39 -4.8
130.27953961 -0.7426 122.473 8.3 SOLUCIÓN:
129.03355895 -1.04463 129.537 -0.5
127.24930825 -1.4884 127.989 -0.8 1) Resuelto
122.61005669 -3.37891 125.761 -3.4
125.20194658 0.20357 119.231 6.4 2) para α=0.25 S = 2987.16
125.77534475 0.42547 125.406 0.4 para α=0.75 S = 5238.60
130.70005071 3.12501 126.201 4.8
135.11406631 3.89841 133.825 1.4 3)
138.43827999 3.55389 139.012 -0.6
132.24951085 -2.2917 141.992 -10.4
121.37236293 -7.44297 129.958 -9.2
122.43308703 -2.34075 113.929 9.1
131.44327083 4.46981 120.092 12.1 Z69 = 84.4088
133.55706748 3.0562 135.913 -2.5
130.97582931 -0.32626 136.613 -6.0
119.54059794 -6.99164 130.65 -11.8
113.90930964 -6.17543 112.549 1.5
123.17086745 3.08676 107.734 16.5
121.70360187 0.35435 126.258 -4.9
111.31612172 -6.09075 122.058 -11.5
122.63908574 4.35748 105.225 18.6
116.68728526 -1.82809 126.997 -11.0
117.99119977 0.05111 114.859 3.3
107.12764456 -6.49769 118.042 -11.6
123.10187229 6.98546 100.63 24.0
117.63045836 -0.48866 130.087 -13.3
117.94636216 -0.00592 117.142 0.9
120.99627743 1.82758 117.94 3.3
120.55149108 0.46416 122.824 -2.4
120.6259782 0.23036 121.016 -0.4
113.30352091 -4.30133 120.856 -8.1
103.37513682 -7.67756 109.002 -6.0
105.54359835 -1.76995 95.6976 10.5
115.61085312 5.33237 103.774 12.6
112.18395167 0.07681 120.943 -9.3
107.14129751 -2.99487 112.261 -5.5
114.32165178 3.11026 104.146 10.9
109.71449479 -1.52019 117.432 -8.2
111.19964416 0.28301 108.194 3.2
109.71766616 -0.77598 111.483 -1.9
98.496355318 -7.04318 108.942 -11.1
95.715823524 -4.48559 91.4532 4.5
94.951889555 -2.2526 91.2302 4.0
90.543705807 -3.54595 92.6993 -2.3
98.812359806 3.54281 86.9978 12.6
92.45969829 -2.39447 102.355 -10.6
S= 5238.60
EAL DE BROWN
Chart Title
180.0
160.0
140.0
120.0
100.0
80.0
60.0
40.0
20.0
0.0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58 61 64
Zt Zt* Zt**
65
66
67
68
69
A=0,2 C=0,9
Zt(1) Zt-Zt-1(1) SUAVIZACIÓN EXPONENCIAL BIPARAMÉTRICA DE HO
162.60 -17.00
165.34 -12.54
166.71 -17.71
163.87 -9.67
160.89 -6.49
157.38 -7.78
152.21 -13.41
143.50 -0.50
137.28 7.92
134.18 -3.78
128.05 5.55
124.79 22.01
128.78 18.22
135.29 -0.09
138.13 -2.73
139.94 -12.34
137.62 -6.82 1)Para (A=0,4 , C=0,8); asi como para (A=0,2 y C=0,9) obtenga los valore
135.17 -6.17 2) determine el par (A, C) más adecuado.
131.74 -4.54 3) Obtenga el valor estimado de Z69
127.82 -5.42
122.74 2.86 SOLUCIÓN:
119.84 5.96
118.63 12.37 1) Resuelto
120.93 14.27 Zt* = Nivel
126.18 12.22 Tt* = Tendencia
133.22 -1.62
137.20 -16.40 2) El par ordenado mas adecuado que minimiza la suma de c
135.27 -12.27 (A=0.4, C=0.8)
131.96 0.24
131.19 2.21 3) Z69 = Z64+5 = Z64(5) = Z64* + 5*T64
131.22 -0.62
130.57 -11.77
125.57 -11.57
118.53 5.67
115.96 5.44
114.32 -3.72
110.18 13.62
111.96 4.04
112.55 5.65
114.48 -8.08
112.21 12.39
116.26 0.54
118.04 -0.04
119.70 1.50
121.93 -1.53
123.29 -2.69
123.92 -11.12
120.87 -17.87
113.25 -7.05
106.53 9.87
104.97 6.63
103.95 2.85
102.69 12.31
105.54 3.66
107.32 4.08
109.91 -0.31
111.57 -13.77
108.06 -12.06
102.72 -7.52
96.94 -6.54
90.17 9.43
88.30 3.50
5503.98
CIAL BIPARAMÉTRICA DE HOLT
93.727114 (Zt)
α=0,25
t Zt Zt* Zt** Zt*** b1,t b2,t b3,t Zt-1(1)
1 437.9 437.9 437.9 437.9 437.9 0.00 0
2 415.6 432.325 436.5062 437.5516 425.0078 -3.7E+00 -0.34844 4.4E+02
3 416.1 428.2687 434.4469 436.7754 418.241 -4.8E+00 -0.42773 4.2E+02
4 425.4 427.5516 432.723 435.7623 420.2479 -3.3E+00 -0.23691 4.1E+02
5 436.5 429.7887 431.9895 434.8191 428.2167 -2.8E-01 0.069873 4.2E+02
6 405.4 423.6915 429.915 433.5931 414.9227 -3.9E+00 -0.28282 4.3E+02
7 423.1 423.5436 428.3221 432.2753 417.9398 -2.2E+00 -0.0917 4.1E+02
8 409.6 420.0577 426.256 430.7705 412.1756 -3.3E+00 -0.18709 4.2E+02
9 430.9 422.7683 425.3841 429.4239 421.5765 1.6E-01 0.158223 4.1E+02
10 444.0 428.0762 426.0571 428.5822 434.6395 4.0E+00 0.504908 4.2E+02
11 468.9 438.2822 429.1134 428.715 456.2213 9.4E+00 0.974488 4.4E+02
12 454.6 442.3616 432.4254 429.6426 459.4511 8.5E+00 0.794816 4.7E+02
13 473.1 450.0462 436.8306 431.4396 471.0864 1.0E+01 0.869396 4.7E+02
14 490.4 460.1347 442.6566 434.2439 486.6779 1.2E+01 1.00725 4.8E+02
15 488.5 467.226 448.799 437.8827 493.1637 1.2E+01 0.834521 5.0E+02
16 464.4 466.5195 453.2291 441.7193 481.5904 5.7E+00 0.197838 5.1E+02
17 470.1 467.4146 456.7755 445.4833 477.4007 3.1E+00 -0.07256 4.9E+02
18 445.6 461.961 458.0719 448.6305 460.2978 -2.7E+00 -0.61692 4.8E+02
19 440.9 456.6957 457.7278 450.9048 447.8085 -6.0E+00 -0.87279 4.6E+02
20 448.0 454.5218 456.9263 452.4102 445.1966 -5.8E+00 -0.76896 4.4E+02
21 476.9 460.1163 457.7238 453.7386 460.9162 -3.5E-01 -0.17697 4.4E+02
22 462.6 460.7373 458.4772 454.9232 461.7035 -1.8E-01 -0.14376 4.6E+02
23 493.1 468.8279 461.0649 456.4586 479.7479 4.9E+00 0.35076 4.6E+02
24 474.4 470.221 463.3539 458.1825 478.7836 3.5E+00 0.188403 4.8E+02
25 521.5 483.0407 468.2756 460.7057 505.0011 1.0E+01 0.799474 4.8E+02
26 523.4 493.1305 474.4893 464.1516 520.0753 1.2E+01 0.922612 5.2E+02
27 520.1 499.8729 480.8352 468.3225 525.4356 1.1E+01 0.724999 5.3E+02
28 495.6 498.8047 485.3276 472.5738 513.0051 5.0E+00 0.080367 5.4E+02
29 494.9 497.8285 488.4528 476.5436 504.6706 1.3E+00 -0.28151 5.2E+02
30 491.0 496.1214 490.37 480 497.2544 -1.4E+00 -0.51315 5.1E+02
31 467.9 489.066 490.044 482.5111 479.5773 -6.5E+00 -0.94565 5.0E+02
32 477.6 486.1995 489.0829 484.1541 475.504 -6.6E+00 -0.86802 4.7E+02
33 482.1 485.1746 488.1058 485.142 476.3485 -5.2E+00 -0.655 4.7E+02
34 503.4 489.731 488.5121 485.9845 489.6412 -5.4E-01 -0.14541 4.7E+02
35 509.5 494.6732 490.0524 487.0015 500.864 2.7E+00 0.174439 4.9E+02
36 513.4 499.3549 492.378 488.3456 509.2763 4.5E+00 0.327167 5.0E+02
37 507.1 501.2912 494.6063 489.9108 509.9654 3.7E+00 0.22104 5.1E+02
38 513.6 504.3684 497.0468 491.6948 513.6595 3.9E+00 0.218837 5.1E+02
39 482.9 499.0013 497.5355 493.155 497.5525 -1.6E+00 -0.32385 5.2E+02
40 477.0 493.501 496.5268 493.9979 484.9204 -5.0E+00 -0.6172 5.0E+02
41 456.9 484.3507 493.4828 493.8692 466.4729 -9.4E+00 -0.97175 4.8E+02
42 466.6 479.913 490.0904 492.9245 462.3925 -8.7E+00 -0.81591 4.6E+02
43 461.1 475.2098 486.3702 491.2859 457.8046 -8.2E+00 -0.69386 4.5E+02
44 449.4 468.7573 481.967 488.9562 449.3272 -8.9E+00 -0.69117 4.5E+02
45 447.5 463.443 477.336 486.0511 444.3721 -8.4E+00 -0.57532 4.4E+02
46 480.4 467.6823 474.9226 483.269 461.5481 -1.6E+00 0.122901 4.4E+02
47 466.1 467.2867 473.0136 480.7051 463.5244 -4.9E-01 0.218293 4.6E+02
48 458.6 465.115 471.039 478.2886 460.5168 -1.0E+00 0.147301 4.6E+02
49 474.9 467.5613 470.1695 476.2588 468.434 1.6E+00 0.386781 4.6E+02
50 456.0 464.6709 468.7949 474.3928 462.021 -3.1E-01 0.16378 4.7E+02
51 470.9 466.2282 468.1532 472.8329 467.0579 1.3E+00 0.306079 4.6E+02
52 443.6 460.5712 466.2577 471.1891 454.1295 -2.4E+00 -0.0839 4.7E+02
53 422.1 450.9534 462.4316 469 434.565 -7.4E+00 -0.54557 4.5E+02
54 425.4 444.565 457.965 466.2411 426.0412 -8.2E+00 -0.56932 4.3E+02
55 417.5 437.7988 452.9234 462.9116 417.5377 -8.8E+00 -0.57071 4.2E+02
56 420.4 433.4491 448.0548 459.1974 415.3802 -7.4E+00 -0.38479 4.1E+02
57 396.1 424.1118 442.0691 454.9154 401.0435 -9.7E+00 -0.56789 4.1E+02
58 410.6 420.7339 436.7353 450.3703 402.3661 -7.0E+00 -0.26293 3.9E+02
59 423.9 421.5254 432.9328 446.0109 411.7887 -2.6E+00 0.185637 4.0E+02
60 414.0 419.644 429.6106 441.9109 412.0112 -1.6E+00 0.259298 4.1E+02
61 410.9 417.458 426.5725 438.0763 410.733 -1.3E+00 0.265485 4.1E+02
62 388.6 410.2435 422.4902 434.1798 397.4396 -4.5E+00 -0.06191 4.1E+02
63 415.1 411.4576 419.7321 430.5678 405.7445 -9.1E-01 0.28459 3.9E+02
64 361.4 398.9432 414.5349 426.5596 379.7847 -7.8E+00 -0.39632 4.1E+02
65 359.5 389.0824 408.1718 421.9626 364.6946 -1.0E+01 -0.58872 3.7E+02
66 357.4 381.1618 401.4193 416.8268 356.0544 -1.0E+01 -0.53888 3.5E+02
67 348.1 372.8964 394.2885 411.1922 347.0157 -1.0E+01 -0.49872 3.5E+02
68 348.6 366.8223 387.422 405.2497 343.4506 -8.9E+00 -0.308 3.4E+02
69 328.9 357.3417 379.9019 398.9127 331.2321 -1.0E+01 -0.39438 3.3E+02
70 333.0 351.2563 372.7405 392.3697 327.917 -8.5E+00 -0.20612 3.2E+02
71 347.9 350.4172 367.1597 386.0672 335.8398 -4.0E+00 0.240558 3.2E+02
72 302.6 338.4629 359.9855 379.5468 314.979 -8.6E+00 -0.21792 3.3E+02
73 324.1 334.8722 353.7072 373.0869 316.5819 -5.9E+00 0.060524 3.1E+02
74 318.4 330.7541 347.9689 366.8074 315.1631 -4.6E+00 0.180411 3.1E+02
75 302.5 323.6906 341.8993 360.5804 305.9542 -5.7E+00 0.052478 3.1E+02
76 262.4 308.368 333.5165 353.8144 278.3688 -1.2E+01 -0.53896 3.0E+02
77 266.1 297.801 324.5876 346.5077 266.1478 -1.2E+01 -0.54073 2.7E+02
78 245.6 284.7507 314.6284 338.5379 248.9049 -1.4E+01 -0.66313 2.5E+02
79 213.9 267.038 302.7308 329.5861 222.5078 -1.8E+01 -0.98194 2.3E+02
80 226.0 256.7785 291.2427 320 216.6077 -1.6E+01 -0.63407 2.0E+02
81 238.9 252.3089 281.5093 310.3775 222.7764 -1.0E+01 -0.0369 2.0E+02
82 221.6 244.6317 272.2899 300.8556 217.881 -8.6E+00 0.100837 2.1E+02
83 229.1 240.7488 264.4046 291.7428 220.7753 -5.2E+00 0.409157 2.1E+02
84 219.4 235.4116 257.1563 283.0962 217.8619 -4.2E+00 0.466124 2.2E+02
S=
85
86
87
88
α=0,60
Zt-Zt-1(1) Zt* Zt** Zt*** b1,t b2,t b3,t Zt-1(1)
437.9 437.9 437.9 437.9 -2.13E-13 0
-2.2E+01 424.52 429.872 435.893 419.837 -5.27E+00 1.50525 4.38E+02
-4.9E+00 419.468 423.6296 432.8271 420.3423 1.45E+01 11.33089 4.16E+02
1.2E+01 423.0272 423.2682 430.4374 429.7145 2.82E+01 15.58864 4.46E+02
2.0E+01 431.1109 427.9738 429.8215 439.2328 2.53E+01 11.21579 4.74E+02
-2.3E+01 415.6844 420.6001 427.5162 412.7688 8.77E-01 4.500569 4.76E+02
1.2E+01 420.1337 420.3203 425.7172 425.1575 2.12E+01 11.72327 4.18E+02
-6.1E+00 413.8135 416.4162 423.3919 415.5838 1.41E+01 9.839277 4.58E+02
2.2E+01 424.0654 421.0057 422.7954 431.9744 2.46E+01 10.91101 4.40E+02
2.2E+01 436.0262 430.018 424.601 442.6256 1.15E+01 1.330264 4.67E+02
3.0E+01 455.7505 445.4575 429.8151 460.6941 -6.63E+00 -12.036 4.55E+02
-1.2E+01 455.0602 451.2191 435.1661 446.6894 -4.46E+01 -27.4767 4.42E+02
4.4E+00 465.8841 460.0181 441.3791 458.9771 -4.39E+01 -28.7392 3.75E+02
8.4E+00 480.5936 472.3634 449.1252 473.8158 -4.96E+01 -33.768 3.86E+02
-1.2E+01 485.3375 480.1478 456.8809 472.4497 -6.68E+01 -40.6741 3.90E+02
-4.1E+01 472.775 475.7241 461.5917 452.7442 -7.49E+01 -38.4336 3.65E+02
-1.7E+01 471.17 472.9916 464.4417 458.9767 -4.55E+01 -23.3362 3.39E+02
-3.5E+01 455.828 462.6935 464.0046 443.4082 -3.32E+01 -12.4972 3.90E+02
-1.6E+01 446.8712 453.2001 461.3035 442.3168 -2.17E+00 3.992582 3.98E+02
7.1E+00 447.5485 449.8091 458.4299 451.6479 2.28E+01 14.31027 4.44E+02
3.8E+01 465.1594 459.0193 458.5772 476.9976 3.27E+01 12.82064 4.89E+02
2.2E+00 463.6238 461.782 459.3784 464.9038 4.45E-01 -1.26395 5.23E+02
3.2E+01 481.3095 473.4985 462.9084 486.3415 2.53E-01 -6.25283 4.64E+02
-1.1E+01 477.1638 475.6977 466.1057 470.5041 -3.13E+01 -18.2831 4.80E+02
3.9E+01 503.7655 492.5384 472.7139 506.3953 -1.86E+01 -19.344 4.21E+02
7.5E+00 515.5462 506.3431 481.1212 508.7306 -5.23E+01 -36.0422 4.68E+02
-1.3E+01 518.2785 513.5043 489.217 503.5395 -7.33E+01 -43.9047 4.20E+02
-4.2E+01 504.6714 508.2046 493.9639 483.3644 -7.86E+01 -39.9912 3.86E+02
-2.3E+01 498.8086 502.567 496.1146 484.8394 -4.78E+01 -22.9741 3.65E+02
-1.5E+01 494.1234 497.5008 496.4612 486.329 -2.33E+01 -9.93838 4.14E+02
-2.7E+01 478.3894 486.034 493.8544 470.9206 -1.07E+01 0.395643 4.53E+02
5.4E+00 477.9157 481.163 490.6815 480.9397 2.10E+01 14.11027 4.61E+02
1.4E+01 480.4263 480.721 488.1914 487.3073 2.92E+01 16.14538 5.16E+02
3.3E+01 494.2105 488.8147 488.3472 504.5347 2.84E+01 11.08876 5.33E+02
2.1E+01 503.3842 497.5564 490.6495 508.1329 4.29E+00 -2.42793 5.44E+02
9.7E+00 509.3937 504.6588 494.1518 508.3566 -1.67E+01 -12.9871 5.10E+02
-7.0E+00 508.0175 506.674 497.2824 501.3128 -3.12E+01 -18.1083 4.79E+02
-2.5E-01 511.367 509.4898 500.3342 505.9658 -2.72E+01 -16.3763 4.52E+02
-3.5E+01 494.2868 500.368 500.3427 482.0991 -3.43E+01 -13.7397 4.62E+02
-1.9E+01 483.9147 490.496 497.881 478.1371 -6.56E+00 1.808262 4.34E+02
-2.2E+01 467.7059 476.8219 492.6162 465.2681 1.39E+01 15.02605 4.73E+02
1.0E+01 467.0424 470.9542 487.2007 475.4652 4.50E+01 27.75309 4.94E+02
8.2E+00 463.4769 466.4678 482.0175 473.0448 4.73E+01 28.25723 5.48E+02
5.2E-01 455.0308 459.6056 476.4145 462.6901 4.36E+01 27.52673 5.49E+02
7.8E+00 450.5123 454.1496 470.8483 459.9364 4.84E+01 29.38806 5.34E+02
4.5E+01 468.4449 462.7268 468.8179 485.9723 5.73E+01 26.5708 5.38E+02
6.0E+00 467.038 465.3135 467.9418 473.1152 2.05E+01 9.793768 5.70E+02
-4.7E+00 461.9752 463.3105 466.784 462.778 6.82E+00 4.810851 5.03E+02
1.5E+01 469.7301 467.1623 466.8786 474.582 1.33E+01 5.139301 4.74E+02
-1.4E+01 461.492 463.7601 466.0989 459.2947 -3.11E+00 0.159172 4.93E+02
9.0E+00 467.1368 465.7861 466.0207 470.0728 8.57E+00 3.5669 4.56E+02
-2.5E+01 453.0147 458.1233 464.0464 448.7207 -4.30E+00 1.83269 4.82E+02
-3.0E+01 434.4659 443.9288 459.017 430.6281 9.01E+00 12.65668 4.46E+02
-1.2E+00 429.0264 434.9874 453.0096 435.1266 4.08E+01 27.13778 4.52E+02
2.0E-01 422.1105 427.2613 446.5725 431.1203 5.07E+01 31.86116 5.03E+02
1.2E+01 421.0842 423.555 440.8181 433.4057 5.73E+01 33.28264 5.14E+02
-1.2E+01 406.0937 413.0782 433.8832 412.9295 4.65E+01 31.09589 5.24E+02
2.0E+01 408.7975 410.5098 428.0398 422.9029 6.27E+01 35.58991 4.91E+02
2.9E+01 417.859 414.9193 424.7597 433.5787 5.71E+01 28.75515 5.21E+02
4.6E+00 415.5436 415.2939 422.3932 423.1424 3.07E+01 16.53541 5.19E+02
2.7E-01 412.7574 413.772 420.2379 417.1942 2.10E+01 12.26551 4.70E+02
-2.1E+01 398.263 404.4666 416.2951 397.6842 1.39E+01 12.656 4.50E+02
2.2E+01 408.3652 406.8058 413.9228 418.6011 3.81E+01 19.52201 4.24E+02
-4.4E+01 380.1861 390.8339 408.1506 376.2069 1.15E+01 15.00467 4.76E+02
-1.2E+01 367.7744 376.9982 400.3625 372.6911 4.45E+01 31.81597 4.03E+02
3.5E+00 361.5498 367.7292 392.2041 373.666 6.62E+01 41.16511 4.49E+02
2.8E+00 353.4799 359.1796 383.948 366.8489 7.01E+01 42.90458 4.81E+02
1.2E+01 350.552 354.003 376.4618 366.1086 7.32E+01 42.76729 4.80E+02
-5.4E+00 337.5608 344.1377 368.3807 348.6501 6.30E+01 39.74888 4.82E+02
1.2E+01 334.8243 338.5497 360.923 349.7469 7.13E+01 41.95792 4.51E+02
2.9E+01 342.6697 341.0217 355.9477 360.8917 7.08E+01 37.29146 4.63E+02
-2.9E+01 318.6279 327.5854 348.8571 321.9845 3.74E+01 27.70685 4.69E+02
1.8E+01 321.9112 324.1809 342.688 335.8789 6.36E+01 36.53431 3.87E+02
7.6E+00 319.8045 321.555 337.4048 332.1531 5.55E+01 31.7232 4.36E+02
-8.3E+00 309.4218 314.2751 331.6224 317.0625 4.43E+01 28.11146 4.19E+02
-3.8E+01 281.2087 294.4353 322.3256 282.6459 4.06E+01 32.9935 3.89E+02
1.6E-01 272.1435 281.0602 312.0092 285.2591 7.75E+01 49.57274 3.56E+02
-7.6E+00 256.2174 266.1545 300.5456 270.7342 8.60E+01 55.02132 4.12E+02
-2.0E+01 230.827 244.958 286.6487 244.2556 9.25E+01 62.00923 4.12E+02
2.3E+01 227.9308 234.7417 273.6719 253.2393 1.22E+02 72.26858 3.99E+02
3.9E+01 234.5123 234.6041 263.9049 263.6297 1.20E+02 65.7206 4.48E+02
8.8E+00 226.7649 229.9006 255.4039 245.9969 8.76E+01 50.32716 4.50E+02
2.0E+01 228.166 228.8598 248.7678 246.6863 7.82E+01 43.23192 3.84E+02
3.4E+00 222.9064 225.2878 242.8978 235.7537 5.92E+01 34.26456 3.68E+02
34769.383 S=
h
1
2
3
4
Zt-Zt-1(1) MODELO DE SUAVIZACIÓN EXPONENCIAL CUADRÁTICO DE BROWN
-2.23E+01
2.61E-02
-2.08E+01
-3.70E+01
-7.03E+01
4.95E+00
-4.85E+01
-8.66E+00
-2.35E+01
1.35E+01
1.26E+01
9.85E+01
1.04E+02
9.80E+01
9.94E+01
1.31E+02
5.55E+01
4.32E+01
3.86E+00
-1.19E+01
-5.99E+01 1) Para la serie Zt con α=0,25 y 0,60 obtenga b1,t y b2,t y b3,t aplicando la suavización cuadrática
2.90E+01 2) determine el valor de α más adecuado
-5.94E+00 3) Obtenga el valor estimado de Z88
1.01E+02
5.50E+01 SOLUCIÓN:
9.97E+01
1.09E+02 1) Resuelto
1.30E+02
7.69E+01 2) para α=0.25 S= 34769.38 El valor de α mas adecuado es α
1.48E+01 para α=0.60 S= 689919.00
1.70E+01
-3.39E+01 3) Z88 = Z84(4) = 208.446
-2.92E+01
-3.45E+01
3.40E+00
2.84E+01
6.16E+01
2.05E+01
4.30E+01
-1.65E+01
-2.76E+01
-8.71E+01
-9.92E+01
-8.63E+01
-5.73E+01
-1.04E+02
-4.49E+01
4.94E-01
-3.70E+01
1.46E+01
-3.86E+01
-2.42E+01
-2.69E+01
-8.56E+01
-9.33E+01
-1.28E+02
-8.00E+01
-9.73E+01
-1.05E+02
-5.95E+01
-6.18E+01
-9.14E+00
-1.15E+02
-4.32E+01
-9.16E+01
-1.33E+02
-1.31E+02
-1.53E+02
-1.18E+02
-1.15E+02
-1.66E+02
-6.30E+01
-1.18E+02
-1.17E+02
-1.27E+02
-9.02E+01
-1.67E+02
-1.98E+02
-1.73E+02
-2.09E+02
-2.28E+02
-1.55E+02
-1.49E+02
689919.0024
CIAL CUADRÁTICO DE BROWN
90 h=6
100 h=16
115 h=31
CIÓN EXPONENCIAL ESTACIONAL DE HOLT WINTERS
=0,3; C=0,6 y D=0,1 considere el modelo aditivo y el multiplicativo y estime en cada caso los suavizados de nivel tendencia y estacioanlidad
da uno de los modelos estime Z 64 y Z100
e nivel tendencia y estacioanlidad.