Refer To The Gasoline Sales Time Series Data In The Given Table Sales 1 000s Of Gallons 17 21 16 24 17 18 22 Week 1 2 1 (31.66 KiB) Viewed 81 times
Refer To The Gasoline Sales Time Series Data In The Given Table Sales 1 000s Of Gallons 17 21 16 24 17 18 22 Week 1 2 2 (22.43 KiB) Viewed 81 times
Refer to the gasoline sales time series data in the given table. Sales (1,000s of gallons) 17 21 16 24 17 18 22 Week 1 2 3 4 5 6 7 8 9 012 11 (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 1 3 5 7 8 Sales 17 21 16 24 17 18 22 20 21 19 16 25 20 4-Week Moving Average 5-Week Moving Average 0000 000
6 7 8 9 10 11 12 18 22 20 21 19 16 25 0000 (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 :
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!