Consider the following time series data. Excel File: data17-01.xls Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error (to 1 decimal). b. Mean squared error (to 1 decimal). c. Mean absolute percentage error (to 2 decimals). d. What is the forecast for week 7 (to 2 decimals)?

Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter12: Probability
Section12.CR: Chapter 12 Review
Problem 64CR
icon
Related questions
Question
Consider the following time series data.
Excel File: data17-01.xls
Week
1
2
3
4 5
6
Value
18
13
16
11
17
14
Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy.
a. Mean absolute error (to 1 decimal).
b. Mean squared error (to 1 decimal).
c. Mean absolute percentage error (to 2 decimals).
%
d. What is the forecast for week 7 (to 2 decimals)?
Transcribed Image Text:Consider the following time series data. Excel File: data17-01.xls Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error (to 1 decimal). b. Mean squared error (to 1 decimal). c. Mean absolute percentage error (to 2 decimals). % d. What is the forecast for week 7 (to 2 decimals)?
Week
A
В
D
G
H
K
M
N
1
Week
1
3
4
5
6.
2
Value
18
13
16
11
17
14
3
4
5
6
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Transcribed Image Text:Week A В D G H K M N 1 Week 1 3 4 5 6. 2 Value 18 13 16 11 17 14 3 4 5 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Time Series Analyses, Forecasting Methods, and Indices
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
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage