Refer to the gasoline sales time series data in the given table. Compute four-we
ID: 450808 • Letter: R
Question
Refer to the gasoline sales time series data in the given table.
Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
Compute the MSE 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 =
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 11.09.
Week Sales (1000s of gallons) 1 18 2 22 3 19 4 23 5 17 6 16 7 22 8 19 9 22 10 19 11 16 12 23Explanation / Answer
Answer:
Week Sales 4 Week Moving Average MSE 5 Week Moving Average MSE 1 18 -- -- -- -- 2 22 -- -- -- -- 3 19 -- -- -- -- 4 23 20.50 (23-20.50)2 = 6.25 -- -- 5 17 20.25 10.56 19.80 7.84 6 16 18.75 7.56 19.40 11.56 7 22 19.50 6.25 19.40 6.76 8 19 18.50 0.25 19.40 0.16 9 22 19.75 5.06 19.20 7.84 10 19 20.50 2.25 19.60 0.36 11 16 19.00 9 19.60 12.96 12 23 20.00 9 19.80 10.24Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.