Refer to the gasoline sales time series data in the given table. 3 4. Week Sales (1,000s of gallons) 16 1 S 2 22 6. 3 17 7. 4 23 8. 5 15 17 9. 000 21 10. 19 9 20 10 18 201 15 12 23 (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 16 22 17 23 15 6 OWN 6 17 21 8 19 9 20 18 11 15 12 23 (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. Module 6-CIS/MGT 601 - Assignment 5 - Option 2 (Rattle not required) - Predictive Analytics 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 16 2 22 3 17 4 23 15 5 7 21 19 9 20 10 18 11 15 12 23 (1) Compute the HSE for the four week and five-week moving werage forecasts. Do not round intermediate caldations. If required, round your answers to two decimal places HSE for four week moving average ME for few moving average (c) what was to be the best of works of past data three, four or five to use in the moving average computation? Consider that the HSE for the three week moving average is 12.567. Select your answer Trobem 15 7 Alpe viages and Expect moothing