------
log: K:\Niger to Bulgaria.log
opened on: 26 Jul 2006, 08:41:08
. *Dropping Niger
. drop if ccode==555780
(10 observations deleted)
.
. *Descriptive stats after dropping
. tabstat rimp immig gdp gdpau gdpdefnew gdpdfau pop popau xrate1 remote dist op
> en english gdpdfrationew white whitemg, stat(n mean sd median min max) col(sta
> t)
variable | N mean sd p50 min max
------+------
rimp | 1000 491197.8 1561183 8397.5 0 1.39e+07
immig | 1000 33461.93 117038.6 2986.5 0 1137050
gdp | 1000 2.79e+11 9.69e+11 1.74e+10 1.92e+08 8.99e+12
gdpau | 1000 3.83e+11 4.44e+10 3.80e+11 3.19e+11 4.52e+11
gdpdefnew | 1000 105.7122 16.89225 102.7439 60.87417 207.3465
gdpdfau | 1000 100.7173 4.633489 100.8223 94.42464 109.9797
pop | 1000 4.95e+07 1.54e+08 1.03e+07 41000 1.26e+09
popau | 1000 1.82e+07 612793.8 1.82e+07 1.73e+07 1.92e+07
xrate1 | 1000 1039.919 10901.96 13.89535 .0068 270182.6
remote | 1000 6740.898 4146.003 6797 1293 39620
dist | 1000 13344.79 3523.681 14215 2409 17972
open | 1000 .7111417 .3888718 .63975 .0671 3.2192
english | 1000 .38 .4856293 0 0 1
gdpdfratio~w | 1000 1.052663 .1811292 1.016437 .5844526 2.009028
white | 1000 .13 .3364717 0 0 1
whitemg | 1000 20501.65 116468.1 0 0 1137050
------
. sort white
. *IIIB. Descriptives Original Unites(sub sample for "white" and "non-white" cou
> ntries)--RHS Variables:
. by white: tabstat rimp immig gdp gdpau gdpdefnew gdpdfau pop popau xrate1 remo
> te dist phone open english gdpdfrationew white whitemg, stat(n mean sd median
> min max) col(stat)
------
-> white = 0
variable | N mean sd p50 min max
------+------
rimp | 870 404947.1 1597577 3443.5 0 1.39e+07
immig | 870 14896.87 27125.13 1606 0 158613
gdp | 870 2.37e+11 1.00e+12 1.09e+10 1.92e+08 8.99e+12
gdpau | 870 3.83e+11 4.44e+10 3.80e+11 3.19e+11 4.52e+11
gdpdefnew | 870 104.8417 17.24838 101.6928 60.87417 207.3465
gdpdfau | 870 100.7173 4.633836 100.8223 94.42464 109.9797
pop | 870 5.34e+07 1.65e+08 1.07e+07 41000 1.26e+09
popau | 870 1.82e+07 612839.6 1.82e+07 1.73e+07 1.92e+07
xrate1 | 870 1179.316 11682.05 19.96485 .0068 270182.6
remote | 870 7167.501 4116.058 6955 1293 39620
dist | 870 13171.48 3410.162 14040 2410 17972
phone | 870 159.3505 241.8258 49.865 .54 1449.75
open | 870 .7189922 .4102235 .63975 .0671 3.2192
english | 870 .3908046 .4882114 0 0 1
gdpdfratio~w | 870 1.044249 .1860279 1 .5844526 2.009028
white | 870 0 0 0 0 0
whitemg | 870 0 0 0 0 0
------
------
-> white = 1
variable | N mean sd p50 min max
------+------
rimp | 130 1068414 1138347 522863.5 40432 3843839
immig | 130 157705 288518.8 21174 2612 1137050
gdp | 130 5.56e+11 6.58e+11 2.54e+11 5.15e+10 2.69e+12
gdpau | 130 3.83e+11 4.46e+10 3.80e+11 3.19e+11 4.52e+11
gdpdefnew | 130 111.5379 12.89742 112.2247 85.45601 143.9587
gdpdfau | 130 100.7173 4.649088 100.8223 94.42464 109.9797
pop | 130 2.34e+07 2.55e+07 8837000 3477200 8.22e+07
popau | 130 1.82e+07 614856.7 1.82e+07 1.73e+07 1.92e+07
xrate1 | 130 107.0323 293.6987 4.4722 .3774 1261.556
remote | 130 3885.938 3089.96 2888 1530 12501
dist | 130 14504.62 4031.974 15931 2409 17493
phone | 130 734.716 269.9717 652.085 343.99 1487.08
open | 130 .6586038 .1850905 .64065 .3517 1.2967
english | 130 .3076923 .4633239 0 0 1
gdpdfratio~w | 130 1.108974 .1314272 1.116445 .8254872 1.441221
white | 130 1 0 1 1 1
whitemg | 130 157705 288518.8 21174 2612 1137050
------
.
.
. **Regression of Imports
. tsset ccode year
panel variable: ccode, 117100 to 725980
time variable: year, 1991 to 2000
.
. **I. Aggregate Imports
. xtgls lrimp limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 lremo
> te ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 9030.29
Log likelihood = -540.9534 Prob > chi2 = 0.0000
------
lrimp | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3649105 .0316957 11.51 0.000 .3027881 .4270329
lgdp | 1.166822 .032934 35.43 0.000 1.102273 1.231372
lgdpau | .1818235 .604774 0.30 0.764 -1.003512 1.367159
lgdpdfrati~w | -.8588204 .2457598 -3.49 0.000 -1.340501 -.3771399
lpopau | -2.733228 2.086929 -1.31 0.190 -6.823534 1.357078
lpop | .0368264 .0405008 0.91 0.363 -.0425537 .1162065
lxrate1 | -.1252294 .0158164 -7.92 0.000 -.156229 -.0942298
lremote | -.404775 .0739685 -5.47 0.000 -.5497506 -.2597993
ldist | -2.008106 .1530261 -13.12 0.000 -2.308032 -1.70818
lopen | .2692365 .0551238 4.88 0.000 .1611959 .3772771
english | .8238461 .1267525 6.50 0.000 .5754157 1.072276
white | 4.799107 .5688808 8.44 0.000 3.684121 5.914093
lwhitemg | -.4503562 .0505796 -8.90 0.000 -.5494904 -.3512219
_cons | 41.77766 19.20605 2.18 0.030 4.134487 79.42084
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .001005
lgdp | -.000321 .001085
lgdpau | -.000782 .001328 .365752
lgdpdfrati~w | -.00073 .000105 -.009452 .060398
lpopau | .001478 -.007907 -1.23714 .050073 4.35527
lpop | -.000145 -.000721 .000121 .000171 -.000333 .00164
lxrate1 | .000099 .000154 .000385 .000209 -.002689 -.000097 .00025
lremote | .000478 .00008 -.000235 -.001656 -.004034 -.000243 .000074
ldist | .001801 .000956 .00117 -.00105 -.017161 -.000102 .001502
lopen | -.000217 .00062 .002445 .00068 -.016607 .000358 .000184
english | -.001194 .002737 .002565 .002026 -.00956 -.001273 .000567
white | .004961 -.002168 .003711 -.010356 -.02813 .005047 .000623
lwhitemg | -.000606 .000201 -.000354 .000961 .00305 -.000399 -.000082
_cons | -.022536 .072969 10.8998 -.622699 -39.4768 -.001953 .015813
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .005471
ldist | .004713 .023417
lopen | .001373 .001227 .003039
english | -.003167 .002958 -.000767 .016066
white | -.000039 .001629 -.000524 -.00009 .323625
lwhitemg | .0001 -.000671 -.000022 .000182 -.028323 .002558
_cons | -.016284 -.045608 .170129 .042483 .283013 -.029393 368.873
.
. **II. Conservative Estimates
. *2.1. Aggregate reference priced Imports (conservative)
. xtgls lrrefp_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 74729.67
Log likelihood = -985.5831 Prob > chi2 = 0.0000
------
lrrefp_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0582184 .0149658 3.89 0.000 .028886 .0875507
lgdp | 1.594521 .0510986 31.20 0.000 1.49437 1.694672
lgdpau | .8713179 .3676431 2.37 0.018 .1507507 1.591885
lgdpdfrati~w | -.4431585 .1514469 -2.93 0.003 -.739989 -.146328
lpopau | -6.339121 1.24248 -5.10 0.000 -8.774338 -3.903905
lpop | -.3350918 .0844264 -3.97 0.000 -.5005645 -.1696192
lxrate1 | -.1181052 .0205593 -5.74 0.000 -.1584005 -.0778098
lremote | -.9620887 .0955384 -10.07 0.000 -1.14934 -.7748369
ldist | -3.236077 .1600811 -20.22 0.000 -3.54983 -2.922324
lopen | -.0520336 .0273501 -1.90 0.057 -.1056389 .0015717
english | .9952622 .085043 11.70 0.000 .828581 1.161943
white | 4.83495 .7571271 6.39 0.000 3.351008 6.318892
lwhitemg | -.4775173 .0721117 -6.62 0.000 -.6188537 -.3361809
_cons | 95.34411 11.67549 8.17 0.000 72.46057 118.2277
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .000224
lgdp | -.000287 .002611
lgdpau | -.001399 .00195 .135161
lgdpdfrati~w | -.000642 .000559 -.012211 .022936
lpopau | .005452 -.007883 -.447504 .02521 1.54376
lpop | .000161 -.004067 -.00151 .000501 .004353 .007128
lxrate1 | -.000026 .000292 -9.3e-06 .000373 -.00327 -.000325 .000423
lremote | .000495 .000277 -.006963 -.003239 .02463 -.001249 .000087
ldist | .000721 -.001441 -.006911 -.001567 .018009 .002094 .000575
lopen | .000051 -.000104 -.001036 .000969 .003781 .000266 -.000074
english | -.000479 .000328 .003526 .002588 -.02176 .000282 .001135
white | .001239 -.012689 -.011045 -.003832 .044185 .019295 -.00111
lwhitemg | -.000102 .000677 .000485 .0002 -.002942 -.000942 .00015
_cons | -.061364 .095503 4.00242 -.094466 -14.1887 -.061321 .044984
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .009128
ldist | .004293 .025626
lopen | .000643 .000253 .000748
english | -.002764 .00189 -.000418 .007232
white | .006493 -.024303 .001813 -.002641 .573241
lwhitemg | .000046 .003362 -.000136 .000462 -.053114 .0052
_cons | -.333463 -.408085 -.046124 .257752 -.276232 .002068 136.317
.
.
. *2.2. Aggregate Differentiated Imports (conservative)
. xtgls lrdiff_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 7817.30
Log likelihood = -946.2316 Prob > chi2 = 0.0000
------
lrdiff_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3116007 .0369106 8.44 0.000 .2392573 .383944
lgdp | 1.429126 .0790872 18.07 0.000 1.274118 1.584134
lgdpau | -.1488859 .6305292 -0.24 0.813 -1.3847 1.086929
lgdpdfrati~w | -.0713815 .2700888 -0.26 0.792 -.6007459 .4579828
lpopau | -1.418053 2.214661 -0.64 0.522 -5.758709 2.922603
lpop | -.3690959 .0859176 -4.30 0.000 -.5374913 -.2007006
lxrate1 | -.1293343 .0285115 -4.54 0.000 -.1852157 -.0734529
lremote | -.4133575 .1295049 -3.19 0.001 -.6671824 -.1595326
ldist | -2.94538 .3539497 -8.32 0.000 -3.639109 -2.251651
lopen | .1064417 .0512916 2.08 0.038 .005912 .2069713
english | .8024782 .1614115 4.97 0.000 .4861175 1.118839
white | 10.48395 1.823331 5.75 0.000 6.910284 14.05761
lwhitemg | -.9121933 .1815078 -5.03 0.000 -1.267942 -.5564445
_cons | 35.44035 21.10795 1.68 0.093 -5.930475 76.81117
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .001362
lgdp | -.001955 .006255
lgdpau | -.001885 .003898 .397567
lgdpdfrati~w | -.001269 .003034 -.025806 .072948
lpopau | .004812 -.020051 -1.35448 .105835 4.90472
lpop | .00108 -.004965 -.00162 -.002155 .007632 .007382
lxrate1 | .000151 .000279 6.0e-06 .001165 -.005087 -.000608 .000813
lremote | .000063 -.00043 -.004396 -.001035 .008157 -.001409 .000179
ldist | .006209 .001068 -.010346 -.002555 -.018359 .000353 .001959
lopen | .00018 -.000696 .001692 .001518 -.009404 .001275 -.000255
english | -.002246 .004597 .004031 .004084 -.024042 .000775 .001787
white | .001468 -.030289 .012123 -.001623 -.002583 .026438 .0044
lwhitemg | -.000093 .001759 -.002089 -.000407 .00491 -.001838 -.000428
_cons | -.068711 .167769 12.1534 -1.15325 -45.5514 -.080743 .062033
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .016772
ldist | .010039 .12528
lopen | .000547 -.000446 .002631
english | -.005978 -.005478 -.002116 .026054
white | .00859 -.152715 .002112 .025365 3.32454
lwhitemg | .001063 .01316 -.000128 -.00301 -.324625 .032945
_cons | -.23141 -.768312 .107485 .273926 1.32577 -.16858 445.546
.
. *2.3. Aggregate Homogenous Imports (conservative)
. xtgls lrhomo_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 2170.66
Log likelihood = -1123.16 Prob > chi2 = 0.0000
------
lrhomo_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0993298 .0448751 2.21 0.027 .0113763 .1872833
lgdp | .9157678 .0834862 10.97 0.000 .7521378 1.079398
lgdpau | -.5043768 .8555158 -0.59 0.555 -2.181157 1.172403
lgdpdfrati~w | -.41538 .3609798 -1.15 0.250 -1.122887 .2921275
lpopau | .2859366 2.93664 0.10 0.922 -5.469772 6.041645
lpop | .0780902 .1033035 0.76 0.450 -.124381 .2805614
lxrate1 | -.1296385 .0338859 -3.83 0.000 -.1960536 -.0632234
lremote | .5395527 .234841 2.30 0.022 .0792729 .9998325
ldist | -1.579601 .3444501 -4.59 0.000 -2.254711 -.9044914
lopen | .353485 .0829373 4.26 0.000 .1909309 .516039
english | 1.66153 .2463779 6.74 0.000 1.178638 2.144421
white | 1.839005 2.206123 0.83 0.405 -2.484916 6.162926
lwhitemg | .1595268 .1937977 0.82 0.410 -.2203097 .5393634
_cons | -.222422 27.95085 -0.01 0.994 -55.00507 54.56023
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .002014
lgdp | -.00186 .00697
lgdpau | -.001537 .001171 .731907
lgdpdfrati~w | -.000149 .001689 -.012426 .130306
lpopau | .002702 -.008953 -2.45322 .046747 8.62385
lpop | .000312 -.00619 .000145 -.001558 -.001558 .010672
lxrate1 | .000139 .000891 .000598 .002205 -.007867 -.001168 .001148
lremote | .001606 .000537 -.028015 -.015044 .086022 .000392 -.000741
ldist | .004938 -.008045 -.020019 -.006223 .064101 .011778 -.000096
lopen | .000323 -.001118 .005287 .001659 -.029954 .002927 -.0002
english | -.004239 .001775 .009352 .005972 -.016952 -.001019 .001455
white | .004252 -.024958 .109221 .00457 -.440572 .021506 .000729
lwhitemg | -.000607 .000962 -.011418 -.001908 .047212 -.000177 -.000208
_cons | -.037323 .13656 21.9227 -.410692 -79.9388 -.118886 .113627
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .05515
ldist | .021857 .118646
lopen | .002145 -.00114 .006879
english | -.015271 .011966 -.002087 .060702
white | .040179 -.030646 .007113 .036717 4.86698
lwhitemg | -.000728 .006796 -.000444 -.002527 -.416529 .037558
_cons | -1.38844 -1.89257 .331881 .025254 4.57384 -.556848 781.25
.
. **III. Liberal Estimates
. *3.1. Aggregate reference priced Imports (liberal)
. xtgls lrrefp_lm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 l
> remote ldist lopen english white lwhitemg, igls panels(hetero)corr(psar1)nolog
Cross-sectional time-series FGLS regression
Coefficients: generalized least squares
Panels: heteroskedastic
Correlation: panel-specific AR(1)
Estimated covariances = 100 Number of obs = 1000
Estimated autocorrelations = 100 Number of groups = 100
Estimated coefficients = 14 Time periods = 10
Wald chi2(13) = 61392.84
Log likelihood = -920.1466 Prob > chi2 = 0.0000
------
lrrefp_lm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0366404 .0155759 2.35 0.019 .0061122 .0671686
lgdp | 1.538742 .054436 28.27 0.000 1.43205 1.645435
lgdpau | .6655148 .3822783 1.74 0.082 -.0837369 1.414767
lgdpdfrati~w | -.2505326 .1407965 -1.78 0.075 -.5264887 .0254234
lpopau | -6.630431 1.293787 -5.12 0.000 -9.166208 -4.094655
lpop | -.1476627 .0927381 -1.59 0.111 -.3294261 .0341006
lxrate1 | -.0406605 .0187786 -2.17 0.030 -.0774658 -.0038551