Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Financial Intermediation And Banking

Authors: Anjan V. Thakor, Arnoud Boot

1st Edition

0444515585, 978-0444515582

More Books

Students also viewed these Finance questions