1
answer
0
watching
96
views
bluelouse209Lv1
28 Sep 2019
The following data-series refers to a company's revenue.
Year
Revenue
1
1016
2
921
3
934
4
976
5
930
6
1052
7
1184
8
1089
9
1087
10
1154
11
1330
12
1980
13
2223
14
2203
15
2514
16
2726
17
3185
18
3351
19
3438
Use Holt's linear trend method, with an alpha of 0.76 and a beta* of 0.69, and an initial level value of 1583, and an initial slope value of 13.6 to forecast values for the next 10 years after Year 19.
Please create and upload your answers in an Excel file with formulas.
The following data-series refers to a company's revenue.
Year | Revenue |
1 | 1016 |
2 | 921 |
3 | 934 |
4 | 976 |
5 | 930 |
6 | 1052 |
7 | 1184 |
8 | 1089 |
9 | 1087 |
10 | 1154 |
11 | 1330 |
12 | 1980 |
13 | 2223 |
14 | 2203 |
15 | 2514 |
16 | 2726 |
17 | 3185 |
18 | 3351 |
19 | 3438 |
Use Holt's linear trend method, with an alpha of 0.76 and a beta* of 0.69, and an initial level value of 1583, and an initial slope value of 13.6 to forecast values for the next 10 years after Year 19.
Please create and upload your answers in an Excel file with formulas.
Chika IlonahLv10
28 Sep 2019