a,b,c

Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. Week 1 2 4 5 6 7 Sales (1000s of gallons) 17 22 19 23 19 16 21 BU AWN 1114 1222 a. Compute four-week and five-week moving averages for the time series. Round your answers to two Week AWNIH 4-Week 5-Week Sales Moving Average Moving Average 17 22 19 23 TL 19 Check M ac a. Compute four-week and five-week moving averages for the time series. Round 4-Week 5-Week Moving Average Moving Average Week 1 2 Sales 17 22 3 AWN 19 5 16 8 21 19 23 9 10 T 19 1114 12 b. Compute the MSE for the four-week and five-week moving average forecasts. R 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) b. Compute the HSE 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- 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 werage is 12.72