Refer to the gasoline sales time series data in the given table. Week 1 2 3 4 5 6 7 8 9 10 11 12 (a) Compute four-week a
Posted: Sun Jul 10, 2022 11:11 am
(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. Week AWNH 1 2 3 4 5 6 7 8 9 10 11 12 Sales 17 21 16 24 17 18 22 20 21 19 16 25 4-Week Moving Average 5-Week Moving Average I (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 =
9 10 11 12 21 19 16 25 OvIcan Kay IIII (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 -