Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. DATA file Week

[answerhappygod]

Consider The Following Gasoline Sales Time Series Data Click On The Datafile Logo To Reference The Data Data File Week 1 (49.26 KiB) Viewed 62 times

Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. DATA file Week 1 2 3 4 5 6 7 8 9 10 12 11 Sales (1000s of gallons) 17 21 19 23 18 16 20 18 22 20 15 22
a. Compute four-week and five-week moving averages for the time series (to 2 decimals). Time Series Value 4-Week Moving Average Forecast 5-Week Moving Average Forecast Week (Error)2 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 X 22 Totals b. Compute the MSE for the four-week and five-week moving average forecasts (to 2 decimals). MSE (4-Week) × MSE (5-Week) c. 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 10.22. The 5-week moving average provides the smallest MSE. › › › › › * * * * * * * * * * * * * * * (Error)²