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:
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:
Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
Related questions
Question
Consider the following time series data:
|
||||||||||||||||||||||||||
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
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.Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,