Time series analysis.exel

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	t	year	quarter	Sales(Yt)	MA	CMA	(St,It)=Yt/CMA	St	De-Sesonalize	Tt	SALES FORECASTED	SALES	QUARTER
2	1	1	1	120				128	0.94	0.92	117.38	120	1
3	2		2	115				127	0.91	0.93	118.36	115	2
4	3		3	121	120	£121.63	0.99	130	0.93	0.95	123.09	121	3
5	4		4	125	123	£124.63	1.00	133	0.94	0.96	127.91	125	4
6	5	2	1	131	126	£127.88	1.02	128	1.02	0.98	125.00	131	1
7	6		2	128	130	£130.75	0.98	127	1.01	0.99	125.92	128	2
8	7		3	134	132	£132.38	1.01	130	1.03	1.01	130.83	134	3
9	8		4	135	133	£133.88	1.01	133	1.02	1.02	135.83	135	4
10	9	3	1	134	135	£135.13	0.99	128	1.05	1.04	132.62	134	1
11	10		2	137	135	£135.88	1.01	127	1.08	1.05	133.48	137	2
12	11		3	135	137	£136.50	0.99	130	1.04	1.07	138.57	135	3
13	12		4	140				133	1.05	1.08	143.74	140	4
14	13	4	1					128		1.096	140.24		1
15	14		2					127		1.111	141.04		2
16	15		3					130		1.125	146.30		3
17	16		4					133		1.140	151.66		4
18
19
20
21
22					QUARTER	S
23					1	£128.33
24					2	£126.67
25					3	£130.00
26					4	£133.33
27
28
29													SUMMARY OUTPUT
30
31													Regression Statistics
32													Multiple R	0.8819178557
33													R Square	0.7777791042
34													Adjusted R Square	0.7530878936
35													Standard Error	0.02781097101
36													Observations	11
37
38													ANOVA
39														df	SS	MS	F	Significance F
40													Regression	1	0.02436386539	0.02436386539	31.50024175	0.0003289666711
41													Residual	9	0.006961050975	0.0007734501083
42													Total	10	0.03132491637
43
44														Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
45													Intercept	0.9021820461	0.02036787943	44.29435322	0	0.8561067017	0.9482573904	0.8561067017	0.9482573904
46													1	0.01488252954	0.002651672043	5.612507617	0.0003289666711	0.008884030631	0.02088102844	0.008884030631	0.02088102844
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