In: Math
Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks.
| Week | Sales (1,000s of gallons) |
|---|---|
| 1 | 17 |
| 2 | 22 |
| 3 | 20 |
| 4 | 24 |
| 5 | 19 |
| 6 | 17 |
| 7 | 21 |
| 8 | 18 |
| 9 | 23 |
| 10 | 21 |
| 11 | 16 |
| 12 | 22 |
(a)
Compute four-week and five-week moving averages for the time series.
| Week | Time Series Value |
4-Week Moving Average Forecast |
5-Week Moving Average Forecast |
|---|---|---|---|
| 1 | 17 | ||
| 2 | 22 | ||
| 3 | 20 | ||
| 4 | 24 | ||
| 5 | 19 | ||
| 6 | 17 | ||
| 7 | 21 | ||
| 8 | 18 | ||
| 9 | 23 | ||
| 10 | 21 | ||
| 11 | 16 | ||
| 12 | 22 |
(b)
Compute the MSE for the four-week moving average forecasts. (Round your answer to two decimal places.) __________
Compute the MSE for the five-week moving average forecasts. (Round your answer to two decimal places.) ____________