Question

Refer to the gasoline sales time series data in the given table.

Week	Sales (1000s of gallons)
1	17
2	20
3	18
4	22
5	19
6	15
7	21
8	19
9	21
10	19
11	15
12	23

1. Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places.
   

   Week	Sales	4 Period Moving Average	5 Period Moving Average
   1	17
   2	20
   3	18
   4	22
   5	19
   6	15
   7	21
   8	19
   9	21
   10	19
   11	15
   12	23

2. Compute the MSE for the four-week and five-week moving average forecasts. If required, round your intermediate calculations to four decimal places and round your final answers to three decimal places.
   
   MSE for four-week moving average =
   
   MSE for five-week moving average =
   
3. 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 10.519.
   
   

Answer 1

(Please like the answer it will encourage me. Do comment if any correction required before disliking.)