Using the retention data in the BALT301Final workbook, construct a model to pred
ID: 3292889 • Letter: U
Question
Using the retention data in the BALT301Final workbook, construct a model to predict retention (years at company). Use all the variables for the first model. Provide an analysis of the results (R2, tstat etc) plus propose and run one alternative model and compare the results to the first model.
Years at company
YrsEducation
College GPA
Age
Gender
College Grad
Local
10
18
3.01
33
F
Y
Y
10
16
2.78
25
M
Y
Y
10
18
3.15
26
M
Y
N
10
18
3.86
24
F
Y
Y
9.6
16
2.58
25
F
Y
Y
8.5
16
2.96
23
M
Y
Y
8.4
17
3.56
35
M
Y
Y
8.4
16
2.64
23
M
Y
Y
8.2
18
3.43
32
F
Y
Y
7.9
15
2.75
34
M
N
Y
7.6
13
2.95
28
M
N
Y
7.5
13
2.50
23
M
N
Y
7.5
16
2.86
24
M
Y
Y
7.2
15
2.38
23
F
N
Y
6.8
16
3.47
27
F
Y
Y
6.5
16
3.10
26
M
Y
Y
6.3
13
2.98
21
M
N
Y
6.2
16
2.71
23
M
Y
N
5.9
13
2.95
20
F
N
Y
5.8
18
3.36
25
M
Y
Y
5.4
16
2.75
24
M
Y
N
5.1
17
2.48
32
M
Y
N
4.8
14
2.76
28
M
N
Y
4.7
16
3.12
25
F
Y
N
4.5
13
2.96
23
M
N
Y
4.3
16
2.80
25
M
Y
N
4
17
3.57
24
M
Y
Y
3.9
16
3.00
26
F
Y
N
3.7
16
2.86
23
M
Y
N
3.7
15
3.19
24
M
N
N
3.7
16
3.50
23
F
Y
N
3.5
14
2.84
21
M
N
Y
3.4
16
3.13
24
M
Y
N
2.5
13
1.75
22
M
N
N
1.8
16
2.98
25
M
Y
N
1.5
15
2.13
22
M
N
N
0.9
16
2.79
23
F
Y
Y
0.8
18
3.15
26
M
Y
N
0.7
13
1.84
22
F
N
N
0.3
18
3.79
24
F
Y
N
Years at company
YrsEducation
College GPA
Age
Gender
College Grad
Local
10
18
3.01
33
F
Y
Y
10
16
2.78
25
M
Y
Y
10
18
3.15
26
M
Y
N
10
18
3.86
24
F
Y
Y
9.6
16
2.58
25
F
Y
Y
8.5
16
2.96
23
M
Y
Y
8.4
17
3.56
35
M
Y
Y
8.4
16
2.64
23
M
Y
Y
8.2
18
3.43
32
F
Y
Y
7.9
15
2.75
34
M
N
Y
7.6
13
2.95
28
M
N
Y
7.5
13
2.50
23
M
N
Y
7.5
16
2.86
24
M
Y
Y
7.2
15
2.38
23
F
N
Y
6.8
16
3.47
27
F
Y
Y
6.5
16
3.10
26
M
Y
Y
6.3
13
2.98
21
M
N
Y
6.2
16
2.71
23
M
Y
N
5.9
13
2.95
20
F
N
Y
5.8
18
3.36
25
M
Y
Y
5.4
16
2.75
24
M
Y
N
5.1
17
2.48
32
M
Y
N
4.8
14
2.76
28
M
N
Y
4.7
16
3.12
25
F
Y
N
4.5
13
2.96
23
M
N
Y
4.3
16
2.80
25
M
Y
N
4
17
3.57
24
M
Y
Y
3.9
16
3.00
26
F
Y
N
3.7
16
2.86
23
M
Y
N
3.7
15
3.19
24
M
N
N
3.7
16
3.50
23
F
Y
N
3.5
14
2.84
21
M
N
Y
3.4
16
3.13
24
M
Y
N
2.5
13
1.75
22
M
N
N
1.8
16
2.98
25
M
Y
N
1.5
15
2.13
22
M
N
N
0.9
16
2.79
23
F
Y
Y
0.8
18
3.15
26
M
Y
N
0.7
13
1.84
22
F
N
N
0.3
18
3.79
24
F
Y
N
Explanation / Answer
When Every variable is used ,
SUMMARY OUTPUT
R^2 =
over-all p-value = 0.001136 < 0.05
hence the model is significant
if p-value of any variable is less than 0.05 , then the variable is significant
here only Local is significant
we remove Male , College GPA , then conduct the regression again
here
which is more than previous value
overall model is significant again
as p-value is 000197976
SUMMARY OUTPUT
Regression Statistics Multiple R 0.685822138 R Square 0.470352005 Adjusted R Square 0.37405237 Standard Error 2.247401959 Observations 40 ANOVA df SS MS F Significance F Regression 6 148.0168363 24.66947271 4.884255302 0.001136047 Residual 33 166.6769137 5.050815567 Total 39 314.69375 Coefficients Standard Error t Stat P-value Lower 95% Intercept -1.330477104 5.763506721 -0.230845069 0.818860412 -13.05641969 YrsEducation 0.083979089 0.48331756 0.17375551 0.863119116 -0.899337881 College GPA -0.745109069 1.034889319 -0.719989138 0.476600602 -2.85060722 Age 0.181607005 0.118173863 1.536778107 0.13388154 -0.058819526 Male 0.327410634 0.778243368 0.420704689 0.676697966 -1.255937404 College Grad 1.391804392 1.426061927 0.975977526 0.336176258 -1.509540414 Local 3.492096285 0.792831286 4.404589408 0.000105319 1.879068905Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.