d) There is a specific reason why it's so difficult to properly forecast this data using Time Series approach. Explain to me in 2-4 sentences what the problem is. Hint: consider what we are trying to predict (gallons of ice cream sold).

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
icon
Concept explainers
Topic Video
Question

solve part D only

Problem #3: (46
Georgia is well known for its popularhomemade ice cream, made in a small plant in back of the café.
People drive all the way from Atlanta and Macon to buy the ice cream. The two women who own the café
want to develop a forecasting model so they can plan their ice cream production and determine the
number of employees they need to sell ice cream in the café. They have accumulated the following sales
records for their ice cream for the past 12 quarters (3years):
--k. "The Whistle Stop Café in Weems,
alpha = .5,
beta =.5
alpha =.3
Simple Exp.
Quarters Demand Smooth.
alpha =.5
Simple Exp.
Smooth
Adj. Exp.
Smooth
350 +0
Error
Error
Error
1
350
350
350
2
510
3.
750
4
420
370
6.
480
860
8
500
450
10
550
11
820
12
570
a) Fill out the above table, calculating SES and AES as shown. Make sure to show your work for at
lea st Quarters 3-5 for each forecast.
b) Then calculate the Errors and Average Error for me. Which one of these three methods has the
lea st average error?
c) Calculate the Mean Absolute Deviation for just Alpha = .5, Beta = .5 for me. Do the Errors mostly
cancel each other out when we use Absolute Deviation on them?
d) There is a specific reason why it's so difficult to properly forecast this data using Time Series
approach. Explain to me in 2-4 sentences what the problem is. Hint: consider what we are trying to
predict (gallons of ice cream sold).
Transcribed Image Text:Problem #3: (46 Georgia is well known for its popularhomemade ice cream, made in a small plant in back of the café. People drive all the way from Atlanta and Macon to buy the ice cream. The two women who own the café want to develop a forecasting model so they can plan their ice cream production and determine the number of employees they need to sell ice cream in the café. They have accumulated the following sales records for their ice cream for the past 12 quarters (3years): --k. "The Whistle Stop Café in Weems, alpha = .5, beta =.5 alpha =.3 Simple Exp. Quarters Demand Smooth. alpha =.5 Simple Exp. Smooth Adj. Exp. Smooth 350 +0 Error Error Error 1 350 350 350 2 510 3. 750 4 420 370 6. 480 860 8 500 450 10 550 11 820 12 570 a) Fill out the above table, calculating SES and AES as shown. Make sure to show your work for at lea st Quarters 3-5 for each forecast. b) Then calculate the Errors and Average Error for me. Which one of these three methods has the lea st average error? c) Calculate the Mean Absolute Deviation for just Alpha = .5, Beta = .5 for me. Do the Errors mostly cancel each other out when we use Absolute Deviation on them? d) There is a specific reason why it's so difficult to properly forecast this data using Time Series approach. Explain to me in 2-4 sentences what the problem is. Hint: consider what we are trying to predict (gallons of ice cream sold).
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Application of Algebra
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman