Calculate the MAPE for each of the 3 forecast models used in the table. Which should be used for forecasting efforts, and why?

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

Calculate the MAPE for each of the 3 forecast models used in the table.

Which should be used for forecasting efforts, and why?

A
1 Month
2 Jan
3 Feb
4
Mar
5
Apr
6 May
7 Jun
8 Jul
9 Aug
10 Sept
11 Oct
12 Nov
13 Dec
14 Jan
B
C
D
E
F
Sales ('000 Units) 5-month Moving Average Weighted moving average Exponential smoothing forecast Alpha
16000 1-Alpha
16,000
19,000
16000
18,000
16600
15,000
16880
20,000
16504
18,000
17203.2
22,000
17362.56
20,000
18290.048
19,000
18632.0384
22,000
18705.63072
24,000
19364.50458
23,000
20291.60366
17600
18000
18600
19000
19800
20200
21400
18100
16300
18300
18300
20600
20400
19600
20900
22900
23200
G
0.2
0.8
Transcribed Image Text:A 1 Month 2 Jan 3 Feb 4 Mar 5 Apr 6 May 7 Jun 8 Jul 9 Aug 10 Sept 11 Oct 12 Nov 13 Dec 14 Jan B C D E F Sales ('000 Units) 5-month Moving Average Weighted moving average Exponential smoothing forecast Alpha 16000 1-Alpha 16,000 19,000 16000 18,000 16600 15,000 16880 20,000 16504 18,000 17203.2 22,000 17362.56 20,000 18290.048 19,000 18632.0384 22,000 18705.63072 24,000 19364.50458 23,000 20291.60366 17600 18000 18600 19000 19800 20200 21400 18100 16300 18300 18300 20600 20400 19600 20900 22900 23200 G 0.2 0.8
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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