Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...

Transcribed Image Text:

Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 17 2 21 3 16 4 24 5 17 6 18 7 22 00 8 20 9 21 19 220 10 11 16 12 25 (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 Week Sales Moving Average 5-Week Moving Average 1 17 2 21 3 16 4 24 5 17 6 18 7 22 8 20 9 21 10 19 11 16 12 25 (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.852. - Select your answer - Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 17 2 21 3 16 4 24 5 17 6 18 7 22 00 8 20 9 21 19 220 10 11 16 12 25 (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 Week Sales Moving Average 5-Week Moving Average 1 17 2 21 3 16 4 24 5 17 6 18 7 22 8 20 9 21 10 19 11 16 12 25 (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.852. - Select your answer -