(c) Use a = 0.2 to compute the exponential smoothing values for the time serles. Time Serles Value Week Forecast 19 12 19 3 16 17.6 4 11 17.28 18 16.024 13 16.412 X Compute MSE. (Round your answer to two decimal places.) MSE = 21.32 What is the forecast for week 7? (Round your answer to two decimal places.) 15.74 (d) Compare the week moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? Explain. O The exponential smoothing using a = 0.2 provides a better forecast since it has a larger MSE than the three-week moving average approach. O The three-week moving average provides a better forecast since it has a larger MSE than the smoothing approach using a = 0.2. O The exponential smoothing using a = 0.2 provides a better forecast sincei has a smaller MSE than the three-week moving average approach. O The three-week moving average provides a better forecast since it has a smaller MSE than the smoothing approach using a = 0.2. (e) Use trial and error to find a value of the exponential smoothing coefficient a that results in a smaller MSE than what you calculated for a = 0.2. a =

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
Please answer part e
Consider the following time series data.
2 3
Week
4
Value
19
12
16
11
18
13
(a) Construct a time series plot. What type of pattern exists in the data?
O The data appear to follow a trend pattern.
O The data appear to follow a horizontal pattern.
O The data appear to follow a seasonal pattern.
O The data appear to follow a cyclical pattern.
(b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.)
Time Series
Value
Week
Forecast
1
19
12
3
16
4
11
15.67
18
13
6
13
15
Compute MSE. (Round your answer to two decimal places.)
MSE = 16.94
What is the forecast for week 7?
Transcribed Image Text:Consider the following time series data. 2 3 Week 4 Value 19 12 16 11 18 13 (a) Construct a time series plot. What type of pattern exists in the data? O The data appear to follow a trend pattern. O The data appear to follow a horizontal pattern. O The data appear to follow a seasonal pattern. O The data appear to follow a cyclical pattern. (b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Time Series Value Week Forecast 1 19 12 3 16 4 11 15.67 18 13 6 13 15 Compute MSE. (Round your answer to two decimal places.) MSE = 16.94 What is the forecast for week 7?
(c) Use a = 0.2 to compute the exponential smoothing values for the time serles.
Time Serles
Week
Forecast
Value
1
19
12
19
16
17.6
4
11
17.28
18
16.024
6
13
16.412 X
Compute MSE. (Round your answer to two decimal places.)
MSE = 21.32
What is the forecast for week 7? (Round your answer to two decimal places.)
15.74
(d) Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE?
Explain.
O The exponential smoothing using a = 0.2 provides a better forecast since it has a larger MSE than the three-week moving average approach.
O The three-week moving average provides a better forecast since it has a larger MSE than the smoothing approach using a = 0.2.
O The exponential smoothing using a = 0.2 provides a better forecast since it has a smaller MSE than the three-week moving average approach.
O The three-week moving average provides a better forecast since it has a smaller MSE than the smoothing approach using a = 0.2.
(e) Use trial and error to find a value of the exponential smoothing coefficient a that results in a smaller MSE than what you calculated for a = 0.2.
Transcribed Image Text:(c) Use a = 0.2 to compute the exponential smoothing values for the time serles. Time Serles Week Forecast Value 1 19 12 19 16 17.6 4 11 17.28 18 16.024 6 13 16.412 X Compute MSE. (Round your answer to two decimal places.) MSE = 21.32 What is the forecast for week 7? (Round your answer to two decimal places.) 15.74 (d) Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? Explain. O The exponential smoothing using a = 0.2 provides a better forecast since it has a larger MSE than the three-week moving average approach. O The three-week moving average provides a better forecast since it has a larger MSE than the smoothing approach using a = 0.2. O The exponential smoothing using a = 0.2 provides a better forecast since it has a smaller MSE than the three-week moving average approach. O The three-week moving average provides a better forecast since it has a smaller MSE than the smoothing approach using a = 0.2. (e) Use trial and error to find a value of the exponential smoothing coefficient a that results in a smaller MSE than what you calculated for a = 0.2.
Expert Solution
steps

Step by step

Solved in 2 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