
The accompanying table Multinat Becession provide data fortar, nicotine and carbon monoxide contents in a certain...
data set
Nicotine (Y)
Tar (X1)
CO (X2)
0.8
13
18
0.8
13
18
0.2
1
2
1.1
18
17
1
16
18
1.1
15
18
1.2
15
14
1.1
15
15
0.9
14
15
0.9
14
14
QUESTIONS 9 point The accompanying table, MultiLinear Regression 4, provides data for tar, nicotine, and carbon monoxide (Cco) contents in a certain brand of cigarette. All measurements are in milligrams (mg). Part a) Run the Multilinear Regression Analysis in Excel with both...
6.Use Exponential smoothing forecasts with alpha of 0.1, 0.2, ..., 0.9 to predict March 2019 demand. Identify the value of alpha that results in the lowest MAD. 7.Find the monthly seasonal indices for the demand values using Simple Average (SA) method. Find the de-seasonalized demand values by dividing monthly demand by corresponding seasonal indices. 8.Use regression to perform trend analysis on the de-seasonalized demand values. Is trend analysis suitable for this data? Find MAD and explain the Excel Regression output...
INN
MARGIN
ROOMS
NEAREST
OFFICE
COLLEGE
INCOME
DISTTWN
1
61
3203
0.1
549
8
37
12.1
2
34
2810
1.5
496
17.5
39
0.4
3
46
2890
1.9
254
20
39
12.2
4
31.9
3422
1
434
15.5
36
2.7
5
57.4
2687
3.4
678
15.5
32
7.9
6
47.5
3080
2.4
488
13.5
31
6.7
7
54.4
2756
1.1
832
14.5
35
6.9
8
46.2
2244
0.7
496
15.5
38
8.9
9
54.1
2862
1.4
809
16.5
33
3...
INN
MARGIN
ROOMS
NEAREST
OFFICE
COLLEGE
INCOME
DISTTWN
1
44.2
3471
2.1
523
12
35
9.4
2
29.8
3567
1.8
140
13.5
42
5.7
3
38.4
3264
1.6
404
22.5
45
4.4
4
54.4
3234
1.1
649
19.5
35
6.5
5
34.5
2730
4
171
17
41
10.5
6
44.9
3003
3.4
402
15.5
37
4.6
7
46
2341
2
580
23
45
7.4
8
50.2
3021
2.6
572
8.5
33
9.3
9
46
2655
3.2
666
22
40
6.7...