- Refer To The Gasoline Sales Time Series Data In The Given Table Week 1 2 3 7 8 9 10 11 12 Sales 1 000s Of Gallons 16 1 (10.86 KiB) Viewed 65 times
- Refer To The Gasoline Sales Time Series Data In The Given Table Week 1 2 3 7 8 9 10 11 12 Sales 1 000s Of Gallons 16 2 (26.11 KiB) Viewed 65 times
(a) Compute four-week and five-week moving averages for the time series. Do not round intermediate calculations. If required, round your answers to two decimal places. Week 1 2 3 4 5 6 7 8 9 10 11 12 Sales 6273 16 22 17 15 17 21 19 20 18 15 23 4-Week Moving Average 5-Week Moving Average (b) Compute the MSE for the four-week and five-week moving average forecasts. Do not round intermediate calculations. If required, round your answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = (c) What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Consider that the MSE for the three-week moving average is 12.667. Select your answer -