该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
码的代码:
import statsmodels.formula.api as sm
from pandas import read_excel
df = read_excel('g://tj cj x.xlsx',sheetname='Sheet3',header=0)
formula='sum_x~sum_tj+sum_cj'
zz_one=sm.ols(formula,data=df).fit()
print(zz_one.summary2())
出的结果:
Results: Ordinary least squares
=================================================================
Model: OLS Adj. R-squared: 0.241
Dependent Variable: sum_x AIC: 319.8545
Date: 2019-12-18 11:31 BIC: 326.2359
No. Observations: 62 Log-Likelihood: -156.93
Df Model: 2 F-statistic: 10.68
Df Residuals: 59 Prob (F-statistic): 0.000110
R-squared: 0.266 Scale: 9.7171
------------------------------------------------------------------
Coef. Std.Err. t P>|t| [0.025 0.975]
------------------------------------------------------------------
Intercept 24.0767 3.0441 7.9093 0.0000 17.9854 30.1680
sum_tj -0.1899 0.0701 -2.7102 0.0088 -0.3300 -0.0497
sum_cj -0.0246 0.0751 -0.3274 0.7445 -0.1748 0.1256
-----------------------------------------------------------------
Omnibus: 0.075 Durbin-Watson: 1.910
Prob(Omnibus): 0.963 Jarque-Bera (JB): 0.231
Skew: -0.064 Prob(JB): 0.891
Kurtosis: 2.730 Condition No.: 604
=================================================================