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

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter4: Eigenvalues And Eigenvectors
Section4.6: Applications And The Perron-frobenius Theorem
Problem 25EQ
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
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax