10 5 0 1 2 3 4 5 6 7 Month Graph (i) What type of pattern exists in the data? Horizontal pattern (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: 19.00 (c) Use a = 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: 19.12 (d) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? 3-month moving average + (e) Use trial and error to find a value of the exponential smoothing coefficient a that results in the smallest MSE. If required, round your answer to two decimal places. = a Hide Feedback Partially Correct Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17
10 5 0 1 2 3 4 5 6 7 Month Graph (i) What type of pattern exists in the data? Horizontal pattern (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: 19.00 (c) Use a = 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: 19.12 (d) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2. Which appears to provide the better forecast based on MSE? 3-month moving average + (e) Use trial and error to find a value of the exponential smoothing coefficient a that results in the smallest MSE. If required, round your answer to two decimal places. = a Hide Feedback Partially Correct Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17
Chapter3: Data Representation
Section: Chapter Questions
Problem 28VE
Related questions
Question

Transcribed Image Text:10
5
0
1
2
3
4
5
6
7
Month
Graph (i)
What type of pattern exists in the data?
Horizontal pattern
(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:
19.00
(c) Use a = 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:
19.12
(d) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2.
Which appears to provide the better forecast based on MSE?
3-month moving average +
(e) Use trial and error to find a value of the exponential smoothing coefficient a that results in the smallest
MSE.
If required, round your answer to two decimal places.
=
a
Hide Feedback
Partially Correct

Transcribed Image Text:Consider the following time series data:
Month
1
2
3
4
5
6
7
Value
23
13
21
13
19
21
17
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 4 images

Recommended textbooks for you

Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage

Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L

Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning