Description
Only do question 6: Based on last week’s “That’s Entertainment” website, now create a 5 Bucket Gains Chart).
and you need to use "autos_mpg" file to finish it.
The answer for question 1-5 are in "assignment 6"
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Please check it, there is still problem with 5 buckets gain chart, i'm trying to fix.... I need your review,
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.822541082
R Square
0.676573831
Adjusted R Square
0.673281962
Standard Error
4.467558369
Observations
398
ANOVA
df
Regression
Residual
Total
Intercept
cylinders
displacement
horsepower
acceleration
4
393
397
SS
16408.65791
7843.917566
24252.57548
MS
F
4102.164478 205.5287586
19.95907778
Coefficients
48.23348594
-0.666101861
-0.025746521
-0.091821598
-0.419827778
Standard Error
2.761507615
0.426449649
0.008552061
0.015668056
0.114492605
t Stat
P-value
17.46635993 5.67992E-51
-1.561970712 0.119099754
-3.010563423 0.00277593
-5.860433417 9.78012E-09
-3.666854978 0.000279328
Q6:
The p value associated with displacement, horsepower and acceleration is
lower than 0.05. This indicates that these variable are significant predictor
of mpg.
The slope of displacement the coefficient is -0.02. It indicates that order
decreases by 0.02 for every 1 increase in displacemnt.
Significance F
6.27697E-95
Lower 95%
42.80431057
-1.504509809
-0.042560032
-0.122625287
-0.64492237
The slope of displacement the coefficient is -0.02. It indicates that order
decreases by 0.02 for every 1 increase in displacemnt.
Upper 95%
53.66266132
0.172306086
-0.008933011
-0.061017909
-0.194733186
Lower 95.0%
Upper 95.0%
42.80431057
53.66266132
-1.504509809
0.172306086
-0.042560032 -0.008933011
-0.122625287 -0.061017909
-0.64492237 -0.194733186
is
autos_mpg
mpg
18.0
cylinders
displacement
8
307
horsepower
130
acceleration
12
weight
model_year
3504
70
origin
1
car_name
chevrolet chevelle malibu
15.0
8
350
165
12
3693
70
1
buick skylark 320
18.0
8
318
150
11
3436
70
1
plymouth satellite
16.0
8
304
150
12
3433
70
1
amc rebel sst
17.0
8
302
140
11
3449
70
1
ford torino
198
10
15.0
8
429
4341
70
1
ford galaxie 500
14.0
8
454
220
9
4354
70
1
chevrolet impala
14.0
8
440
215
9
4312
70
1
plymouth fury iii
14.0
8
455
225
10
4425
70
1
pontiac catalina
15.0
8
390
190
9
3850
70
1
amc ambassador dpl
15.0
8
383
170
10
3563
70
1
dodge challenger se
14.0
8
340
160
8
3609
70
1
plymouth 'cuda 340
15.0
8
400
150
10
3761
70
1
chevrolet monte carlo
14.0
8
455
225
10
3086
70
1
buick estate wagon (sw)
24.0
4
113
95
15
2372
70
3
toyota corona mark ii
22.0
6
198
95
16
2833
70
1
plymouth duster
18.0
6
199
97
16
2774
70
1
amc hornet
21.0
6
200
85
16
2587
70
1
ford maverick
27.0
4
97
88
15
2130
70
3
datsun pl510
26.0
4
97
46
21
1835
70
2
volkswagen 1131 deluxe sedan
25.0
4
110
87
18
2672
70
2
peugeot 504
24.0
4
107
90
15
2430
70
2
audi 100 ls
25.0
4
104
95
18
2375
70
2
saab 99e
26.0
4
121
113
13
2234
70
2
bmw 2002
21.0
6
199
90
15
2648
70
1
amc gremlin
10.0
8
360
215
14
4615
70
1
ford f250
10.0
8
307
200
15
4376
70
1
chevy c20
11.0
8
318
210
14
4382
70
1
dodge d200
9.0
8
304
193
19
4732
70
1
hi 1200d
27.0
4
97
88
15
2130
71
3
datsun pl510
4
140
25.0
4
113
95
14
2228
71
3
toyota corona
25.0
28.0
4
98
102
90
19
16
2046
2264
71
71
1
1
ford pinto
chevrolet vega 2300
19.0
6
232
100
13
2634
71
1
amc gremlin
16.0
6
225
105
16
3439
71
1
plymouth satellite custom
17.0
6
250
100
16
3329
71
1
chevrolet chevelle malibu
19.0
6
250
88
16
3302
71
1
ford torino 500
18.0
6
232
100
16
3288
71
1
amc matador
14.0
8
350
165
12
4209
71
1
chevrolet impala
14.0
8
400
175
12
4464
71
1
pontiac catalina brougham
14.0
8
351
153
14
4154
71
1
ford galaxie 500
14.0
8
318
150
13
4096
71
1
plymouth fury iii
12.0
8
383
180
12
4955
71
1
dodge monaco (sw)
13.0
8
400
170
12
4746
71
1
ford country squire (sw)
13.0
8
400
175
12
5140
71
1
pontiac safari (sw)
18.0
6
258
110
14
2962
71
1
amc hornet sportabout (sw)
22.0
4
140
72
19
2408
71
1
chevrolet vega (sw)
19.0
6
250
100
15
3282
71
1
pontiac firebird
18.0
6
250
88
15
3139
71
1
ford mustang
23.0
4
122
86
14
2220
71
1
mercury capri 2000
28.0
4
116
90
14
2123
71
2
opel 1900
30.0
4
79
70
20
2074
71
2
peugeot 304
30.0
4
88
76
15
2065
71
2
fiat 124b
31.0
4
71
65
19
1773
71
3
toyota corolla 1200
35.0
4
72
69
18
1613
71
3
datsun 1200
27.0
4
97
60
19
1834
71
2
volkswagen m...