ejercicio_02.xlsx

	A	B	C	D	E	F	G
1	Muestral
2	Extra-muestral
3
4
5	Años	Yt	AES(0,3)	error	V absoluto 0,3	error VA²	error/Yt
6	1	80.2
7	2	78.0	80.200	-2.200	2.200	4.840	0.028
8	3	74.2	79.540	-5.340	5.340	28.516	0.072
9	4	76.5	77.938	-1.438	1.438	2.068	0.019
10	5	78.4	77.507	0.893	0.893	0.798	0.011
11	6	72.6	77.507	-4.907	4.907	24.075	0.068
12					EAM	EQM	EPAM
13					2.993	11.808	3.97%
14					2.900	12.436	3.95%
15
16
17	Año	Yt	AES(0,6)	error	V absoluto 0,6	error VA²	error/Yt
18	1	80.2
19	2	78.0	80.200	-2.200	2.200	4.840	0.028
20	3	74.2	78.880	-4.680	4.680	21.902	0.063
21	4	76.5	76.072	0.428	0.428	0.183	0.006
22	5	78.4	76.329	2.071	2.071	4.290	0.026
23	6	72.6	76.329	-3.729	3.729	13.904	0.051
24					EAM	EQM	EPAM
25					2.436	8.975	3.23%
26					2.900	9.097	3.89%
27
28
29	Años	Yt	MM(2)	error	V absoluto 0,3	error VA²	error/Yt
30	1	80.2
31	2	78.0
32	3	74.2	79.100	-4.900	4.900	24.010	0.066
33	4	76.5	76.100	0.400	0.400	0.160	0.005
34	5	78.4	75.350	3.050	3.050	9.303	0.039
35	6	72.6	75.350	-2.750	2.750	7.563	0.038
36					EAM	EQM	EPAM
37					2.650	12.085	3.56%
38					2.900	8.433	3.84%
39
40
41	Año	Yt	MM(3)	error	V absoluto 0,6	error VA²	error/Yt
42	1	80.2
43	2	78.0
44	3	74.2
45	4	76.5	77.467	-0.967	0.967	0.934	0.013
46	5	78.4	76.233	2.167	2.167	4.694	0.028
47	6	72.6	76.233	-3.633	3.633	13.201	0.050
48					EAM	EQM	EPAM
49					0.967	0.934	1.26%
50					2.900	8.948	3.88%
51
52
53	Año	Yt	Ingenuo	error	V absoluto 0,6	error VA²	error/Yt
54	1	80.2
55	2	78.0	80.200	-2.200	2.200	4.840	0.028
56	3	74.2	78.000	-3.800	3.800	14.440	0.051
57	4	76.5	74.200	2.300	2.300	5.290	0.030
58	5	78.4	76.500	1.900	1.900	3.610	0.024
59	6	72.6	76.500	-3.900	3.900	15.210	0.054
60					EAM	EQM	EPAM
61					2.767	8.190	3.65%
62					2.900	9.410	3.90%
63
64
65	Año	Yt	M simple	error	V absoluto 0,6	error VA²	error/Yt
66	1	80.2
67	2	78.0	80.200	-2.200	2.200	4.840	0.028
68	3	74.2	79.100	-4.900	4.900	24.010	0.066
69	4	76.5	76.100	0.400	0.400	0.160	0.005
70	5	78.4	75.350	3.050	3.050	9.303	0.039
71	6	72.6	75.350	-2.750	2.750	7.563	0.038
72					EAM	EQM	EPAM
73					2.500	9.670	3.32%
74					2.900	8.433	3.84%
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100