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 |
17 |
| 6 |
16 |
| 7 |
20 |
| 8 |
19 |
| 9 |
21 |
| 10 |
19 |
| 11 |
15 |
| 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 |
17 |
|
|
| 2 |
21 |
|
|
| 3 |
19 |
|
|
| 4 |
23 |
|
|
| 5 |
17 |
|
|
| 6 |
16 |
|
|
| 7 |
20 |
|
|
| 8 |
19 |
|
|
| 9 |
21 |
|
|
| 10 |
19 |
|
|
| 11 |
15 |
|
|
| 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 =