受约束的回归及检验例题
- 格式:xlsx
- 大小:15.32 KB
- 文档页数:4
8.214154 8.462293 7.687186 7.839825 8.021896 7.692857 8.58762 8.48357 8.929247 6.766088 8.436285 5.137562 5.785455
8.718191 9.130025 7.960899 7.842133 8.473847 8.088037 9.003277 8.567924 8.92516 6.892154 9.832364 6.41495 7.328562
K 3078.22 1684.43 2742.77 1973.82 5917.01 1758.77 939.1 694.94 363.48 2511.99 973.73 516.01 3785.91 8688.03 2798.9 1808.44 1118.81 2052.16 6113.11 9228.25 2866.65 2545.63 4787.9 3255.29 8129.68 5260.2 7518.79 984.52 18626.94 610.91 1523.19
L 113 67 84 27 327 120 58 31 16 66 58 28 61 254 83 33 43 61 240 222 80 96 222 163 244 145 138 46 218 19 45
Unrestricted regression lnY lnK lnL 8.222204 8.032107 4.727388 7.274147 7.429183 4.204693 7.468724 7.916724 4.430817 7.280208 7.587726 3.295837 8.546616 8.685587 5.78996 7.736814 7.47237 4.787492 7.204276 6.844922 4.060443 6.487334 6.543826 3.433987 5.913989 5.895724 2.772589 7.371716 7.828831 4.189655 6.424399 6.881134 4.060443 6.426391 6.246126 3.332205 8.395972 8.239042 4.110874 8.656785 9.069701 5.537334 7.485138 7.936982 4.418841 7.125339 7.50022 3.496508 6.700362 7.020021 3.7612 7.549451 7.626648 4.110874
t Stat 1.586004 3.454149 1.789741
P-value 0.123969 0.001776 0.084317
lnY=1.153994+0.609236lnK+0.360796lnL
Restrict: α +β =1 代入,化简,移项,右边只保留lnA和有回归系数的项,得到约束条件下新的回归模型为 Y'=lnY-lnL=lnA+α ln(K/L) lnY-lnL 3.494817 3.069454 3.037908 3.984371 2.756656 2.949322 3.143833 3.053347 3.141401 3.182061 2.363956 3.094187 4.285098 3.11945 3.066297 3.628832 2.939162 3.438577 2.733515 3.059616 3.305159 3.275477 2.619219 2.599107 3.090452 3.506836 4.001994 2.937447 3.05179 2.193123 1.978792 ln(K/L) 3.304719 3.22449 3.485907 4.291889 2.895626 2.684878 2.784479 3.109838 3.123136 3.639176 2.820691 2.913922 4.128168 3.532367 3.518141 4.003712 3.258821 3.515774 3.237552 3.727347 3.578873 3.277785 3.07117 2.994286 3.506109 3.591191 3.997907 3.063513 4.447869 3.470511 3.5219
4.195972
可见计算出的F统计量明显小于临界值,不拒绝原约束条件表示α +β =1是
Significance F 8.03E-11
Lower 95%Upper 95% 下限 95.0% 上限 95.0% -0.33645 2.644439 -0.33645 2.644439 0.247942 0.970529 0.247942 0.970529 -0.05214 0.773738 -0.05214 0.773738
Significance F 0.001511
Lower 95%Upper 95% 下限 95.0% 上限 95.0% -0.19448 2.246576 -0.19448 2.246576 0.25311 0.963173 0.25311 0.963173
拒绝原约束条件表示α +β =1是合理的,可接受的
SUMMARY OUTPUT 回归统计 Multiple R 0.899958 R Square 0.809925 Adjusted R Square 0.796348 标准误差 0.425538 观测值 31 方差分析 df 回归分析 残差 总计 SS MS F 2 21.60493 10.80246 59.65501 28 5.070303 0.181082 30 26.67523
SUMMARY OUTPUT 回归统计 Multiple R 0.545313 R Square 0.297366 Adjusted R Square 0.273138 标准误差 0.418891 观测值 31 方差分析 df 回归分析 残差 总计 SS MS F 1 2.153586 2.153586 12.27328 29 5.088613 0.175469 30 7.242199
Coefficients 标准误差 t Stat P-value Intercept 1.026048 0.596769 1.719339 0.096211 X Variable 10.608141 0.17359 3.503324 0.001511
lnY-lnL=1.026048+0.608141ln(K/L) lnY=1.026048+0.608141lnK+0.391859lnL F= F0.05(1,28)= (RSSR-RSSU)/kU-kR RSSU/n-kU-1 = 0.101118
5.480639 5.402677 4.382027 4.564348 5.402677 5.09375 5.497168 4.976734 4.927254 3.828641 5.384495 2.944439 3.806662
Coefficients 标准误差 Intercept 1.153994 0.727611 X Variable 10.609236 0.176378 X Variable 20.360796 0.201591
Y 3722.7 1442.52 1752.37 1451.29 5149.3 2291.16 1345.17 656.77 370.18 1590.36 616.71 617.94 4429.19 5749.02 1781.37 1243.07 812.7 1899.7 3692.85 4732.9 2180.23 2539.76 3046.95 2192.63 5364.83 4834.68 7549.58 867.91 4611.39 170.3 325.53