Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started