Problem 5-7

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

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

(a)

Compute four-week and five-week moving averages for the time series.

If required, round your answers to two decimal places.

Week	Sales	4 Period Moving Average	5 period Moving Average
1	17
2	21
3	19
4	23
5	18
6	16
7	20
8	18
9	22
10	20
11	15
12	22

(b)

Compute the MSE for the four-week and five-week moving average forecasts.

If required, round your intermediate calculations to four decimal places and round your final answers to three decimal places.

MSE for four-week moving average =

MSE for five-week moving average =