Question

Refer to the gasoline sales time series data in the given table.

Week	Sales (1000s of gallons)
1	18
2	21
3	18
4	22
5	17
6	15
7	20
8	18
9	21
10	20
11	14
12	22

Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.

Week	Sales	4-Week Moving Average	5-Week Moving Average
1	18
2	21
3	18
4	22
5	17
6	15
7	20
8	18
9	21
10	20
11	14
12	22

Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places.

MSE for four-week moving average =  

MSE for five-week moving average =

Answer 1

	Sales	4-Week Moving Average	4-Week Moving Average	FOR FINDING MSE (original-moving average)^2
	18		missing
	21		missing
	18		missing
	22	(18+21+18+22)/4	=19.75	(22-19.75)^2=5.06
	17	(21+18+22+17)/4	=19.5	(17-19.5)^2=6.25
	15	“	18	9
	20	“	18.5	2.25
	18	“	17.5	0.25
	21	“	18.5	6.25
	20	“	19.75	0.06
	14	“	18.25	18.06
	22	"	19.25	7.56
TOTAL				54.74

SIMILARLY FOR 5-YEAR MOVING AVERAGE

Sales	5-Week Moving Average	FOR FINDING MSE
18	missing
21	missing
18	missing
22	missing
17	19.2	4.84
15	18.6	12.96
20	18.4	2.56
18	18.4	0.16
21	18.2	7.84
20	18.8	1.44
14	18.6	21.16
22	19	9
		59.96

MSE for 4 year moving average is 54.74

MSE for 5 year moving average is 59.96