question 1

Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 2 3 4 5 6 7 8 S = = = N =, O (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. 4-Week 5-Week Week Sales Moving Moving Average Average 17 23 W N 14 A 25 17 16 7 22 00 19 21 10 19 11 17 12 23 (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 11.889. - Select your