(b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Week Time Series Forecast Value 1 19 2 12 3 17 4 10 1.72 5 18 60 14 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use a = 0.2 to compute the exponential smoothing values for the time series. Week Time Series Forecast Value 1 19 2 12 3 17 4 st 10 5 18 10 6 14 Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 19 12 17 10 18 14 (a) Construct a time series plot. 20 18 16 14 20 18 16 14 12 10 8. 20 18 20 T 16 18 14 16 12 14 10 12 10 8 2- 2 0 1 2 3 4 5 6 7 0 2 3 4 5 6 7 0 1 2 3 4 5 6 7 1 2 3 4 5 6 7 Week Week Week Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern. The data appear to follow a trend pattern.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 27P: The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living...
icon
Related questions
Question
100%
(b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.)
Week
Time Series
Forecast
Value
1
19
2
12
3
17
4
10
1.72
5
18
60
14
Compute MSE. (Round your answer to two decimal places.)
MSE =
What is the forecast for week 7?
(c) Use a = 0.2 to compute the exponential smoothing values for the time series.
Week
Time Series
Forecast
Value
1
19
2
12
3
17
4
st
10
5
18
10
6
14
Transcribed Image Text:(b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Week Time Series Forecast Value 1 19 2 12 3 17 4 10 1.72 5 18 60 14 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use a = 0.2 to compute the exponential smoothing values for the time series. Week Time Series Forecast Value 1 19 2 12 3 17 4 st 10 5 18 10 6 14
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows.
Week
1
2
3
4
5
6
Value
19
12
17
10
18
14
(a) Construct a time series plot.
20
18
16
14
20
18
16
14
12
10
8.
20
18
20 T
16
18
14
16
12
14
10
12
10
8
2-
2
0
1
2
3
4
5
6
7
0
2
3
4
5 6
7
0
1
2
3
4
5
6
7
1
2
3
4
5 6
7
Week
Week
Week
Week
What type of pattern exists in the data?
The data appear to follow a seasonal pattern.
The data appear to follow a horizontal pattern.
The data appear to follow a cyclical pattern.
The data appear to follow a trend pattern.
Transcribed Image Text:Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 19 12 17 10 18 14 (a) Construct a time series plot. 20 18 16 14 20 18 16 14 12 10 8. 20 18 20 T 16 18 14 16 12 14 10 12 10 8 2- 2 0 1 2 3 4 5 6 7 0 2 3 4 5 6 7 0 1 2 3 4 5 6 7 1 2 3 4 5 6 7 Week Week Week Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern. The data appear to follow a trend pattern.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,