Question
In: Statistics and Probability
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded weekly
Data collected over 36 weeks
|
t |
X |
t |
X |
t |
X |
t |
X |
t |
X |
t |
X |
|
1 |
9.8 |
7 |
36.4 |
13 |
53.4 |
19 |
99.2 |
25 |
105.3 |
31 |
141.3 |
|
2 |
9.0 |
8 |
51.0 |
14 |
66.6 |
20 |
90.4 |
26 |
116.7 |
32 |
151.8 |
|
3 |
10.5 |
9 |
51.1 |
15 |
70.6 |
21 |
91.2 |
27 |
113.2 |
33 |
151.1 |
|
4 |
20.6 |
10 |
46.9 |
16 |
76.4 |
22 |
94.9 |
28 |
120.5 |
34 |
156.4 |
|
5 |
28.1 |
11 |
50.5 |
17 |
88.4 |
23 |
94.2 |
29 |
124.2 |
35 |
155.9 |
|
6 |
28.3 |
12 |
58.5 |
18 |
98.6 |
24 |
104.1 |
30 |
130.2 |
36 |
160.0 |
Provide an estimate of the value of the time-series at week 37
Solutions
Expert Solution
| Estimated Parameters of Exponential Smoothing | |
| Parameter | Value |
| alpha | 0.999951954484354 |
| beta | FALSE |
| gamma | FALSE |
| Interpolation Forecasts of Exponential Smoothing | |||
| t | Observed | Fitted | Residuals |
| 2 | 9 | 9.8 | -0.800000000000001 |
| 3 | 10.5 | 9.00003843641252 | 1.49996156358748 |
| 4 | 20.6 | 10.4999279335732 | 10.1000720664268 |
| 5 | 28.1 | 20.5995147368295 | 7.5004852631705 |
| 6 | 28.3 | 28.0996396353179 | 0.200360364682066 |
| 7 | 36.4 | 28.299990373583 | 8.10000962641703 |
| 8 | 51 | 36.3996108308608 | 14.6003891691392 |
| 9 | 51.1 | 50.9992985167737 | 0.10070148322626 |
| 10 | 46.9 | 51.0999951617453 | -4.19999516174531 |
| 11 | 50.5 | 46.9002017909333 | 3.59979820906674 |
| 12 | 58.5 | 50.4998270458388 | 8.00017295416118 |
| 13 | 53.4 | 58.4996156275652 | -5.09961562756516 |
| 14 | 66.6 | 53.4002450136624 | 13.1997549863376 |
| 15 | 70.6 | 66.5993658109653 | 4.00063418903471 |
| 16 | 76.4 | 70.5998077874675 | 5.80019221253254 |
| 17 | 88.4 | 76.3997213267743 | 12.0002786732257 |
| 18 | 98.6 | 88.3994234404232 | 10.2005765595767 |
| 19 | 99.2 | 98.5995099080393 | 0.600490091960694 |
| 20 | 90.4 | 99.1999711491439 | -8.79997114914389 |
| 21 | 91.2 | 90.4004227991515 | 0.799577200848475 |
| 22 | 94.9 | 91.1999615839011 | 3.70003841609892 |
| 23 | 94.2 | 94.8998222297464 | -0.699822229746388 |
| 24 | 104.1 | 94.2000336233199 | 9.8999663766801 |
| 25 | 105.3 | 104.099524351011 | 1.20047564898945 |
| 26 | 116.7 | 105.299942322528 | 11.4000576774716 |
| 27 | 113.2 | 116.69945227835 | -3.49945227835049 |
| 28 | 120.5 | 113.200168132989 | 7.29983186701079 |
| 29 | 124.2 | 120.499649275814 | 3.70035072418618 |
| 30 | 130.2 | 124.199822214741 | 6.0001777852586 |
| 31 | 141.3 | 130.199711718364 | 11.1002882816357 |
| 32 | 151.8 | 141.299466680926 | 10.5005333190743 |
| 33 | 151.1 | 151.799495496462 | -0.699495496462134 |
| 34 | 156.4 | 151.100033607622 | 5.2999663923782 |
| 35 | 155.9 | 156.399745360382 | -0.49974536038178 |
| 36 | 160 | 155.900024010524 | 4.09997598947646 |
| Extrapolation Forecasts of Exponential Smoothing | |||
| t | Forecast | 95% Lower Bound | 95% Upper Bound |
| 37 | 159.999803014539 | 148.82993000964 | 171.169676019439 |
orchestra answered 3 years agoRelated Solutions
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded
weekly
Data collected over 36 weeks
t
X
t
X
t
X
t
X
t
X
t
X
1
9.8
7
36.4
13
53.4
19
99.2
25
105.3
31
141.3
2
9.0
8
51.0
14
66.6
20
90.4
26
116.7
32
151.8
3
10.5
9
51.1
15
70.6
21
91.2
27
113.2
33
151.1
4
20.6
10
46.9
16
76.4
22
94.9
28
120.5
34
156.4
5
28.1
11
50.5
17...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded
weekly
Data collected over 36 weeks
t
X
t
X
t
X
t
X
t
X
t
X
1
9.8
7
36.4
13
53.4
19
99.2
25
105.3
31
141.3
2
9.0
8
51.0
14
66.6
20
90.4
26
116.7
32
151.8
3
10.5
9
51.1
15
70.6
21
91.2
27
113.2
33
151.1
4
20.6
10
46.9
16
76.4
22
94.9
28
120.5
34
156.4
5
28.1
11
50.5
17...
Consider the following times-series where the data is recorded weekly Data collected over 36 weeks t...
Consider the following times-series where the data is recorded
weekly
Data collected over 36 weeks
t
X
t
X
t
X
t
X
t
X
t
X
1
9.8
7
36.4
13
53.4
19
99.2
25
105.3
31
141.3
2
9.0
8
51.0
14
66.6
20
90.4
26
116.7
32
151.8
3
10.5
9
51.1
15
70.6
21
91.2
27
113.2
33
151.1
4
20.6
10
46.9
16
76.4
22
94.9
28
120.5
34
156.4
5
28.1
11
50.5
17...
Consider the following times-series where the data is recorded weekly Data collected over 36 week t...
Consider the following times-series where the data is recorded
weekly
Data collected over 36 week
t
X
t
X
t
X
t
X
t
X
t
X
1
9.8
7
36.4
13
53.4
19
99.2
25
105.3
31
141.3
2
9.0
8
51.0
14
66.6
20
90.4
26
116.7
32
151.8
3
10.5
9
51.1
15
70.6
21
91.2
27
113.2
33
151.1
4
20.6
10
46.9
16
76.4
22
94.9
28
120.5
34
156.4
5
28.1
11
50.5
17...
We consider data on weekly sales for coffee. Data has n = 18 weeks of coffee...
We consider data on weekly sales for coffee. Data has n = 18
weeks of coffee sales in Q units, the deal rate (D = 1 for usual
price, = 1.05 in weeks with 5% price reduction, and = 1.15 in weeks
with 15% price reduction), and advertisement (A = 1 with
advertisement, = 0 otherwise)
Model = log(Q) = B0 + B1D + B2A + u
estimate by OLS -> log(Q) = 0.701 (0.415) + 0.756D (0.091) +
0.242A...
We consider data on weekly sales for coffee. Data has n = 18 weeks of coffee...
We consider data on weekly sales for coffee. Data has n = 18
weeks of coffee sales in Q units, the deal rate (D = 1 for usual
price, = 1.05 in weeks with 5% price reduction, and = 1.15 in weeks
with 15% price reduction), and advertisement (A = 1 with
advertisement, = 0 otherwise)
Model = log(Q) = B0 + B1D + B2A + u
estimate by OLS -> log(Q) = 0.701 (0.415) + 0.756D (0.091) +
0.242A...
The following data are the the weights of 25 students recorded as follows: 39, 43, 36,...
The following data are the the weights of 25 students recorded
as follows: 39, 43, 36, 38, 46, 51, 33, 44, 44, 43, 63, 23, 35, 39,
23, 24, 33, 36, 49, 21, 30, 32, 33, 35, 36
Find the Mean, Median, Q1, Q3, IQR, Outliers (If there are no
outliers, write "None")
a) Without sketching the graph, reason and explain whether the
distribution is symmetric or skewed.
(b) Draw a sketchplot of this data
Consider the following time series data.
Consider the following time series data. Week123456Value181516131716a. Choose the correct time series plot.What type of pattern exists in the data? b. Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616 MSE: The forecast for week 7: c. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. WeekTime Series ValueForecast118215316413517616MSE: The...
Consider the following time series data.
Consider the following time series data.
Quarter
Year 1
Year 2
Year 3
1
5
8
10
2
2
4
8
3
1
4
6
4
3
6
8
(b)
Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise.
If required,...
The following times series shows the demand for a particular product over the past 10 months....
The following times series shows the demand for a particular
product over the past 10 months.
Month
1
2
3
4
5
6
7
8
9
10
Value
324
311
303
314
323
313
302
315
312
326
a. Use α = 0.2 to compute the
exponential smoothing values for the time series. Compute MSE and a
forecast for month 11.
b. Develop a three-week moving average for
this time series. Compute MSE and a forecast for month 11.
c. ...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why does a particular codon represent only one specific amino acid?
- Write a function template sort that takes two references to generic objects and switches them if...
- What 2 things happen to the melting point of a solid when an impurity is present?
- How Can Hominin Evolution be characterized as " mosaic evolution" Use examples of species from the...
- Absorption and Variable Costing Income Statements for Two Months and Analysis During the first month of...
- Mobile and wireless devices are being increasingly used in the Business Administration and Management Industry. write...
- What are the options that might be considered in relation to introducing flexible work practices? What...
ADVERTISEMENT