回归分析数据.xls

例题3 例题2 例题1 身高 体重 SUMMARY OUTPUT 回归统计 Multiple R R Square Adjusted R Square 标准误差 观测值 方差分析 回归分析 残差 总计 Intercept df SS MS F Significance F Coefficients t Stat P-value Lower 95% Upper 95% 下限 95.0% 上限 95.0% X Variable 1 RESIDUAL OUTPUT 预测 Y 标准残差 PROBABILITY OUTPUT 百分比排位 Y 序号 年份 收入（元）Xi 支出（元）Yi 工业GDP比重 工业劳动者比重 工业固定资产比重 工业定额资金流动比重 y x1 x2 x3 X Variable 2 X Variable 3 1991.00 48.90 15.80 65.20 30.90 1992.00 46.70 16.00 65.00 30.90 .73 1993.00 45.80 15.90 65.10 30.40 .53 1994.00 45.10 15.90 65.40 30.50 .37 1995.00 44.50 16.50 65.20 32.90 1.19 1996.00 45.10 16.70 66.30 38.60 13.00 1997.00 45.50 17.50 64.90 39.50 1998.00 45.80 17.70 65.00 40.10 1999.00 46.10 17.80 64.30 40.60 2000.00 47.40 17.30 64.30 42.40 3.00 14.40 4.80 3.37 .07 2001.00 45.80 17.10 64.90 51.20 9.00 12.83 1.43 2002.00 47.80 17.00 64.90 51.00 12.00 27.23 2003.00 49.40 17.20 64.15 52.65 170.05 52.03 3.27 9.71E-03 52.35 287.75 52.35 287.75 -1.43 .68 -2.11 .06 -2.97 .10 -2.97 .10 -1.60 .73 -2.18 .06 -3.25 .06 -3.25 .06 .11 .06 1.83 .10 -.02 .24 -.02 .24 1.00 46.62 2.28 2.21 3.85 44.50 2.00 46.65 .05 .05 11.54 45.10 3.00 46.58 -.78 -.76 19.23 45.10 4.00 46.11 -1.02 -.98 26.92 45.50 5.00 45.83 -1.33 -1.29 34.62 45.80 6.00 44.40 .70 .68 42.31 45.80 7.00 45.58 -.08 -.08 50.00 45.80 8.00 45.20 .60 .58 57.69 46.10 9.00 46.23 -.13 -.12 65.38 46.70 10.00 47.14 .26 .25 73.08 47.40 11.00 47.41 -1.61 -1.55 80.77 47.80 12.00 47.53 .27 .26 88.46 48.90 13.00 48.62 .78 .76 96.15 49.40 X Variable 1 残差 X Variable 1 Residual Plot X Variable 2 残差 X Variable 2 Residual Plot X Variable 3 残差 X Variable 3 Residual Plot Y 预测 Y X Variable 1 Y X Variable 1 Line Fit Plot Y 预测 Y X Variable 2 Y X Variable 2 Line Fit Plot Y 预测 Y X Variable 3 Y X Variable 3 Line Fit Plot Sample Percentile Y Normal Probability Plot 1.00 180.00 170.00 2.00 200.00 166.00 3.00 220.00 190.00 4.00 240.00 195.00 5.00 260.00 210.00 6.00 280.00 215.00 7.00 300.00 220.00 8.00 320.00 240.00 9.00 340.00 255.00 10.00 360.00 250.00 1.55 50.00 1.60 52.00 1.65 57.00 .95