请教大侠一个十分火急的问题

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

在做线性回归时我用了固定资产，静态收款质量，以及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

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：coefficients Collinearity Standardized correlations Probability 请教 大侠 火急

各位大虾献个身吧！