In: Physics
Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
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 |
18 |
6 |
16 |
7 |
20 |
8 |
19 |
9 |
23 |
10 |
19 |
11 |
16 |
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 |
19 |
|
|
4 |
22 |
|
|
5 |
18 |
|
|
6 |
16 |
|
|
7 |
20 |
|
|
8 |
19 |
|
|
9 |
23 |
|
|
10 |
19 |
|
|
11 |
16 |
|
|
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 =
- What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that MSE for the three-week moving average is 9.