------
log: K:\Exports\Malawi to Mauritious.log
opened on: 1 Aug 2006, 22:15:39
. *Dropping Malawi
. drop if ccode==164540
(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 491103.5 1561212 7681.5 0 1.39e+07
immig | 1000 33457.95 117039.7 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.9183 16.68945 103.0725 64.27792 207.3465
gdpdfau | 1000 100.7173 4.633489 100.8223 94.42464 109.9797
pop | 1000 4.95e+07 1.54e+08 1.04e+07 41000 1.26e+09
popau | 1000 1.82e+07 612793.8 1.82e+07 1.73e+07 1.92e+07
xrate1 | 1000 1043.015 10901.72 16.0586 .0068 270182.6
remote | 1000 6706.441 4134.082 6764 1293 39620
dist | 1000 13391.13 3525.827 14305 2409 17972
open | 1000 .706737 .3895353 .63155 .0671 3.2192
english | 1000 .37 .4830459 0 0 1
gdpdfratio~w | 1000 1.054711 .1791895 1.019883 .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 404838.7 1597603 3126 0 1.39e+07
immig | 870 14892.29 27127.62 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 105.0786 17.03182 101.7941 64.27792 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 1182.874 11681.75 22.864 .0068 270182.6
remote | 870 7127.895 4106.347 6927 1293 39620
dist | 870 13224.75 3415.364 14051 2410 17972
phone | 870 159.3154 241.8485 49.865 .54 1449.75
open | 870 .7139293 .4110394 .6248 .0671 3.2192
english | 870 .3793103 .4854945 0 0 1
gdpdfratio~w | 870 1.046603 .1839615 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 Exports
. tsset ccode year
panel variable: ccode, 117100 to 725980
time variable: year, 1991 to 2000
.
. **I. Aggregate Exorts
. xtgls lrexp 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) = 6832.56
Log likelihood = -996.4144 Prob > chi2 = 0.0000
------
lrexp | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .5501081 .0356942 15.41 0.000 .4801487 .6200675
lgdp | 1.037469 .035647 29.10 0.000 .9676018 1.107335
lgdpau | -3.357424 .8912642 -3.77 0.000 -5.10427 -1.610578
lgdpdfrati~w | -1.800557 .3479223 -5.18 0.000 -2.482472 -1.118642
lpopau | 5.141204 3.109309 1.65 0.098 -.9529301 11.23534
lpop | .0048991 .0408363 0.12 0.905 -.0751386 .0849368
lxrate1 | -.0089494 .015216 -0.59 0.556 -.0387723 .0208734
lremote | .0790608 .0934145 0.85 0.397 -.1040283 .2621499
ldist | -1.532103 .158634 -9.66 0.000 -1.84302 -1.221186
lopen | .8647532 .0846035 10.22 0.000 .6989333 1.030573
english | .2263817 .0958821 2.36 0.018 .0384563 .4143072
white | 3.209618 .5620507 5.71 0.000 2.108019 4.311218
lwhitemg | -.3939528 .0502965 -7.83 0.000 -.4925321 -.2953735
_cons | -.569841 28.93292 -0.02 0.984 -57.27731 56.13763
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .001274
lgdp | -.000657 .001271
lgdpau | -.002886 .002513 .794352
lgdpdfrati~w | .000757 -.000953 -.028075 .12105
lpopau | .011205 -.010849 -2.72413 .152876 9.6678
lpop | .000087 -.000743 .000442 -.000249 -.004026 .001668
lxrate1 | .000032 .000164 -.000136 .000095 .000147 -.000042 .000232
lremote | -.000285 .001179 .004602 -.00367 -.026939 -.000212 .000067
ldist | .003289 -.001655 -.005791 .002747 .012343 .001568 .000824
lopen | -.000553 .000387 .011741 -.002396 -.063809 .000645 -.000098
english | -.000728 .00143 -.003086 .001378 .019342 -.00074 .000457
white | .007001 -.001261 -.011565 -.011136 .028184 .008849 .002069
lwhitemg | -.000776 .000141 .001209 .000614 -.003217 -.000775 -.000187
_cons | -.136674 .106645 24.3657 -1.90453 -88.823 .032947 -.011824
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .008726
ldist | .003394 .025165
lopen | .002709 .000827 .007158
english | -.000026 .000792 -.003371 .009193
white | .015867 .029987 -.003518 .006488 .315901
lwhitemg | -.000993 -.003031 .000323 -.000333 -.027743 .00253
_cons | .200472 -.338618 .71494 -.273965 -.773189 .076202 837.114
.
. **II. Conservative Estimates
. *2.1. Aggregate reference priced Imports (conservative)
. xtgls lrrefp_cx 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) = 6754.13
Log likelihood = -1433.078 Prob > chi2 = 0.0000
------
lrrefp_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3366194 .0460722 7.31 0.000 .2463195 .4269192
lgdp | 1.064962 .0664031 16.04 0.000 .9348144 1.19511
lgdpau | -.1973744 .5405384 -0.37 0.715 -1.25681 .8620614
lgdpdfrati~w | -.3069625 .3060897 -1.00 0.316 -.9068873 .2929623
lpopau | 2.38964 1.938027 1.23 0.218 -1.408823 6.188102
lpop | .0761789 .0918676 0.83 0.407 -.1038783 .256236
lxrate1 | -.0385914 .0304945 -1.27 0.206 -.0983596 .0211768
lremote | -.2904563 .1689403 -1.72 0.086 -.6215731 .0406605
ldist | -3.167127 .3846466 -8.23 0.000 -3.921021 -2.413234
lopen | -.067304 .056336 -1.19 0.232 -.1777206 .0431125
english | .6431623 .1796528 3.58 0.000 .2910493 .9952753
white | 7.942285 1.060148 7.49 0.000 5.864434 10.02014
lwhitemg | -.8579659 .1128081 -7.61 0.000 -1.079066 -.6368662
_cons | -24.17763 19.34117 -1.25 0.211 -62.08563 13.73038
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .002123
lgdp | -.00159 .004409
lgdpau | .001233 -.001059 .292182
lgdpdfrati~w | -.001802 .003078 -.026609 .093691
lpopau | -.006148 .003317 -1.00995 .118268 3.75595
lpop | -.00012 -.004563 .002988 -.001336 -.017422 .00844
lxrate1 | .000152 .000377 .000748 .002591 -.006949 -.00055 .00093
lremote | .000118 .000194 -.022111 .003134 .092961 -.003395 .000589
ldist | .009083 -.010505 .004484 .002339 -.036077 .005334 .002247
lopen | .000038 -.000149 .002364 .001256 -.011558 .001032 -.000348
english | -.001125 -.001195 .005804 .004006 -.043069 .00284 .001594
white | .010883 -.024531 .020751 -.002753 -.151249 .030034 .001961
lwhitemg | -.001564 .001914 -.004571 .000486 .023398 -.001909 -.000171
_cons | .010028 .04731 9.23799 -1.45967 -36.1627 .163982 .062438
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .028541
ldist | .003095 .147953
lopen | -.001683 .000989 .003174
english | -.005047 .000104 -.000783 .032275
white | -.011508 .057417 .002266 .037198 1.12391
lwhitemg | .004198 -.007194 -.000546 -.001678 -.11438 .012726
_cons | -1.20077 -.862649 .124028 .570844 1.52022 -.241135 374.081
.
.
. *2.2. Aggregate Differentiated Imports (conservative)
. xtgls lrdiff_cx 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) = 3441.37
Log likelihood = -1542.725 Prob > chi2 = 0.0000
------
lrdiff_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .4595461 .0536841 8.56 0.000 .3543271 .564765
lgdp | 1.075047 .0634971 16.93 0.000 .9505955 1.199499
lgdpau | 2.393937 2.03313 1.18 0.239 -1.590925 6.3788
lgdpdfrati~w | -2.269648 .8199738 -2.77 0.006 -3.876767 -.6625286
lpopau | -8.73517 6.999696 -1.25 0.212 -22.45432 4.983982
lpop | -.1574836 .0799101 -1.97 0.049 -.3141046 -.0008626
lxrate1 | -.0705904 .0278517 -2.53 0.011 -.1251787 -.016002
lremote | .0471325 .1994951 0.24 0.813 -.3438706 .4381356
ldist | -2.247118 .2349029 -9.57 0.000 -2.707519 -1.786716
lopen | .0990483 .091552 1.08 0.279 -.0803904 .278487
english | .7123686 .1822486 3.91 0.000 .3551678 1.069569
white | 2.750378 1.152975 2.39 0.017 .4905883 5.010167
lwhitemg | -.2655313 .1043033 -2.55 0.011 -.469962 -.0611007
_cons | 85.86347 64.42368 1.33 0.183 -40.40462 212.1316
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .002882
lgdp | -.002006 .004032
lgdpau | -.002761 .005587 4.13362
lgdpdfrati~w | -.003518 .001614 -.203372 .672357
lpopau | .009298 -.027435 -14.0185 .954523 48.9957
lpop | .000241 -.003446 -.000911 .00117 .00619 .006386
lxrate1 | .000191 .000483 .000838 -.000439 -.006903 -.000836 .000776
lremote | .004102 -.002419 .002975 -.007658 -.030588 -.000277 .000935
ldist | .006509 -.006074 -.006827 .011558 .016565 .002943 .002768
lopen | -.000388 .000745 .015059 .002846 -.077939 .0012 -.000127
english | -.003048 .002239 -.000168 .010327 .010776 -.003079 .001249
white | .020064 -.019157 .039574 -.126186 -.181396 .00979 .002616
lwhitemg | -.001803 .001248 -.003336 .010777 .015002 -.00018 -.000165
_cons | -.153792 .359516 124.277 -11.2878 -445.647 -.126094 .05641
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .039798
ldist | .021456 .055179
lopen | .004179 .000737 .008382
english | -.014253 .002914 -.003378 .033215
white | .078735 .030987 -.002576 -.014621 1.32935
lwhitemg | -.004645 -.000604 .000379 .001345 -.116947 .010879
_cons | -.077916 -.779963 .826424 -.088199 1.24302 -.13814 4150.41
.
. *2.3. Aggregate Homogenous Imports (conservative)
. xtgls lrhomo_cx 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) = 1223.60
Log likelihood = -1638.99 Prob > chi2 = 0.0000
------
lrhomo_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .624133 .0644632 9.68 0.000 .4977875 .7504786
lgdp | .6522372 .1080363 6.04 0.000 .44049 .8639844
lgdpau | 1.127563 1.777504 0.63 0.526 -2.356281 4.611407
lgdpdfrati~w | -.0997531 .6509429 -0.15 0.878 -1.375578 1.176072
lpopau | -9.899042 6.09028 -1.63 0.104 -21.83577 2.037686
lpop | .1717048 .1088738 1.58 0.115 -.041684 .3850936
lxrate1 | .0667734 .0439191 1.52 0.128 -.0193065 .1528533
lremote | -1.002906 .3044625 -3.29 0.001 -1.599641 -.4061703
ldist | -.9656682 .5861944 -1.65 0.099 -2.114588 .1832518
lopen | .2342242 .1113739 2.10 0.035 .0159353 .452513
english | .3630958 .3197873 1.14 0.256 -.2636758 .9898674
white | 12.56839 2.900066 4.33 0.000 6.884368 18.25242
lwhitemg | -1.431809 .2975573 -4.81 0.000 -2.015011 -.8486074
_cons | 136.5171 56.93015 2.40 0.016 24.9361 248.0982
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .004156
lgdp | -.004627 .011672
lgdpau | .002407 -.003873 3.15952
lgdpdfrati~w | -.006834 .012946 -.086876 .423727
lpopau | -.014455 .001776 -10.5632 .452199 37.0915
lpop | .000707 -.006566 -.00138 -.003209 .006055 .011854
lxrate1 | -.000126 .001464 .003326 .003856 -.025146 -.001458 .001929
lremote | .001936 .007119 -.05216 .007028 .143509 -.006213 -.00029
ldist | .021378 -.016609 -.00759 -.011376 -.070229 .012426 .001956
lopen | -.000998 .001209 -.016793 .004414 .029439 .001674 .000317
english | -.004536 .005812 .023353 .016428 -.107076 .00517 .004225
white | .016961 -.038395 .157701 -.031833 -.728308 .039263 .003081
lwhitemg | -.001721 .002625 -.018962 .002187 .086198 -.003153 -.000311
_cons | .033752 .017974 93.0199 -5.84108 -339.34 -.163997 .2944
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .092697
ldist | .049575 .343624
lopen | .002851 -.00425 .012404
english | -.024699 -.000711 -.001999 .102264
white | .001114 .016443 -.006085 .117792 8.41038
lwhitemg | .00411 -.003109 .000694 -.012967 -.851294 .08854
_cons | -2.36027 -2.27514 -.075251 1.14606 7.9278 -.938495 3241.04
.
. **III. Liberal Estimates
. *3.1. Aggregate reference priced Imports (liberal)
. xtgls lrrefp_lx 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) = 1975.93
Log likelihood = -1477.865 Prob > chi2 = 0.0000
------
lrrefp_lx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3117521 .0472362 6.60 0.000 .219171 .4043333
lgdp | 1.055993 .0862522 12.24 0.000 .8869416 1.225044
lgdpau | .1494403 .5514849 0.27 0.786 -.9314501 1.230331
lgdpdfrati~w | -.3131954 .3187099 -0.98 0.326 -.9378552 .3114645
lpopau | -3.953996 1.952945 -2.02 0.043 -7.781697 -.126295
lpop | .0472832 .099195 0.48 0.634 -.1471354 .2417017
lxrate1 | .0192069 .0319255 0.60 0.547 -.0433659 .0817796