在做线性回归时我用了固定资产,静态收款质量,以及EBIT,因变量是商业负债。
回归结果均显著,但是逐步回归却将固定资产,静态收款质量排除,不知是什么原因?到底可不可以作为解释变量?
线性回归结果如下:
Descriptive Statistics
| | Mean | Std. Deviation | N |
| 商业负债 | 248.5248 | 509.29572 | 835 |
| 静态收款质量 | -120.4674 | 468.50097 | 835 |
| EBIT | 96.3691 | 134.75822 | 835 |
| 固定资产 | 485.8909 | 571.21171 | 835 |
Variables Entered/Removed(a)
| Model | Variables Entered | Variables Removed | Method |
| 1 | EBIT | . | Stepwise (Criteria: Probability-of-F-to-enter <= .050, Probability-of-F-to-remove >= .100). |
| 2 | 固定资产 | . | Stepwise (Criteria: Probability-of-F-to-enter <= .050, Probability-of-F-to-remove >= .100). |
| 3 | 静态收款质量 | . | Stepwise (Criteria: Probability-of-F-to-enter <= .050, Probability-of-F-to-remove >= .100). |
Model Summary
| Model | R | R Square | Adjusted R Square | Std. Error of the Estimate |
| 1 | .412(a) | .169 | .168 | 464.42467 |
| 2 | .446(b) | .199 | .197 | 456.48675 |
| 3 | .471(c) | .222 | .219 | 449.95188 |
Coefficients(a)
| Model | | Unstandardized Coefficients | Standardized Coefficients | t | Sig. | Correlations | Collinearity Statistics |
| | | B | Std. Error | Beta | | | Zero-order | Partial | Part | Tolerance | VIF |
| 1 | (Constant) | 98.603 | 19.763 | | 4.989 | .000 | | | | | |
| | EBIT | 1.556 | .119 | .412 | 13.036 | .000 | .412 | .412 | .412 | 1.000 | 1.000 |
| 2 | (Constant) | 50.366 | 21.315 | | 2.363 | .018 | | | | | |
| | EBIT | 1.150 | .139 | .304 | 8.300 | .000 | .412 | .277 | .258 | .717 | 1.396 |
| | 固定资产 | .180 | .033 | .202 | 5.497 | .000 | .364 | .187 | .171 | .717 | 1.396 |
| 3 | (Constant) | 46.778 | 21.022 | | 2.225 | .026 | | | | | |
| | EBIT | 1.116 | .137 | .295 | 8.162 | .000 | .412 | .272 | .250 | .715 | 1.399 |
| | 固定资产 | .239 | .034 | .268 | 6.959 | .000 | .364 | .235 | .213 | .633 | 1.579 |
| | 静态收款质量 | .180 | .036 | .166 | 5.034 | .000 | .021 | .172 | .154 | .862 | 1.160 |
Excluded Variables(c)
| Model | | Beta In | t | Sig. | Partial Correlation | Collinearity Statistics |
Tolerance | VIF | Minimum Tolerance |
| 1 | 静态收款质量 | .088(a) | 2.754 | .006 | .095 | .975 | 1.025 | .975 |
固定资产 | .202(a) | 5.497 | .000 | .187 | .717 | 1.396 | .717 |
| 2 | 静态收款质量 | .166(b) | 5.034 | .000 | .172 | .862 | 1.160 | .633 |