Consider the following time series data. Week 1   2  3  4  5  6 Value 18 13 16 11 17 14   Use a = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and forecast for week 7. Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.2. which appears to provide better forecast based on MSE? Explain. 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.

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.
Chapter1: Functions
Section1.EA: Extended Application Using Extrapolation To Predict Life Expectancy
Problem 2EA
icon
Related questions
Question
  • Consider the following time series data.

Week

1

  2

 3

 4

 5

 6

Value

18

13

16

11

17

14

 

  1. Use a = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and forecast for week 7.
  2. Compare the three-week moving average forecast with the exponential smoothing forecast using a = 0.2. which appears to provide better forecast based on MSE? Explain.
  3. 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 3 steps with 4 images

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,
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning