Problem 15-07 (Algorithmic)

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

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

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	19
4	22
5	19
6	15
7	20
8	17
9	23
10	19
11	16
12	23

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 = ______________