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 2 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
- The Facts: Ann and Bill decided to start a coffee shop. They agreed Bill would provide...
- MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
- A firm's bonds have a maturity of 8 years with a $1,000 face value, have an...
- Naive reasoning suggests that a string theory vacuum with cosmological constant Lambda1 is always unstable as...
- I. Design and code a class Rectangle that has the following properties: Two private members double...
- A bond has a $1,000 par value, 10 years to maturity, and an 8% annual coupon...
- The following are the monthly rates of return for Madison Cookies and for Sophie Electric during...
ADVERTISEMENT