ejercicio_01.xlsx

	A	B	C	D	E	F	H	I	J	K	L	M
1	Muestral
2	Extra-muestral
3
4
5		Yt	Método A	error A	V absoluto A	error A VA²		Yt	Método A	error A	V absoluto A	error A VA²
6	2003	28.0	--				2003	28.0	--
7	2004	27.6	27.10	0.5	0.5	0.25	2004	27.6	27.10	=B7-C7	=ABS(D7)	=E7^2
8	2005	28.0	28.50	-0.5	0.5	0.25	2005	28.0	28.50	=B8-C8	=ABS(D8)	=E8^2
9	2006	34.4	33.50	0.9	0.9	0.81	2006	34.4	33.50	=B9-C9	=ABS(D9)	=E9^2
10	2007	45.5	44.80	0.7	0.7	0.49	2007	45.5	44.80	=B10-C10	=ABS(D10)	=E10^2
11	2008	45.5	46.00	-0.5	0.5	0.25	2008	45.5	46.00	=B11-C11	=ABS(D11)	=E11^2
12	2009	41.0	40.60	0.4	0.4	0.16	2009	41.0	40.60	=B12-C12	=ABS(D12)	=E12^2
13	2010	26.9	27.20	-0.3	0.3	0.09	2010	26.9	27.20	=B13-C13	=ABS(D13)	=E13^2
14	2011	26.2	27.00	-0.8	0.8	0.64	2011	26.2	27.00	=B14-C14	=ABS(D14)	=E14^2
15	2012	30.1	29.50	0.6	0.6	0.36	2012	30.1	29.50	=B15-C15	=ABS(D15)	=E15^2
16					EAM	EQM					EAM	EQM
17					0.5833	0.3683					=AVERAGE(E7:E12)	=AVERAGE(F7:F12)
18					0.5667	0.3633					=AVERAGE(E13:E15)	=AVERAGE(F13:F15)
19
20
21		Yt	Método B	error B	V absoluto B	error B VA²		Yt	Método B	error B	V absoluto B	error B VA²
22	2003	28.0	--				2003	28.0	--
23	2004	27.6	28.0	-0.4	0.4	0.16	2004	27.6	28.0	=B23-C23	=ABS(D23)	=E23^2
24	2005	28.0	27.8	0.2	0.2	0.04	2005	28.0	27.8	=B24-C24	=ABS(D24)	=E24^2
25	2006	34.4	28.1	6.3	6.3	39.69	2006	34.4	28.1	=B25-C25	=ABS(D25)	=E25^2
26	2007	45.5	35.7	9.8	9.8	96.04	2007	45.5	35.7	=B26-C26	=ABS(D26)	=E26^2
27	2008	45.5	36.9	8.6	8.6	73.96	2008	45.5	36.9	=B27-C27	=ABS(D27)	=E27^2
28	2009	41.0	37.9	3.1	3.1	9.61	2009	41.0	37.9	=B28-C28	=ABS(D28)	=E28^2
29	2010	26.9	38.1	-11.2	11.2	125.44	2010	26.9	38.1	=B29-C29	=ABS(D29)	=E29^2
30	2011	26.2	37.1	-10.9	10.9	118.81	2011	26.2	37.1	=B30-C30	=ABS(D30)	=E30^2
31	2012	30.1	35.0	-4.9	4.9	24.01	2012	30.1	35.0	=B31-C31	=ABS(D31)	=E31^2
32					EAM	EQM					EAM	EQM
33					4.7333	36.5833					=AVERAGE(E23:E28)	=AVERAGE(F23:F28)
34					9.0000	89.4200					=AVERAGE(E29:E31)	=AVERAGE(F29:F31)
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
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