1. The data below show the number of gallons of gasoline (in 1000s) sold by a gasoline distributor in Seguin, Texas, over the past 10 weeks. Week Sales (in 1000s) a. Using a line graph, plot sales over these 10 weeks. Underneath the random fluctuations, what sort of pattern do you see: horizontal or trend? 1 17 2 21 3 19 4 23 b. Compare the MSE for four-week and five-week simple moving averages. Which one performs best with this data? Using only the best-performing of these simple moving average forecasting tools, forecast sales for week 11. 5 18 6 16 7 20 8 18 C. Compare the MSE for exponential smoothing forecasting tools for a=0.1 and a=0.2. Which one performs best with this data? Using only the best performing of these exponential smoothing forecasting tools, forecast sales for week 11. 9 22 10 20 d. Which performs best with this data: the best-performing of your simple moving average tools or the best-performing of your exponential smoothing tools? Why? 1. The data below show the number of gallons of gasoline (in 1000s) sold by a gasoline distributor in Seguin, Texas, over the past 10 weeks. Week Sales (in 1000s) a. Using a line graph, plot sales over these 10 weeks. Underneath the random fluctuations, what sort of pattern do you see: horizontal or trend? 1 17 2 21 3 19 4 23 b. Compare the MSE for four-week and five-week simple moving averages. Which one performs best with this data? Using only the best-performing of these simple moving average forecasting tools, forecast sales for week 11. 5 18 6 16 7 20 8 18 C. Compare the MSE for exponential smoothing forecasting tools for a=0.1 and a=0.2. Which one performs best with this data? Using only the best performing of these exponential smoothing forecasting tools, forecast sales for week 11. 9 22 10 20 d. Which performs best with this data: the best-performing of your simple moving average tools or the best-performing of your exponential smoothing tools? Why