Consider the following time series data:   Month 1 2 3 4 5 6 7 Value 23 15 20 12 18 22 15     (a) Choose the correct time series plot. (i)   (ii)   (iii)   (iv)         What type of pattern exists in the data?     (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8.   If required, round your answers to two decimal places. Do not round intermediate calculation.   MSE:     The forecast for month 8:   (c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8.   If required, round your answers to two decimal places. Do not round intermediate calculation.   MSE:     The forecast for month 8:

College Algebra
1st Edition
ISBN:9781938168383
Author:Jay Abramson
Publisher:Jay Abramson
Chapter4: Linear Functions
Section4.3: Fitting Linear Models To Data
Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....
icon
Related questions
Question

Consider the following time series data:

 

Month 1 2 3 4 5 6 7
Value 23 15 20 12 18 22 15

 

 

(a) Choose the correct time series plot.
(i)  
(ii)  
(iii)  
(iv)  
   
  What type of pattern exists in the data?
   
(b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8.
  If required, round your answers to two decimal places. Do not round intermediate calculation.
  MSE:  
  The forecast for month 8:  
(c) Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for month 8.
  If required, round your answers to two decimal places. Do not round intermediate calculation.
  MSE:  
  The forecast for month 8:  
(d) Compare the three-month moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE?
   
(e) Use trial and error to find a value of the exponential smoothing coefficient α that results in the smallest MSE.
  Do not round intermediate calculations. Use a two-decimal digit precision for the exponential smoothing coefficient.
  α =  
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 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, advanced-math and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
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
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning