第10章 回归分析.xls

饭店学生人数（千人） 季营业额（千元） 1258 26105 3888 48118 512117 616137 720157 820169 922149 1026202 产量（x)成本（y） 1.051.52 4.2113.73 5.1013.07 6.2022.81 8.7530.58 2.389.32 1.495.52 4.7115.23 7.2122.33 4.8618.96 9.9827.66 9.2027.06 8.3324.28 2.869.90 合计76.33241.97 用函数计算 截距 b01.261978 =intercept(c2:c15,b2:b15) 斜率 b12.938587 =slope(c2:c15,b2:b15) 估计标准误差2.368808 =steyx(c2:c15,b2:b15) 测定系数0.934449 =rsq(c2:c15,b2:b15) 面积(平方米）价格（千元） 128.00164.90 215.5054.90 314.5069.90 412.4059.90 519.0084.00 612.0048.50 732.00387.50 817.5042.50 924.00103.50 1020.00119.50 1116.0069.90 1214.9058.90 1320.4096.00 1419.50104.80 1522.50116.90 销售额销售额广播广播电视电视 8181317 11012337 7813330 10764122 12532230 8361721 7102425 6841725 10072323 9521128 8761227 8213122 6331030 14283225 11592723 7111718 8002129 7181530 15163431 7522316 产量产量成本成本 473.0074.58 639.0055.93 741.0064.51 824.0047.55 847.0051.24 914.0038.74 939.0037.28 956.0037.29 972.0048.08 1024.0044.89 1055.0038.03 1056.0047.25 1837.0036.24 1132.0026.47 1136.0041.65 1175.0032.94 2021.0048.30 1240.0039.35 1253.0024.78 1281.0039.36 1285.0031.74 2305.0063.31 1319.0027.28 1366.0037.01 1766.0041.07 1474.0027.46 2178.0051.50 1403.0033.30 1407.0031.52 1443.0039.39 1457.0032.36 1467.0037.35 1973.0049.34 1493.0032.26 1523.0026.70 1542.0028.85 2066.0051.46 1568.0041.89 1607.0034.22 1611.0028.72 1642.0040.66 1673.0041.58 1699.0031.78 1703.0043.05 1771.0046.33 1868.0047.83 1884.0042.64 2154.0049.15 2249.0060.19 2345.0079.96 产量产量ln(产量产量)收益收益 4736.161.47 6396.467.94 7416.617.28 8246.716.55 8746.779.18 9146.8216.67 9396.8414.90 9566.8614.91 9726.8815.81 10246.9313.63 10556.9617.41 10566.9617.42 11327.0322.51 11367.0415.39 10756.9814.53 12407.1224.58 12537.1315.93 12817.1624.51 12857.1617.55 13197.1823.31 13667.2227.01 14037.2530.3 14077.2529.52 14437.2729.39 14577.2832.36 14677.2930.35 14747.3027.46 14937.3132.26 15237.3323.75226337 12427.1220.26227709 15687.3629.42068587 16077.3827.03379973 16117.3820.17097394 16427.4028.55681756 16737.4229.20296296 14997.3122.32010974 17037.4430.23539095 17667.4837.07 17717.4832.53903978 18377.5227.15 18687.5333.59253772 18847.5429.94743484 19737.5936.34 20217.6132.89 20667.6336.14200274 21547.6832.51961591 21787.6938.5 22497.7238.25004115 23057.7441.24 23457.7636.49316872 产值固定资产投资 职工工资ln(产值） ln（固定资产） ln（工资） 19351.548245.36.349.8710.781.85 26605.560767.17.4710.1911.012.01 32794.566277.97.7410.4011.102.05 34169.277968.47.9710.4411.262.08 35269.685790.28.4110.4711.362.13 42357.692809.48.9810.6511.442.20 36837.7102667.39.7510.5111.542.28 60704.7120764.410.4511.0111.702.35 71522.2130415.211.8411.1811.782.47 77747.3132074.712.8411.2611.792.55 81923.4162437.213.5911.3112.002.61 91470.6212474.115.3611.4212.272.73 113296.8191797.914.7411.6412.162.69 138386.6310240.315.0311.8412.652.71 年份时间序号gdp 197813624.1 197924038.2 198034517.8 198144862.4 198255294.7 198365934.5 198477171 198588964.4 1986910202.2 19871011962.5 19881114928.3 19891216909.2 19901318547.9 19911421617.8 19921526638.1 19931634634.4 19941746759.4 19951858478.1 19961967884.6 199720139688 1998211 199922 c1 统计成绩统计成绩绩分点绩分点是否使用计算机 1004是 953.4是 561.2是 963.6是 662.5否 752.1是 863.1是 631.7是 964是 803.4否 902.9否 843.1否 621.9否 682.2否 923.7是 661.9是 601.7否 924否 631.1是 722.7否 绩分点统计成绩 价格居住面积评估价格建筑等级 265217.8低 3166123.8低 37.469428中 34.874326.2中 39.278722.4中 3882528.2中 39.688325.8中 31.292020.8低 37.296514.6中 38.4101126中 43.6104730中 44.8106029.2高 40.6107924.2中 41.8116429.4高 45.2129823.6高 summary output 回归统计 multiple r0.959952 r square0.921507 adjusted r square0.89011 标准误差1.783367 观测值15 方差分析 significance fdf 回归分析1.67e-054 残差10