我有一个小数据集,出于某种原因,输出与Excel不匹配
这就是我所做的。我必须:
这是我在Google表单上得到的输出:
此输出还与excel输出匹配
但是,当我在statsmodel上执行以下操作时:
milesTravelled = [89.0, 66.0, 78.0, 111.0, 44.0, 77.0, 80.0, 66.0, 109.0, 76.0]
travelTime = [7.0, 5.4, 6.6, 7.4, 4.8, 6.4, 7.0, 5.6, 7.3, 6.4]
model = sm.OLS(travelTime, milesTraveled).fit()
print(model.summary())
我得到以下信息:
OLS Regression Results
=======================================================================================
Dep. Variable: Travel Time R-squared (uncentered): 0.985
Model: OLS Adj. R-squared (uncentered): 0.983
Method: Least Squares F-statistic: 575.6
Date: Mon, 01 Feb 2021 Prob (F-statistic): 1.82e-09
Time: 10:18:44 Log-Likelihood: -11.951
No. Observations: 10 AIC: 25.90
Df Residuals: 9 BIC: 26.20
Df Model: 1
Covariance Type: nonrobust
==================================================================================
coef std err t P>|t| [0.025 0.975]
----------------------------------------------------------------------------------
Miles Traveled 0.0781 0.003 23.991 0.000 0.071 0.085
==============================================================================
Omnibus: 2.179 Durbin-Watson: 2.654
Prob(Omnibus): 0.336 Jarque-Bera (JB): 1.033
Skew: -0.777 Prob(JB): 0.597
Kurtosis: 2.741 Cond. No. 1.00
==============================================================================
如您所见,标准误差、R平方等的值与Google Sheet/Excel完全不匹配。我做错了什么?我该怎么做才能得到像Google Sheet/Excel这样的精确结果摘要
默认情况下,
OLS
类在线性模型中不包含常量项。您可以使用sm.add_constant
为OLS
创建适当的exog
参数:相关问题 更多 >
编程相关推荐