Please help me answer the below questions:

Refer to the gasoline sales time series data in the given table. Click on the datafile logo to reference the data. DATA :file 1 2 3 4 5 6 7 8 9 l'l'll MllC-'I (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 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (b) Compute the MSE for the fourweek and fiveweek 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 ve-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? Recall that the MSE for the threeweek moving average is 10.22. - Select your answer - V - Select your answer - Check My Work (3 remaining)