(b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Time Series Week Forecast Value 1 19 2 13 3 15 4 10 14.33 5 18 11.33 6 14 13.33 Compute MSE. (Round your answer to two decimal places.) MSE = 17.56 What is the forecast for week 7? 13 (c) Use a = 0.2 to compute the exponential smoothing values for the time series. Time Series Value Forecast Week 1 19 13 18 15 10 5 18 6 14 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) (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 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. O The three-week moving average provides a better forecast since it has a larger 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
Topic Video
Question
100%

I need only part e I have provided the values 

 

 

 

Values are

The forecast for week 7 is :14

MSE = 60.6667/3 

        = 20.22

 

The forecast for the  week 7 I:  15.78

MSE = 106.1146/6

        =17.6858

 

 

(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
2
13
3
15
4
10
14.33
5
18
11.33
14
13.33
Compute MSE. (Round your answer to two decimal places.)
MSE = 17.58
1x
What is the forecast for week 7?
13
(c) Use a = 0.2 to compute the exponential smoothing values for the time series.
Week
Time Series
Value
Forecast
1
19
2
13
18
3
15
4
10
18
6
14
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7? (Round your answer to two decimal places.)
(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 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.
O The three-week moving average provides a better forecast since it has a larger 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:(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 2 13 3 15 4 10 14.33 5 18 11.33 14 13.33 Compute MSE. (Round your answer to two decimal places.) MSE = 17.58 1x What is the forecast for week 7? 13 (c) Use a = 0.2 to compute the exponential smoothing values for the time series. Week Time Series Value Forecast 1 19 2 13 18 3 15 4 10 18 6 14 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) (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 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. O The three-week moving average provides a better forecast since it has a larger 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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
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.
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