@betasy
2017-05-20T08:21:05.000000Z
字数 30199
阅读 1831
科研
import excel "G:\Stock Estimation Study\OriginalData\StockSteelPanel1992_2008_PanelData.xls", sheet("Sheet1") firstrow case(upper)
sort ZONE_CODE YEAR
xtset ZONE_CODE YEARpanel variable: ZONE_CODE (strongly balanced)```time variable: YEAR, 1992 to 2008delta: 1 unit
xtunitroot llc LOG_LIGHT_PER_AREA
Levin-Lin-Chu unit-root test for LOG_LIGHT_PER_AREA---------------------------------------------------Ho: Panels contain unit roots Number of panels = 159Ha: Panels are stationary Number of periods = 17AR parameter: Common Asymptotics: N/T -> 0Panel means: IncludedTime trend: Not includedADF regressions: 1 lagLR variance: Bartlett kernel, 8.00 lags average (chosen by LLC)------------------------------------------------------------------------------Statistic p-value------------------------------------------------------------------------------Unadjusted t -37.8053Adjusted t* -15.5151 0.0000------------------------------------------------------------------------------
对LOG_STOCK_PER_AREA做单位根检验
xtunitroot llc LOG_STOCK_PER_AREA
Levin-Lin-Chu unit-root test for LOG_STOCK_PER_AREA---------------------------------------------------Ho: Panels contain unit roots Number of panels = 159Ha: Panels are stationary Number of periods = 17AR parameter: Common Asymptotics: N/T -> 0Panel means: IncludedTime trend: Not includedADF regressions: 1 lagLR variance: Bartlett kernel, 8.00 lags average (chosen by LLC)------------------------------------------------------------------------------Statistic p-value------------------------------------------------------------------------------Unadjusted t -5.0934Adjusted t* -2.6353 0.0042------------------------------------------------------------------------------
xtwest LOG_LIGHT_PER_AREA LOG_STOCK_PER_AREA,lags(0)Calculating Westerlund ECM panel cointegration tests..........Results for H0: no cointegrationWith 159 series and 1 covariate-----------------------------------------------+Statistic | Value | Z-value | P-value |-----------+-----------+-----------+-----------|Gt | -4.355 | -40.949 | 0.000 |Ga | -6.445 | -7.326 | 0.000 |Pt | -29.049 | -19.372 | 0.000 |Pa | -2.541 | -6.598 | 0.000 |-----------------------------------------------+
xtreg LOG_STOCK_PER_AREA LOG_LIGHT_PER_AREA i.YEAR i.ZONE_CODE
Random-effects GLS regression Number of obs = 2,703Group variable: ZONE_CODE Number of groups = 159R-sq: Obs per group:within = 0.5383 min = 17between = 1.0000 avg = 17.0overall = 0.9941 max = 17Wald chi2(175) = 428679.43corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0000------------------------------------------------------------------------------------LOG_STOCK_PER_AREA | Coef. Std. Err. z P>|z| [95% Conf. Interval]-------------------+----------------------------------------------------------------LOG_LIGHT_PER_AREA | .1538709 .0236574 6.50 0.000 .1075031 .2002386|YEAR |1993 | -.012017 .0266248 -0.45 0.652 -.0642007 .04016671994 | .0135143 .0273098 0.49 0.621 -.0400119 .06704051995 | .0509433 .0275755 1.85 0.065 -.0031037 .10499021996 | .0922732 .0280408 3.29 0.001 .0373143 .14723211997 | .1230001 .029331 4.19 0.000 .0655124 .18048781998 | .1555406 .0295608 5.26 0.000 .0976025 .21347871999 | .1888044 .0304153 6.21 0.000 .1291916 .24841722000 | .2361662 .0306377 7.71 0.000 .1761173 .2962152001 | .2914527 .0307391 9.48 0.000 .2312051 .35170022002 | .3404478 .0308547 11.03 0.000 .2799738 .40092192003 | .3822695 .0309669 12.34 0.000 .3215755 .44296342004 | .4342341 .03115 13.94 0.000 .3731813 .49528682005 | .488491 .0311841 15.66 0.000 .4273713 .54961062006 | .5385048 .0312765 17.22 0.000 .477204 .59980562007 | .5843757 .0314047 18.61 0.000 .5228237 .64592782008 | .6089662 .0331787 18.35 0.000 .5439371 .6739953|ZONE_CODE |2 | 2.6485 .1014312 26.11 0.000 2.449698 2.8473013 | 5.272625 .1810327 29.13 0.000 4.917807 5.6274424 | .7695426 .0772966 9.96 0.000 .6180441 .92104125 | 3.964372 .139602 28.40 0.000 3.690758 4.2379876 | 4.062429 .1694399 23.98 0.000 3.730333 4.3945267 | 2.878907 .1073893 26.81 0.000 2.668428 3.0893868 | 2.764194 .0912072 30.31 0.000 2.585431 2.9429579 | 6.415639 .1348331 47.58 0.000 6.151371 6.67990610 | 4.937338 .133361 37.02 0.000 4.675955 5.19872111 | 7.333035 .2060008 35.60 0.000 6.929281 7.73678912 | 3.447864 .1152364 29.92 0.000 3.222005 3.67372413 | 6.422604 .1943077 33.05 0.000 6.041768 6.80344114 | 9.665833 .1739859 55.56 0.000 9.324827 10.0068415 | 2.321405 .0974262 23.83 0.000 2.130453 2.51235716 | 1.818854 .0819679 22.19 0.000 1.658199 1.97950817 | 8.834118 .2014314 43.86 0.000 8.43932 9.22891618 | 1.253586 .088556 14.16 0.000 1.08002 1.42715319 | .8064247 .1506135 5.35 0.000 .5112276 1.10162220 | 6.002451 .1625723 36.92 0.000 5.683815 6.32108621 | 2.777845 .1064371 26.10 0.000 2.569232 2.98645822 | 5.159056 .1644163 31.38 0.000 4.836806 5.48130623 | 4.603165 .1132599 40.64 0.000 4.381179 4.8251524 | .9965899 .0801605 12.43 0.000 .8394782 1.15370225 | 1.806606 .0896811 20.14 0.000 1.630834 1.98237726 | 2.347105 .0780555 30.07 0.000 2.194119 2.50009127 | 1.787024 .0796515 22.44 0.000 1.63091 1.94313828 | 2.765068 .1181023 23.41 0.000 2.533592 2.99654529 | 2.761307 .1079907 25.57 0.000 2.549649 2.97296430 | 5.131186 .1772579 28.95 0.000 4.783767 5.47860531 | -.4979067 .0847948 -5.87 0.000 -.6641015 -.331711832 | -.9841552 .0914051 -10.77 0.000 -1.163306 -.805004633 | 3.239665 .1057331 30.64 0.000 3.032432 3.44689834 | 4.733858 .1101153 42.99 0.000 4.518036 4.9496835 | 5.788988 .2078561 27.85 0.000 5.381598 6.19637836 | 6.877898 .1978046 34.77 0.000 6.490208 7.26558837 | 2.846325 .1093945 26.02 0.000 2.631916 3.06073438 | .1700638 .0772403 2.20 0.028 .0186755 .321452139 | 3.91477 .1356237 28.86 0.000 3.648952 4.18058740 | 2.45967 .0912924 26.94 0.000 2.28074 2.63859941 | 6.328014 .1635268 38.70 0.000 6.007507 6.64852142 | 6.87416 .1469482 46.78 0.000 6.586147 7.16217343 | 6.280236 .0800697 78.43 0.000 6.123302 6.4371744 | 6.19938 .1531185 40.49 0.000 5.899273 6.49948645 | 2.353939 .0880023 26.75 0.000 2.181458 2.5264246 | -.1995248 .1376864 -1.45 0.147 -.4693852 .070335647 | 7.357964 .1041148 70.67 0.000 7.153902 7.56202548 | 3.170046 .117906 26.89 0.000 2.938955 3.40113849 | 3.341632 .1267615 26.36 0.000 3.093184 3.5900850 | 4.472821 .142224 31.45 0.000 4.194067 4.75157551 | 1.048248 .0945956 11.08 0.000 .8628443 1.23365252 | -6.154685 .0774858 -79.43 0.000 -6.306555 -6.00281653 | 3.86321 .0837971 46.10 0.000 3.698971 4.0274554 | 4.064431 .144218 28.18 0.000 3.781768 4.34709355 | 1.737262 .0932491 18.63 0.000 1.554497 1.92002756 | 5.853154 .1539229 38.03 0.000 5.55147 6.15483757 | -4.978223 .0840264 -59.25 0.000 -5.142912 -4.81353558 | 4.664217 .1124479 41.48 0.000 4.443823 4.88461160 | 1.637694 .0987101 16.59 0.000 1.444226 1.83116261 | 2.575149 .0896822 28.71 0.000 2.399375 2.75092362 | 6.679395 .157858 42.31 0.000 6.369999 6.98879163 | 2.809901 .1010385 27.81 0.000 2.611869 3.00793364 | 7.540402 .2040098 36.96 0.000 7.14055 7.94025465 | 5.602549 .1341254 41.77 0.000 5.339668 5.8654366 | -1.68649 .1209592 -13.94 0.000 -1.923566 -1.44941467 | 4.68367 .137808 33.99 0.000 4.413572 4.95376968 | 5.839159 .1746362 33.44 0.000 5.496878 6.1814469 | 3.395247 .1162204 29.21 0.000 3.167459 3.62303470 | .8417734 .0770971 10.92 0.000 .690666 .992880971 | 1.402544 .0822478 17.05 0.000 1.241341 1.56374772 | 1.318445 .0770766 17.11 0.000 1.167377 1.46951273 | 2.684536 .1030241 26.06 0.000 2.482613 2.8864674 | 2.820352 .1109529 25.42 0.000 2.602889 3.03781675 | 5.484383 .1351866 40.57 0.000 5.219422 5.74934476 | 2.65618 .1070203 24.82 0.000 2.446424 2.86593677 | 4.337184 .1181732 36.70 0.000 4.105568 4.56879978 | 3.060977 .1067782 28.67 0.000 2.851696 3.27025979 | 3.527272 .1262391 27.94 0.000 3.279848 3.77469680 | 3.013241 .1258681 23.94 0.000 2.766544 3.25993781 | 5.029444 .133476 37.68 0.000 4.767836 5.29105282 | 6.023652 .1829804 32.92 0.000 5.665017 6.38228783 | 6.29951 .1666177 37.81 0.000 5.972945 6.62607584 | 5.071651 .1569709 32.31 0.000 4.763993 5.37930885 | 6.863879 .1744457 39.35 0.000 6.521971 7.20578686 | 3.777174 .1283662 29.42 0.000 3.52558 4.02876787 | 2.287752 .0819614 27.91 0.000 2.127111 2.44839488 | 5.841129 .1793523 32.57 0.000 5.489605 6.19265489 | .3523243 .0774652 4.55 0.000 .2004954 .504153390 | 5.498023 .1737487 31.64 0.000 5.157481 5.83856491 | 2.380049 .1019444 23.35 0.000 2.180242 2.57985692 | 1.622203 .0782357 20.73 0.000 1.468864 1.77554293 | 1.300299 .0894076 14.54 0.000 1.125063 1.47553595 | -.2894955 .0790201 -3.66 0.000 -.4443721 -.13461996 | 7.793941 .2089626 37.30 0.000 7.384382 8.203597 | 6.055929 .1839442 32.92 0.000 5.695405 6.41645398 | -.3703861 .0800052 -4.63 0.000 -.5271935 -.213578799 | 5.403139 .1568487 34.45 0.000 5.095721 5.710557100 | 3.754922 .1307143 28.73 0.000 3.498726 4.011117102 | 3.614245 .1087713 33.23 0.000 3.401057 3.827433103 | 2.025853 .0812623 24.93 0.000 1.866582 2.185124104 | 1.279829 .1676288 7.63 0.000 .9512822 1.608375106 | .9624385 .0830845 11.58 0.000 .7995958 1.125281107 | 4.512252 .1991718 22.66 0.000 4.121882 4.902621108 | 7.015268 .1861272 37.69 0.000 6.650466 7.380071109 | 4.294491 .1137096 37.77 0.000 4.071624 4.517358110 | 2.332366 .1005265 23.20 0.000 2.135338 2.529395111 | -.6747275 .0806277 -8.37 0.000 -.8327549 -.5167112 | 2.928976 .1273098 23.01 0.000 2.679454 3.178499113 | 3.692105 .1345081 27.45 0.000 3.428474 3.955736114 | 2.213963 .1202582 18.41 0.000 1.978262 2.449665115 | 3.482769 .1174638 29.65 0.000 3.252544 3.712994117 | 5.680001 .1175623 48.31 0.000 5.449584 5.910419118 | 1.413116 .0784168 18.02 0.000 1.259422 1.56681119 | 1.694842 .0976572 17.36 0.000 1.503437 1.886246120 | 2.374117 .0926357 25.63 0.000 2.192555 2.55568121 | 4.716376 .1142936 41.27 0.000 4.492365 4.940387122 | 5.430751 .1375887 39.47 0.000 5.161082 5.70042123 | 5.343048 .1514954 35.27 0.000 5.046123 5.639974124 | 5.115659 .1718226 29.77 0.000 4.778893 5.452425125 | 6.509617 .1725145 37.73 0.000 6.171495 6.847739126 | 5.814122 .1513897 38.40 0.000 5.517403 6.11084127 | 5.51431 .1106238 49.85 0.000 5.297491 5.731128128 | 1.891005 .092014 20.55 0.000 1.710661 2.071349129 | 4.636917 .1596551 29.04 0.000 4.323999 4.949835130 | 4.865759 .1569301 31.01 0.000 4.558182 5.173336131 | 4.912346 .1417026 34.67 0.000 4.634614 5.190078133 | 3.23187 .1236824 26.13 0.000 2.989457 3.474283134 | 2.486685 .0847015 29.36 0.000 2.320673 2.652697135 | 4.780616 .1226922 38.96 0.000 4.540144 5.021088136 | 2.373614 .0817923 29.02 0.000 2.213304 2.533924137 | 9.974795 .2152256 46.35 0.000 9.55296 10.39663139 | 5.308801 .1497967 35.44 0.000 5.015204 5.602397140 | 3.990747 .1159077 34.43 0.000 3.763572 4.217922141 | 1.007703 .0796294 12.65 0.000 .8516319 1.163773142 | 1.714296 .0828878 20.68 0.000 1.551839 1.876753143 | 4.451921 .1393913 31.94 0.000 4.178719 4.725123144 | 6.761062 .159327 42.44 0.000 6.448786 7.073337145 | 3.517214 .1370103 25.67 0.000 3.248679 3.785749146 | 4.522656 .1263708 35.79 0.000 4.274973 4.770338147 | 1.072126 .0816017 13.14 0.000 .9121892 1.232062148 | 2.508443 .0916688 27.36 0.000 2.328775 2.688111149 | 3.521796 .1114386 31.60 0.000 3.30338 3.740212150 | 6.649632 .1679852 39.58 0.000 6.320387 6.978877151 | 3.967771 .1234352 32.14 0.000 3.725843 4.2097152 | 4.27045 .1181887 36.13 0.000 4.038804 4.502095153 | .8320431 .0803719 10.35 0.000 .674517 .9895691154 | 4.301483 .1631274 26.37 0.000 3.98176 4.621207155 | 6.806626 .1743368 39.04 0.000 6.464933 7.14832156 | .9802655 .0775853 12.63 0.000 .8282012 1.13233157 | 2.582528 .1103783 23.40 0.000 2.36619 2.798865158 | 4.879265 .1531446 31.86 0.000 4.579108 5.179423159 | 3.421049 .0912784 37.48 0.000 3.242147 3.599952160 | 3.063307 .1023132 29.94 0.000 2.862777 3.263837161 | -5.023061 .0770874 -65.16 0.000 -5.174149 -4.871972162 | .7912129 .0830179 9.53 0.000 .6285008 .9539249163 | 2.166236 .095473 22.69 0.000 1.979112 2.353359381 | 1.086367 .092106 11.79 0.000 .9058431 1.266892941 | 4.744214 .1287061 36.86 0.000 4.491955 4.9964735001 | 3.396086 .163299 20.80 0.000 3.076026 3.716146|_cons | .5175747 .1167511 4.43 0.000 .2887467 .7464028-------------------+----------------------------------------------------------------sigma_u | 0sigma_e | .22471475rho | 0 (fraction of variance due to u_i)------------------------------------------------------------------------------------
. import excel "G:\Stock Estimation Study\OriginalData\StockAlPanel1992_2010_PanelData.xls", sheet("Sheet1") firstrow case(upper) clear
. sort ZONE_CODE YEAR
. xtset ZONE_CODE YEARpanel variable: ZONE_CODE (strongly balanced)time variable: YEAR, 1992 to 2010delta: 1 unit
xtunitroot llc LOG_LIGHT_PER_AREALevin-Lin-Chu unit-root test for LOG_LIGHT_PER_AREA---------------------------------------------------Ho: Panels contain unit roots Number of panels = 134Ha: Panels are stationary Number of periods = 19AR parameter: Common Asymptotics: N/T -> 0Panel means: IncludedTime trend: Not includedADF regressions: 1 lagLR variance: Bartlett kernel, 8.00 lags average (chosen by LLC)------------------------------------------------------------------------------Statistic p-value------------------------------------------------------------------------------Unadjusted t -34.4696Adjusted t* -11.0321 0.0000------------------------------------------------------------------------------
对LOG_STOCK_PER_AREA做单位根检验
xtunitroot llc LOG_STOCK_PER_AREALevin-Lin-Chu unit-root test for LOG_STOCK_PER_AREA---------------------------------------------------Ho: Panels contain unit roots Number of panels = 134Ha: Panels are stationary Number of periods = 19AR parameter: Common Asymptotics: N/T -> 0Panel means: IncludedTime trend: Not includedADF regressions: 1 lagLR variance: Bartlett kernel, 8.00 lags average (chosen by LLC)------------------------------------------------------------------------------Statistic p-value------------------------------------------------------------------------------Unadjusted t -7.7739Adjusted t* -4.0039 0.0000------------------------------------------------------------------------------
xtwest LOG_LIGHT_PER_AREA LOG_STOCK_PER_AREA,lags(0)Calculating Westerlund ECM panel cointegration tests..........Results for H0: no cointegrationWith 134 series and 1 covariate-----------------------------------------------+Statistic | Value | Z-value | P-value |-----------+-----------+-----------+-----------|Gt | -2.106 | -12.571 | 0.000 |Ga | -4.779 | -2.486 | 0.007 |Pt | -14.891 | -7.695 | 0.000 |Pa | -1.831 | -3.215 | 0.001 |-----------------------------------------------+
xtreg LOG_STOCK_PER_AREA LOG_LIGHT_PER_AREA i.YEAR i.ZONE_CODERandom-effects GLS regression Number of obs = 2,546Group variable: ZONE_CODE Number of groups = 134R-sq: Obs per group:within = 0.6252 min = 19between = 1.0000 avg = 19.0overall = 0.9870 max = 19Wald chi2(152) = 181548.42corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0000------------------------------------------------------------------------------------LOG_STOCK_PER_AREA | Coef. Std. Err. z P>|z| [95% Conf. Interval]-------------------+----------------------------------------------------------------LOG_LIGHT_PER_AREA | .4967024 .0352008 14.11 0.000 .4277101 .5656947|YEAR |1993 | -.1376636 .0412057 -3.34 0.001 -.2184253 -.05690181994 | -.1277133 .0420884 -3.03 0.002 -.2102051 -.04522161995 | -.0856746 .0423222 -2.02 0.043 -.1686246 -.00272461996 | -.0481264 .0430046 -1.12 0.263 -.1324139 .03616121997 | -.0381711 .0446225 -0.86 0.392 -.1256296 .04928741998 | .0221525 .0446225 0.50 0.620 -.065306 .10961091999 | .0376566 .0461891 0.82 0.415 -.0528724 .12818552000 | .1055052 .0465131 2.27 0.023 .0143412 .19666912001 | .1671173 .0466763 3.58 0.000 .0756335 .25860112002 | .2273004 .046836 4.85 0.000 .1355036 .31909732003 | .301138 .0470275 6.40 0.000 .2089658 .39331012004 | .3865336 .047311 8.17 0.000 .2938056 .47926152005 | .4734065 .047368 9.99 0.000 .3805668 .56624622006 | .5577219 .0475142 11.74 0.000 .4645958 .6508482007 | .6365256 .0477151 13.34 0.000 .5430057 .73004552008 | .6578842 .0505639 13.01 0.000 .5587808 .75698762009 | .8050588 .0471359 17.08 0.000 .7126741 .89744342010 | .8533531 .0476851 17.90 0.000 .759892 .9468141|ZONE_CODE |2 | 2.300265 .1301693 17.67 0.000 2.045138 2.5553923 | .6996974 .141536 4.94 0.000 .4222918 .97710294 | -.1182053 .104615 -1.13 0.259 -.3232468 .08683635 | 1.331926 .1510511 8.82 0.000 1.035871 1.6279816 | 1.91986 .1256395 15.28 0.000 1.673611 2.1661097 | 4.191452 .1929966 21.72 0.000 3.813186 4.5697188 | 6.47415 .3005606 21.54 0.000 5.885062 7.0632389 | 2.16209 .1628286 13.28 0.000 1.842952 2.48122910 | 3.565006 .2829445 12.60 0.000 3.010445 4.11956711 | 7.264813 .2524387 28.78 0.000 6.770042 7.75958412 | 1.543092 .136109 11.34 0.000 1.276323 1.80986113 | 1.15604 .1115186 10.37 0.000 .9374675 1.37461214 | 5.473913 .2936114 18.64 0.000 4.898445 6.0493815 | -.0140418 .1216168 -0.12 0.908 -.2524062 .224322716 | 1.320605 .149621 8.83 0.000 1.027353 1.61385717 | 1.56315 .1598371 9.78 0.000 1.249875 1.87642518 | .4156022 .1088395 3.82 0.000 .2022807 .628923719 | .585068 .1232997 4.75 0.000 .3434049 .82673120 | .824957 .1058127 7.80 0.000 .617568 1.03234621 | 3.097178 .1078813 28.71 0.000 2.885734 3.30862122 | 1.396844 .1672177 8.35 0.000 1.069104 1.72458523 | -.3979266 .1177813 -3.38 0.001 -.6287738 -.167079424 | -1.594112 .1281451 -12.44 0.000 -1.845271 -1.34295225 | 1.453808 .148476 9.79 0.000 1.162801 1.74481626 | 2.791853 .1560551 17.89 0.000 2.485991 3.09771527 | 1.093584 .1541436 7.09 0.000 .7914683 1.395728 | -1.108998 .1044472 -10.62 0.000 -1.313711 -.904285229 | 1.729227 .1941298 8.91 0.000 1.34874 2.10971530 | 1.179077 .1614885 7.30 0.000 .8625653 1.49558931 | 3.890955 .2368609 16.43 0.000 3.426716 4.35519432 | 3.306763 .2113095 15.65 0.000 2.892604 3.72092233 | 3.654609 .2206818 16.56 0.000 3.22208 4.08713734 | 1.341353 .1207571 11.11 0.000 1.104674 1.57803335 | 6.40959 .1453948 44.08 0.000 6.124622 6.69455936 | 1.245136 .1673123 7.44 0.000 .9172102 1.57306237 | 1.660801 .1814241 9.15 0.000 1.305216 2.01638538 | 1.780654 .2043594 8.71 0.000 1.380117 2.18119139 | .5206395 .1051969 4.95 0.000 .3144573 .726821740 | 2.444963 .1140077 21.45 0.000 2.221512 2.66841441 | 1.410516 .2075824 6.79 0.000 1.003662 1.8173742 | 3.497855 .2220278 15.75 0.000 3.062689 3.93302243 | 3.558843 .1581234 22.51 0.000 3.248927 3.86875944 | .2187951 .137684 1.59 0.112 -.0510607 .488650845 | 1.80429 .123921 14.56 0.000 1.561409 2.04717146 | 4.460873 .2279286 19.57 0.000 4.014141 4.90760547 | 3.238609 .1411461 22.95 0.000 2.961968 3.5152548 | 3.259897 .1921943 16.96 0.000 2.883203 3.63659149 | -.1998663 .1759664 -1.14 0.256 -.5447541 .145021550 | 3.660494 .1981053 18.48 0.000 3.272215 4.04877351 | 2.0033 .1647454 12.16 0.000 1.680405 2.32619552 | 1.054697 .1043223 10.11 0.000 .850229 1.25916553 | .9428581 .113113 8.34 0.000 .7211607 1.16455654 | .4676633 .1043408 4.48 0.000 .2631591 .672167655 | .6150387 .1441725 4.27 0.000 .3324658 .897611756 | 1.256051 .1565858 8.02 0.000 .9491489 1.56295457 | 3.236195 .1935761 16.72 0.000 2.856793 3.61559758 | 2.249977 .1504517 14.95 0.000 1.955098 2.54485759 | 2.052467 .1676533 12.24 0.000 1.723873 2.38106260 | 1.04444 .149992 6.96 0.000 .750461 1.33841961 | 1.249202 .1800987 6.94 0.000 .8962149 1.60218962 | .5622257 .1794833 3.13 0.002 .2104448 .914006663 | 3.201224 .1910876 16.75 0.000 2.826699 3.57574864 | 2.775933 .2661479 10.43 0.000 2.254292 3.29757365 | 3.784509 .2413144 15.68 0.000 3.311541 4.25747666 | 2.362703 .2266162 10.43 0.000 1.918543 2.80686267 | 4.568686 .2530176 18.06 0.000 4.07278 5.06459168 | 1.924941 .1834215 10.49 0.000 1.565442 2.28444169 | .7265016 .1114203 6.52 0.000 .5081218 .944881370 | 3.044998 .2609396 11.67 0.000 2.533566 3.5564371 | 2.693553 .2532398 10.64 0.000 2.197212 3.18989472 | .3191895 .1425997 2.24 0.025 .0396992 .598679873 | .6334667 .1066786 5.94 0.000 .4243804 .842552974 | .1633809 .1230388 1.33 0.184 -.0777707 .404532475 | 2.6013 .1842372 14.12 0.000 2.240201 2.96239876 | -.3197695 .1079176 -2.96 0.003 -.531284 -.108254977 | 4.620965 .3050961 15.15 0.000 4.022987 5.21894278 | -.8317163 .1096008 -7.59 0.000 -1.04653 -.616902779 | 3.123629 .2266999 13.78 0.000 2.679306 3.56795380 | 2.095324 .186791 11.22 0.000 1.729221 2.46142881 | -2.087541 .1071576 -19.48 0.000 -2.297566 -1.87751682 | 1.51643 .1531193 9.90 0.000 1.216322 1.81653883 | .6669855 .1043404 6.39 0.000 .4624821 .871488984 | -.0652 .1105457 -0.59 0.555 -.2818655 .151465585 | 4.742631 .2706513 17.52 0.000 4.212164 5.27309886 | 2.537122 .1603648 15.82 0.000 2.222813 2.85143187 | .8368688 .1403403 5.96 0.000 .5618069 1.11193188 | -.8111559 .110862 -7.32 0.000 -1.028441 -.593870589 | .7640657 .18101 4.22 0.000 .4092926 1.11883990 | 2.730666 .1927785 14.16 0.000 2.352827 3.10850591 | 1.132778 .1711189 6.62 0.000 .7973913 1.46816592 | .6458884 .1664382 3.88 0.000 .3196754 .972101393 | 3.660565 .1666806 21.96 0.000 3.333877 3.98725394 | .5560154 .1060401 5.24 0.000 .3481807 .763850295 | .6958225 .1360361 5.11 0.000 .4291966 .962448496 | .4770109 .1281854 3.72 0.000 .2257721 .728249897 | 2.558254 .1617586 15.82 0.000 2.241213 2.87529598 | 2.096113 .1972702 10.63 0.000 1.70947 2.48275599 | 3.168947 .2189452 14.47 0.000 2.739823 3.598072100 | 2.688654 .249697 10.77 0.000 2.199256 3.178051101 | 3.423951 .2505569 13.67 0.000 2.932868 3.915033102 | 3.369782 .1562485 21.57 0.000 3.063541 3.676024103 | .8659715 .1268647 6.83 0.000 .6173212 1.114622105 | 1.556168 .1759929 8.84 0.000 1.211229 1.901108106 | 1.389406 .1157683 12.00 0.000 1.162504 1.616307107 | 3.953373 .1750422 22.59 0.000 3.610296 4.296449108 | 1.145161 .1128373 10.15 0.000 .9240043 1.366318109 | 7.333696 .3143753 23.33 0.000 6.717531 7.94986110 | 2.875152 .2159401 13.31 0.000 2.451917 3.298387111 | 2.019048 .1640385 12.31 0.000 1.697539 2.340558112 | -.2271002 .1079585 -2.10 0.035 -.438695 -.0155053113 | 3.102279 .1130031 27.45 0.000 2.880797 3.323761114 | 2.108461 .1999507 10.54 0.000 1.716565 2.500357115 | 4.482104 .2303422 19.46 0.000 4.030642 4.933566116 | 1.237476 .1962667 6.31 0.000 .8528004 1.622152117 | 2.528206 .1802975 14.02 0.000 2.17483 2.881583118 | 1.403679 .1264567 11.10 0.000 1.155829 1.65153119 | 3.125466 .1571575 19.89 0.000 2.817443 3.433489120 | 3.08893 .2444303 12.64 0.000 2.609856 3.568005121 | 1.337379 .1757508 7.61 0.000 .9929134 1.681844122 | 2.073989 .1677618 12.36 0.000 1.745182 2.402796123 | .5024512 .1090208 4.61 0.000 .2887743 .7161281124 | 3.420222 .2365685 14.46 0.000 2.956557 3.883888125 | 3.679835 .2527963 14.56 0.000 3.184363 4.175306126 | .5229901 .104912 4.99 0.000 .3173663 .7286138127 | 1.026081 .1556909 6.59 0.000 .7209326 1.33123128 | 3.116239 .2208024 14.11 0.000 2.683474 3.549003129 | 1.626305 .1253306 12.98 0.000 1.380662 1.871948130 | 1.970717 .1757151 11.22 0.000 1.626322 2.315112131 | 1.545423 .1445243 10.69 0.000 1.262161 1.828686132 | .4637183 .1296621 3.58 0.000 .2095852 .7178514133 | -.7467869 .1130544 -6.61 0.000 -.9683695 -.5252042134 | -.2241033 .1323862 -1.69 0.090 -.4835756 .0353689281 | -.4309239 .1271347 -3.39 0.001 -.6801034 -.1817445|_cons | -1.738724 .1681374 -10.34 0.000 -2.068267 -1.409181-------------------+----------------------------------------------------------------sigma_u | 0sigma_e | .32154135rho | 0 (fraction of variance due to u_i)------------------------------------------------------------------------------------
import excel "G:\Stock Estimation Study\OriginalData\StockCementPanel1992_2009_PanelData.xls", sheet("Sheet1") firstrow case(upper) clearsort ZONE_CODE YEARxtset ZONE_CODE YEARxtunitroot llc LOG_LIGHT_PER_AREAxtunitroot llc LOG_STOCK_PER_AREAxtwest LOG_LIGHT_PER_AREA LOG_STOCK_PER_AREA,lags(0)xtreg LOG_STOCK_PER_AREA LOG_LIGHT_PER_AREA i.YEAR i.ZONE_CODE
panel variable: ZONE_CODE (strongly balanced)time variable: YEAR, 1992 to 2009delta: 1 unit
Levin-Lin-Chu unit-root test for LOG_LIGHT_PER_AREA---------------------------------------------------Ho: Panels contain unit roots Number of panels = 130Ha: Panels are stationary Number of periods = 18AR parameter: Common Asymptotics: N/T -> 0Panel means: IncludedTime trend: Not includedADF regressions: 1 lagLR variance: Bartlett kernel, 8.00 lags average (chosen by LLC)------------------------------------------------------------------------------Statistic p-value------------------------------------------------------------------------------Unadjusted t -34.2507Adjusted t* -11.1249 0.0000------------------------------------------------------------------------------
Levin-Lin-Chu unit-root test for LOG_STOCK_PER_AREA---------------------------------------------------Ho: Panels contain unit roots Number of panels = 130Ha: Panels are stationary Number of periods = 18AR parameter: Common Asymptotics: N/T -> 0Panel means: IncludedTime trend: Not includedADF regressions: 1 lagLR variance: Bartlett kernel, 8.00 lags average (chosen by LLC)------------------------------------------------------------------------------Statistic p-value------------------------------------------------------------------------------Unadjusted t -29.0366Adjusted t* -27.1178 0.0000------------------------------------------------------------------------------
Calculating Westerlund ECM panel cointegration tests..........Results for H0: no cointegrationWith 130 series and 1 covariate-----------------------------------------------+Statistic | Value | Z-value | P-value |-----------+-----------+-----------+-----------|Gt | -4.819 | -42.116 | 0.000 |Ga | -6.439 | -6.610 | 0.000 |Pt | -18.619 | -10.965 | 0.000 |Pa | -1.136 | -0.431 | 0.333 |-----------------------------------------------+
Random-effects GLS regression Number of obs = 2,340Group variable: ZONE_CODE Number of groups = 130R-sq: Obs per group:within = 0.7006 min = 18between = 1.0000 avg = 18.0overall = 0.9950 max = 18Wald chi2(147) = 433124.98corr(u_i, X) = 0 (assumed) Prob > chi2 = 0.0000------------------------------------------------------------------------------------LOG_STOCK_PER_AREA | Coef. Std. Err. z P>|z| [95% Conf. Interval]-------------------+----------------------------------------------------------------LOG_LIGHT_PER_AREA | .2572369 .0239095 10.76 0.000 .2103752 .3040985|YEAR |1993 | -.0349763 .0235014 -1.49 0.137 -.0810382 .01108561994 | -.0027345 .0241403 -0.11 0.910 -.0500486 .04457961995 | .0429506 .0245467 1.75 0.080 -.0051602 .09106131996 | .0915199 .0249319 3.67 0.000 .0426542 .14038551997 | .1176174 .0262147 4.49 0.000 .0662374 .16899731998 | .1618852 .0265197 6.10 0.000 .1099076 .21386291999 | .1894191 .0274593 6.90 0.000 .1355998 .24323832000 | .2337395 .0277205 8.43 0.000 .1794083 .28807062001 | .2783026 .0278902 9.98 0.000 .2236389 .33296642002 | .3307467 .0280187 11.80 0.000 .2758311 .38566222003 | .3793606 .0281606 13.47 0.000 .3241668 .43455452004 | .4239872 .0283193 14.97 0.000 .3684823 .4794922005 | .4710886 .0284051 16.58 0.000 .4154156 .52676172006 | .5188752 .0285413 18.18 0.000 .4629352 .57481532007 | .5676707 .0286394 19.82 0.000 .5115385 .6238032008 | .5888491 .0303681 19.39 0.000 .5293287 .64836952009 | .6693938 .0282444 23.70 0.000 .6140358 .7247518|ZONE_CODE |2 | 4.282183 .0797159 53.72 0.000 4.125943 4.4384233 | 1.94545 .0887662 21.92 0.000 1.771472 2.1194294 | .5856171 .0599723 9.76 0.000 .4680736 .70316065 | 1.741708 .0956988 18.20 0.000 1.554142 1.9292746 | 1.050263 .0768078 13.67 0.000 .8997226 1.2008047 | 4.79434 .1260345 38.04 0.000 4.547317 5.0413638 | 3.46519 .1244282 27.85 0.000 3.221315 3.7090649 | 5.927268 .201226 29.46 0.000 5.532872 6.32166310 | 2.98396 .1044 28.58 0.000 2.77934 3.1885811 | 5.179584 .1890382 27.40 0.000 4.809076 5.55009212 | 8.213857 .1677698 48.96 0.000 7.885034 8.5426813 | 2.312518 .0656906 35.20 0.000 2.183767 2.44126914 | .387865 .0736773 5.26 0.000 .2434601 .5322715 | 1.900984 .0946341 20.09 0.000 1.715504 2.08646316 | 3.446506 .1577659 21.85 0.000 3.137291 3.75572217 | 4.436054 .1022123 43.40 0.000 4.235721 4.63638618 | .19107 .0634991 3.01 0.003 .066614 .315526119 | 1.135005 .0609476 18.62 0.000 1.01555 1.2544620 | 1.64243 .0627792 26.16 0.000 1.519385 1.76547521 | .8356742 .107593 7.77 0.000 .6247958 1.04655322 | 2.869151 .0963517 29.78 0.000 2.680305 3.05799723 | 2.082363 .0938209 22.20 0.000 1.898478 2.26624924 | 3.907224 .0990986 39.43 0.000 3.712994 4.10145325 | 7.664064 .203156 37.73 0.000 7.265885 8.06224226 | 2.298123 .0979653 23.46 0.000 2.106114 2.49013227 | -1.917655 .0598611 -32.04 0.000 -2.03498 -1.80032928 | 2.76512 .1268315 21.80 0.000 2.516534 3.01370529 | 2.154223 .0770121 27.97 0.000 2.003282 2.30516430 | 3.762492 .1032399 36.44 0.000 3.560146 3.96483931 | 4.63368 .1568179 29.55 0.000 4.326322 4.94103732 | 5.175049 .1390722 37.21 0.000 4.902473 5.44762633 | 5.722437 .0632678 90.45 0.000 5.598434 5.8464434 | 4.318651 .1456081 29.66 0.000 4.033264 4.60403735 | 8.301379 .0917481 90.48 0.000 8.121556 8.48120236 | 2.583308 .107519 24.03 0.000 2.372575 2.79404237 | 3.045585 .1174756 25.93 0.000 2.815337 3.27583338 | 3.648246 .134042 27.22 0.000 3.385529 3.91096339 | -.8578167 .0607016 -14.13 0.000 -.9767897 -.738843840 | .4989412 .0603522 8.27 0.000 .3806531 .617229341 | 2.703335 .0678186 39.86 0.000 2.570413 2.83625742 | 2.245515 .1362354 16.48 0.000 1.978499 2.51253243 | 4.240982 .1465113 28.95 0.000 3.953825 4.52813944 | .8302445 .0682521 12.16 0.000 .6964727 .964016245 | .5738984 .0858137 6.69 0.000 .4057067 .742090146 | 5.191137 .1506935 34.45 0.000 4.895783 5.4864947 | 2.454385 .0884057 27.76 0.000 2.281113 2.62765748 | 4.452405 .125341 35.52 0.000 4.206741 4.69806949 | 4.918006 .1685379 29.18 0.000 4.587677 5.24833450 | 2.84824 .105681 26.95 0.000 2.641109 3.05537151 | 3.329596 .0906856 36.72 0.000 3.151856 3.50733752 | 2.199378 .0997698 22.04 0.000 2.003833 2.39492453 | 4.310985 .1264152 34.10 0.000 4.063216 4.55875554 | 3.241103 .1077979 30.07 0.000 3.029823 3.45238355 | 2.478128 .0949659 26.09 0.000 2.291998 2.66425756 | 2.503743 .1167196 21.45 0.000 2.274976 2.73250957 | 2.912058 .1163065 25.04 0.000 2.684101 3.14001458 | 3.851945 .1245878 30.92 0.000 3.607758 4.09613359 | 4.805406 .177285 27.11 0.000 4.457933 5.15287860 | 5.030377 .1600142 31.44 0.000 4.716755 5.34461 | 3.920764 .149758 26.18 0.000 3.627244 4.21428462 | 5.288167 .1682187 31.44 0.000 4.958464 5.61786963 | 3.325056 .1190724 27.92 0.000 3.091678 3.55843464 | 1.75364 .0656391 26.72 0.000 1.62499 1.88229165 | 4.737692 .1735656 27.30 0.000 4.39751 5.07787466 | -.4012046 .0601536 -6.67 0.000 -.5191034 -.283305767 | 5.213593 .1680364 31.03 0.000 4.884247 5.54293868 | 1.570662 .0894799 17.55 0.000 1.395284 1.74603969 | .3491957 .0614544 5.68 0.000 .2287474 .46964470 | 1.444729 .0747212 19.33 0.000 1.298278 1.5911871 | 3.268095 .1195735 27.33 0.000 3.033735 3.50245472 | -.6417088 .0624598 -10.27 0.000 -.7641277 -.519289873 | -3.605793 .2043368 -17.65 0.000 -4.006286 -3.205374 | 5.133648 .1783965 28.78 0.000 4.783998 5.48329975 | -.5837445 .0637604 -9.16 0.000 -.7087126 -.458776476 | 2.730907 .1215596 22.47 0.000 2.492654 2.96915977 | -.2915631 .0618103 -4.72 0.000 -.4127091 -.170417278 | 3.193356 .0972315 32.84 0.000 3.002786 3.38392779 | .8423072 .059742 14.10 0.000 .725215 .959399380 | .7435771 .0648649 11.46 0.000 .6164443 .8707181 | 1.228716 .0670196 18.33 0.000 1.09736 1.36007282 | 5.028852 .1804855 27.86 0.000 4.675107 5.38259783 | 2.310247 .0849667 27.19 0.000 2.143716 2.47677984 | 2.152337 .1026471 20.97 0.000 1.951152 2.35352285 | 1.699849 .0878273 19.35 0.000 1.52771 1.87198786 | -1.130911 .0646699 -17.49 0.000 -1.257661 -1.0041687 | 1.886116 .1176016 16.04 0.000 1.655621 2.11661188 | 2.370552 .1256631 18.86 0.000 2.124257 2.61684789 | 1.230701 .1737814 7.08 0.000 .8900951 1.57130690 | 1.636742 .1102079 14.85 0.000 1.420738 1.85274591 | 2.641874 .1069574 24.70 0.000 2.432241 2.85150792 | 2.560558 .1071074 23.91 0.000 2.350631 2.77048493 | .6633536 .0845451 7.85 0.000 .4976482 .829059194 | 1.808844 .078637 23.00 0.000 1.654719 1.9629795 | 3.718753 .1035047 35.93 0.000 3.515887 3.92161896 | 4.418986 .129129 34.22 0.000 4.165898 4.67207597 | 4.450651 .1441547 30.87 0.000 4.168113 4.73318998 | 3.862363 .1656961 23.31 0.000 3.537605 4.18712299 | 5.401631 .1663529 32.47 0.000 5.075585 5.727677100 | 4.749053 .1440143 32.98 0.000 4.46679 5.031316101 | 4.617091 .0995017 46.40 0.000 4.422071 4.812111102 | 1.079607 .0777437 13.89 0.000 .9272322 1.231982103 | 2.281182 .1138371 20.04 0.000 2.058066 2.504299104 | 2.336475 .0690534 33.84 0.000 2.201133 2.471817105 | 1.3661 .0662177 20.63 0.000 1.236316 1.495885106 | 8.070455 .210793 38.29 0.000 7.657309 8.483602107 | 4.187725 .142174 29.45 0.000 3.909069 4.466381108 | 3.40983 .1052135 32.41 0.000 3.203615 3.616045109 | -.0353922 .0627956 -0.56 0.573 -.1584694 .0876849110 | .5140059 .0668564 7.69 0.000 .3829697 .6450421111 | 2.62866 .1309329 20.08 0.000 2.372036 2.885284112 | 5.097678 .1523227 33.47 0.000 4.79913 5.396225113 | 3.274063 .1283466 25.51 0.000 3.022508 3.525617114 | 3.627989 .1168589 31.05 0.000 3.39895 3.857028115 | 2.684202 .077403 34.68 0.000 2.532495 2.835909116 | 4.293332 .1618171 26.53 0.000 3.976176 4.610487117 | 3.355423 .1136014 29.54 0.000 3.132768 3.578077118 | 3.794912 .1078463 35.19 0.000 3.583537 4.006287119 | 1.126048 .0636908 17.68 0.000 1.001217 1.25088120 | 3.614804 .1565256 23.09 0.000 3.308019 3.921588121 | 4.486115 .1680819 26.69 0.000 4.15668 4.815549122 | .7304956 .0602682 12.12 0.000 .6123721 .8486191123 | 2.242902 .0990943 22.63 0.000 2.048681 2.437123124 | 2.706077 .1456678 18.58 0.000 2.420573 2.991581125 | 2.261344 .1136209 19.90 0.000 2.038651 2.484037126 | 3.397116 .0904545 37.56 0.000 3.219829 3.574404127 | 1.443201 .0795639 18.14 0.000 1.287259 1.599144128 | .5659604 .0669454 8.45 0.000 .4347498 .697171129 | 1.754179 .0818851 21.42 0.000 1.593688 1.914671271 | 1.589332 .0779088 20.40 0.000 1.436634 1.74203|_cons | 2.559204 .1106698 23.12 0.000 2.342295 2.776113-------------------+----------------------------------------------------------------sigma_u | 0sigma_e | .17915011rho | 0 (fraction of variance due to u_i)------------------------------------------------------------------------------------