Sum of Squares df Mean Squares F Sig Regression Residual Total 231.539 29.782 261.321 1 111 112 231.539
|
Sum of
Squares |
df | Mean Squares | F | Sig | |
|
Regression
Residual Total |
231.539
29.782 261.321 |
1
111 112 |
231.539
.268 |
862.968 | .000 a |
|
Regression
Residual Total |
232.608
28.713 261.321 |
2
110 112 |
116.304
.261 |
445.561 | .000 b |
ANOVA
a predictors (constant) LNPHONE
b predictors (constant)LNPHONE, BIRTHRAT
c dependent variable: LNGDP
Coefficients 2
| Unstandardized coefficients |
Standardized
coefficients |
T | Sig. | corelations |
Collinarity
statistics |
|||||
| B | Std.error | beta |
Zero
order |
partial | part | tolerance | VIF | |||
|
(constant
LNPHONE |
6.389
.738 |
.058
.025 |
.941 |
110.662
29.376 |
.000
.000 |
.941 | .941 | .941 | 1.000 | 1.000 |
|
(constant)
LNPHONE BIRTHRAT |
6.878
.663 -1.29e-02 |
.248
.044 .006 |
.849
-.113 |
27.744
15.238 -2.024 |
.000
.000 .045 |
.941
-.811 |
.824
-.189 |
.482
-.064 |
.322
.322 |
3.104
3.104 |
Dependent variable: LNGDP
Excluded variables
| Beta In | T | Sig. |
Partial
Correlation |
Collinarity Statistics | |||
| Tolerance | VIF |
Minimum
Tolerance |
|||||
|
URBAN
BIRTHRAT LNRADIO |
.095
a
-.113 a .026 a |
1.901
-2.024 .557 |
.060
.045 .579 |
.178
-.189 .053 |
.404
.322 .461 |
2.475
3.104 2.171 |
.404
.322 .461 |
|
URBAN
LNRADIO |
.091
b
.021 b |
1.848
.455 |
.067
.650 |
.174
.044 |
.403
.459 |
2.479
2.178 |
.225
.243 |
Predictors in the model (constant) LNPHONE
Predictors in the model(constant)LNPHONE,BIRTHRAT
Dependent Variable LNGDP
- Evaluate the following statistics, is multicollinearity a problem?
- What variables create the model to predict lngdp ? Explain
- Is the model significant in predicting lngdp ? Explain
- What percentage of variance in lngdp is explained by the model?
- Write the regression equation for lngdp
Price: $6.78
Solution: The downloadable solution consists of 4 pages, 278 words.
Deliverable: Word Document
Deliverable: Word Document
