Refer to the gasoline sales time series data in the given table.. Week 12 2 34...

Transcribed Image Text:

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