Question 4 Consider the below data set. Months 1 2 3 4 5 6 7 8 9 10 11 12 Demand 74 76 74 99 93 94 63 92 62 88 63 91 a) Calculate 3- months and 5-months moving average forecasts for months #6-12. b) Error, determine which method in part(a) fits the data better, 3-months moving average or 5-months moving average. If the performance measures give conflicting results, choose which method you prefer and explain why. Jsing Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared Using 5-months moving average method, using the available data make a forecast for month#13 and month#15. d) step-ahead exponential smoothing forecasts for months #7-12 Assume that the forecast made for Month#6 is 100. Use a=0.3 and a=0.7 to calculate one- e) Using Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared Error, determine which method in part(d) fits the data better exponential smoothing with a=0.3 or exponential smoothing with a=0.7

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
Question
part C D E
Question 4
Consider the below data set.
Months
1
3
4
6
8
9
10
11
12
Demand 74
76
74 99
93
94
63 92
62
88
63 91
a)
Calculate 3- months and 5-months moving average forecasts for months #6-12.
b)
Error, determine which method in part(a) fits the data better, 3-months moving average or 5-months
moving average. If the performance measures give conflicting results, choose which method you prefer
and explain why.
Jsing Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared
Using 5-months moving average method, using the available data make a forecast for
month#13 and month#15.
d)
step-ahead exponential smoothing forecasts for months #7-12
Assume that the forecast made for Month#6 is 100. Use a=0.3 and a=0.7 to calculate one-
e)
Error, determine which method in part(d) fits the data better exponential smoothing with a=0.3 or
exponential smoothing with a=0.7
Using Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared
Transcribed Image Text:Question 4 Consider the below data set. Months 1 3 4 6 8 9 10 11 12 Demand 74 76 74 99 93 94 63 92 62 88 63 91 a) Calculate 3- months and 5-months moving average forecasts for months #6-12. b) Error, determine which method in part(a) fits the data better, 3-months moving average or 5-months moving average. If the performance measures give conflicting results, choose which method you prefer and explain why. Jsing Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared Using 5-months moving average method, using the available data make a forecast for month#13 and month#15. d) step-ahead exponential smoothing forecasts for months #7-12 Assume that the forecast made for Month#6 is 100. Use a=0.3 and a=0.7 to calculate one- e) Error, determine which method in part(d) fits the data better exponential smoothing with a=0.3 or exponential smoothing with a=0.7 Using Mean Absolute Deviation, Mean Absolute Percentage Error and Mean Squared
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
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