统计学第八章相关于回归分析.xls

SUMMARY OUTPUT 回归统计 Multiple R 0.882607 R Square 0.778996 Adjusted R Square0.747424 标准误差0.160818 观测值9 方差分析 dfSSMSFSignificance F 回归分析1 0.638119 0.638119 24.67361 0.001624 残差7 0.181037 0.025862 总计8 0.819156 Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0% 上限 95.0% Intercept 6.0178321.05226 5.718961 0.000721 3.529633 8.506031 3.529633 8.506031 X Variable 1-0.07041 0.014176 -4.96725 0.001624 -0.10393 -0.03689 -0.10393 -0.03689 列 1列 2 列 11 列 2-0.882611 81.80.21 76.60.58 76.60.85 75.70.68 73.80.74 72.20.93 71.20.72 70.81.22 68.51.25 848280787674727068 0 0.2 0.4 0.6 0.8 1 1.2 1.4 Series1 1.41.210.80.60.40.20 60 65 70 75 80 85 Series1 848280787674727068 0 0.2 0.4 0.6 0.8 1 1.2 1.4 Series1 848280787674727068 0 0.2 0.4 0.6 0.8 1 1.2 1.4 Series1 1.41.210.80.60.40.20 60 65 70 75 80 85 Series1 848280787674727068 0 0.2 0.4 0.6 0.8 1 1.2 1.4 Series1 SUMMARY OUTPUT 回归统计 Multiple R 0.952129 R Square 0.906549 Adjusted R Square0.890974 标准误差3.331262 观测值22 方差分析 dfSSMSFSignificance F 回归分析3 1937.749 645.9162 58.20479 1.83E-09 残差18 199.751511.0973 总计212137.5 Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0% 上限 95.0% Intercept 32.99309 3.138595 10.51206 4.12E-09 26.39914 39.58703 26.39914 39.58703 X Variable 10.071619 0.014755 4.853871 0.0001280.04062 0.1026180.04062 0.102618 X Variable 20.168727 0.039956 4.222811 0.000512 0.084782 0.252671 0.084782 0.252671 X Variable 30.179042 0.048869 3.663731 0.001776 0.076372 0.281711 0.076372 0.281711 列 1列 2列 3列 4 列 11 列 20.7253151 列 30.846655 0.5030071 列 40.733436 0.307223 0.6275141 791949999 771859079 70839783 741479290 69539486 70748090 71278988 70298094 65249092 71189596 63239585 62278492 63138990 5778174 58203681 50185536 60125090 52123769 50133837 53112773 4864185 4373235 9080706050403020100 0 50 100 150 200 250 Series1 Series2 Series3 9080706050403020100 0 50 100 150 200 250 Series1 Series2 Series3 9080706050403020100 0 50 100 150 200 250 Series1 Series2 Series3 9080706050403020100 0 50 100 150 200 250 Series1 Series2 Series3 9080706050403020100 0 50 100 150 200 250 Series1 Series2 Series3 9080706050403020100 0 50 100 150 200 250 Series1 Series2 Series3 SUMMARY OUTPUT 回归统计 Multiple R 0.99558 R Square0.99118 Adjusted R Square0.990853 标准误差5722.5 观测值29 方差分析 dfSSMSFSignificance F 回归分析1 9.94E+10 9.94E+10 3034.052 2.81E-29 残差27 8.84E+08 32747007 总计281E+11 Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0% 上限 95.0% Intercept -3906.06 1530.392 -2.55233 0.016672 -7046.16 -765.956 -7046.16 -765.956 X Variable 11.815669 0.032963 55.08223 2.81E-29 1.748034 1.883303 1.748034 1.883303 3645.2172239.1 4062.5792633.7 4545.6243007.9 4889.4613361.5 5330.4513714.8 5985.5524126.4 7243.7524846.3 9040.7375986.3 10274.386821.8 12050.627804.6 15036.829839.5 17000.9211164.2 18718.3212090.5 21826.214091.9 26937.2817203.3 35260.0221899.9 48108.4629242.2 59810.5336748.2 70142.4943919.5 78060