SUMMARY OUTPUT Regression Statistics Multiple R 0.6406 R Square 0.4103 Adjusted
ID: 3258544 • Letter: S
Question
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.6406
R Square
0.4103
Adjusted R Square
0.3632
Standard Error
1.3604
Observations
55.0000
ANOVA
df
SS
MS
F
Significance F
Regression
4.0000
64.3884
16.0971
8.6983
0.0000
Residual
50.0000
92.5302
1.8506
Total
54.0000
156.9186
Coefficients
Standard Error
t Stat
P-value
Intercept
9.6570
4.6102
2.0947
0.0413
HSDegree (%)
0.0604
0.0507
1.1912
0.2392
BaDegree (%)
-0.1693
0.0380
-4.4496
0.0000
FemHead (%)
-0.0112
0.0577
-0.1936
0.8473
MedAge (years)
-0.0607
0.0881
-0.6892
0.4939
Answer the following questions in the response area, when doing intermediate steps round to 4 decimal places, round your answers to 2 decimal places:
a. What is the predicted unemployment rate when HSDegree = 70%, BaDegree = 18%, FemHead = 12%, and MedAge = 36 (show your work you might get partial credit)
b. When a county's percent of the population earning a Bachelor's Degree increases by one percentage point, how much and in what direction does the Unemployment Rate change?
c. List the independent variable(s).
d. How much of the variation in Unemployment rate is explained by this regression model?
e. At the one percent significance level, does an increase in Bachelor degree earning decrease unemployment rate, why? (if work is needed, show the work)
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.6406
R Square
0.4103
Adjusted R Square
0.3632
Standard Error
1.3604
Observations
55.0000
ANOVA
df
SS
MS
F
Significance F
Regression
4.0000
64.3884
16.0971
8.6983
0.0000
Residual
50.0000
92.5302
1.8506
Total
54.0000
156.9186
Coefficients
Standard Error
t Stat
P-value
Intercept
9.6570
4.6102
2.0947
0.0413
HSDegree (%)
0.0604
0.0507
1.1912
0.2392
BaDegree (%)
-0.1693
0.0380
-4.4496
0.0000
FemHead (%)
-0.0112
0.0577
-0.1936
0.8473
MedAge (years)
-0.0607
0.0881
-0.6892
0.4939
Explanation / Answer
Answer:
Answer the following questions in the response area, when doing intermediate steps round to 4 decimal places, round your answers to 2 decimal places:
unemployment rate = 9.6570+0.0604*HSDegree (%)-0.1693*BaDegree (%)-0.0112*FemHead (%)-0.0607*MedAge (years)
predicted unemployment rate =9.6570+0.0604*70-0.1693*18-0.0112*12-0.0607*36
=8.518
=8.52 ( 2 decimals)
An increase of one % in Bachelor degree earning, there is decrease unemployment rate by 0.1693.
HSDegree (%), BaDegree (%), FemHead (%), MedAge (years)
Multiple R = 0.6406
64.06% explained.
Calculated t=-4.4496, P=0.0000 which is < 0.01 level. The coefficient is significantly decreasing.
An increase of one % in Bachelor degree earning, decrease unemployment rate by 0.1693.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.