еВook Consider the following time series data: Month 1 2 3 4 5 7 Value 24 15 21 13 19 21 16

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

Please find (b), (c), and (e)

Check My Work (No more tries available)
еВook
Consider the following time series data:
Month
1
2
3
4
7
Value
24
15
21
13
19
21
16
(a) Choose the correct time series plot.
(i)
30
25
20
15
10
5
1
2
3
4
6
Month
(ii)
30
25
20
Value
Transcribed Image Text:Check My Work (No more tries available) еВook Consider the following time series data: Month 1 2 3 4 7 Value 24 15 21 13 19 21 16 (a) Choose the correct time series plot. (i) 30 25 20 15 10 5 1 2 3 4 6 Month (ii) 30 25 20 Value
1
2
3
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:
14.00
The forecast for month 8:
18.67
(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:
5.00
The forecast for month 8:
19.32
(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
Check My Work (No more tries available)
Transcribed Image Text:1 2 3 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: 14.00 The forecast for month 8: 18.67 (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: 5.00 The forecast for month 8: 19.32 (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 Check My Work (No more tries available)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
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,