多元回归分析.xlsx
SUMMARYOUTPUT
回归统计
MultipleR 0.951659178
RSquare 0AdjustedRSquare 0.878699531
标准误差 0.109879244
观测值 10
方差分析
df SS MS F SignificanceF
回归分析 2 0.811286477 0.405643239 330.000257937
残差 7 0.084514139 0.012073448
总计 9 0.895800616
Coefficients 标准误差 tStat P-value Lower95% Upper95% 下限95.0% 上限95.0%
Intercept 0.656410128 0.264208569 2.484439202 0.041936608 0.031656137 1.281164118 0.031656137 1.281164118
XVariable1 1.159945458 0.150566419 7.703878886 0.000115877 0.803912452 1.515978465 0.803912452 1.515978465
XVariable2 -0.404369141 0.144500017 -2.798402026 0.026585237 -0.746057385 -0.062680896 -0.746057385 -0.062680896