------log: K:\Malwi_to_Mauritious.log
opened on: 25 Jul 2006, 20:23:24
. *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 open english gdpdfration
> ew white whitemg, stat(n mean sd median min max) col(stat)
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" countries)--RHS Variables
> :
. by white: tabstat rimp immig gdp gdpau gdpdefnew gdpdfau pop popau xrate1 remote dist phone open eng
> lish 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 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 lremote 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) = 7942.48
Log likelihood = -546.7605 Prob > chi2 = 0.0000
------
lrimp | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3826804 .030633 12.49 0.000 .3226409 .4427199
lgdp | 1.188193 .0343259 34.62 0.000 1.120916 1.255471
lgdpau | .0335796 .6135048 0.05 0.956 -1.168868 1.236027
lgdpdfrati~w | -.8634942 .2532129 -3.41 0.001 -1.359782 -.3672061
lpopau | -1.910891 2.113751 -0.90 0.366 -6.053768 2.231985
lpop | .0053601 .0404159 0.13 0.894 -.0738536 .0845738
lxrate1 | -.1266581 .0138097 -9.17 0.000 -.1537245 -.0995916
lremote | -.4739252 .0672843 -7.04 0.000 -.6058 -.3420503
ldist | -2.059254 .120926 -17.03 0.000 -2.296264 -1.822243
lopen | .2196662 .055586 3.95 0.000 .1107196 .3286127
english | .9367272 .130031 7.20 0.000 .6818712 1.191583
white | 5.401316 .5073292 10.65 0.000 4.406969 6.395663
lwhitemg | -.5070422 .0453408 -11.18 0.000 -.5959086 -.4181758
_cons | 32.8094 19.53362 1.68 0.093 -5.475794 71.09459
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1 lremote ldist
------+------
limmig | .000938
lgdp | -.000366 .001178
lgdpau | -.00088 .001326 .376388
lgdpdfrati~w | -.000631 -.000056 -.008275 .064117
lpopau | .00202 -.008213 -1.27067 .047643 4.46794
lpop | -.000177 -.000828 -.000144 .000135 .001634 .001633
lxrate1 | .000048 .000145 .000179 .000265 -.001339 -.000174 .000191
lremote | .000422 .00019 -.00016 -.001518 -.004237 -.00034 .000046 .004527
ldist | .001111 .000569 -.001531 -.000306 .000885 -.000881 .000896 .004087 .014623
lopen | -.000216 .000587 .002231 .000194 -.016396 .00025 .000061 .001247 -.000275
english | -.001346 .002719 .002375 .001922 -.008523 -.001263 .000546 -.003061 .002758
white | .004568 -.002778 .003402 -.010531 -.024646 .004534 .000215 -.001131 -.005966
lwhitemg | -.000551 .000272 -.00025 .001003 .002334 -.000322 -.000023 .000109 .000439
_cons | -.019604 .080781 11.2059 -.622094 -40.6649 -.016348 .006619 -.001404 -.159062
| lopen english white lwhitemg _cons
------+------
lopen | .00309
english | -.000903 .016908
white | .000036 -.004686 .257383
lwhitemg | -.000055 .000684 -.022698 .002056
_cons | .190995 .032286 .346936 -.034877 381.562
.
. **II. Conservative Estimates
. *2.1. Aggregate reference priced Imports (conservative)
. xtgls lrrefp_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 lremote ldist lopen eng
> lish 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) = 75445.76
Log likelihood = -977.3962 Prob > chi2 = 0.0000
------
lrrefp_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0575009 .0144647 3.98 0.000 .0291506 .0858513
lgdp | 1.573871 .0527336 29.85 0.000 1.470515 1.677227
lgdpau | .8481897 .3646637 2.33 0.020 .1334619 1.562917
lgdpdfrati~w | -.4647737 .1523992 -3.05 0.002 -.7634707 -.1660767
lpopau | -6.232307 1.232537 -5.06 0.000 -8.648036 -3.816578
lpop | -.3007694 .0876815 -3.43 0.001 -.472622 -.1289169
lxrate1 | -.1228172 .0207458 -5.92 0.000 -.1634782 -.0821563
lremote | -.971778 .1050135 -9.25 0.000 -1.177601 -.7659554
ldist | -3.301896 .1667536 -19.80 0.000 -3.628727 -2.975065
lopen | -.0519383 .0272603 -1.91 0.057 -.1053676 .001491
english | .9975588 .0828705 12.04 0.000 .8351356 1.159982
white | 4.957138 .7915805 6.26 0.000 3.405669 6.508607
lwhitemg | -.4861131 .0750662 -6.48 0.000 -.6332402 -.338986
_cons | 94.87431 11.62468 8.16 0.000 72.09036 117.6583
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1 lremote ldist
------+------
limmig | .000209
lgdp | -.00026 .002781
lgdpau | -.001298 .002065 .13298
lgdpdfrati~w | -.000602 .00056 -.012149 .023226
lpopau | .005079 -.008205 -.440349 .024823 1.51915
lpop | .000144 -.004393 -.001804 .000484 .005301 .007688
lxrate1 | -.000025 .000317 .000017 .000376 -.00339 -.000367 .00043
lremote | .000368 -.000045 -.00718 -.00387 .025758 -.000694 .000026 .011028
ldist | .000593 -.00139 -.007002 -.001786 .018013 .002123 .000576 .005522 .027807
lopen | .000043 -.000137 -.001025 .000941 .003756 .000325 -.000079 .000711 .000264
english | -.00044 .000354 .003344 .002613 -.021451 .000254 .001161 -.002751 .00182
white | .001035 -.01439 -.011538 -.004446 .047286 .022294 -.001496 .009274 -.027292
lwhitemg | -.000098 .000748 .000421 .000162 -.00282 -.001074 .000172 .000169 .003873
_cons | -.055769 .101199 3.94526 -.082152 -13.9834 -.075662 .04687 -.375388 -.438789
| lopen english white lwhitemg _cons
------+------
lopen | .000743
english | -.000411 .006868
white | .002094 -.003217 .6266
lwhitemg | -.000142 .000481 -.057531 .005635
_cons | -.046827 .257658 -.315735 -.003933 135.133
.
.
. *2.2. Aggregate Differentiated Imports (conservative)
. xtgls lrdiff_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 lremote ldist lopen eng
> lish 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) = 7062.32
Log likelihood = -941.4916 Prob > chi2 = 0.0000
------
lrdiff_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .1185834 .0237037 5.00 0.000 .072125 .1650418
lgdp | 1.716555 .0703079 24.41 0.000 1.578754 1.854356
lgdpau | .1342987 .5404752 0.25 0.804 -.9250133 1.193611
lgdpdfrati~w | -.5243933 .2243971 -2.34 0.019 -.9642034 -.0845831
lpopau | -3.217505 1.886923 -1.71 0.088 -6.915807 .4807968
lpop | -.5817501 .0824239 -7.06 0.000 -.743298 -.4202022
lxrate1 | -.1592446 .0270829 -5.88 0.000 -.2123262 -.1061631
lremote | -.3744028 .1290687 -2.90 0.004 -.6273728 -.1214327
ldist | -3.997333 .3400662 -11.75 0.000 -4.663851 -3.330815
lopen | .0688279 .0440823 1.56 0.118 -.0175717 .1552275
english | 1.081773 .1451502 7.45 0.000 .7972842 1.366262
white | 10.04009 1.934732 5.19 0.000 6.248088 13.8321
lwhitemg | -.8623213 .1934896 -4.46 0.000 -1.241554 -.4830888
_cons | 65.98251 18.02022 3.66 0.000 30.66353 101.3015
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1 lremote ldist
------+------
limmig | .000562
lgdp | -.000889 .004943
lgdpau | -.001616 .003023 .292113
lgdpdfrati~w | -.000892 .002507 -.016254 .050354
lpopau | .004556 -.017112 -.986569 .05833 3.56048
lpop | .000631 -.004164 -.000818 -.002554 .00154 .006794
lxrate1 | .00003 .000472 -.000177 .001058 -.004555 -.000754 .000733
lremote | -.000027 -.00047 -.006783 -.000813 .019684 -.000883 .000102 .016659
ldist | .002513 .007131 -.011156 -.00141 -.012067 -.001029 .001417 .00783 .115645
lopen | .000108 -.000698 .000569 .002083 -.00201 .00122 -.00025 .000537 -.000954
english | -.000972 .002743 .005284 .00053 -.042437 .002359 .001761 -.004529 .005356
white | .001395 -.029334 .01109 -.006033 -.038808 .025695 .003736 .011979 -.137063
lwhitemg | -.000119 .001536 -.002055 .000082 .008924 -.001667 -.000392 .000747 .010712
_cons | -.04847 .09671 8.83949 -.58603 -32.9657 .001281 .062858 -.34558 -.838534
| lopen english white lwhitemg _cons
------+------
lopen | .001943
english | -.001489 .021069
white | .003213 .020461 3.74319
lwhitemg | -.000185 -.002567 -.367094 .037438
_cons | .01893 .44823 1.77795 -.208785 324.728
.
. *2.3. Aggregate Homogenous Imports (conservative)
. xtgls lrhomo_cm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 lremote ldist lopen eng
> lish 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) = 2550.82
Log likelihood = -1111.071 Prob > chi2 = 0.0000
------
lrhomo_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0965954 .0384769 2.51 0.012 .0211821 .1720087
lgdp | .9639273 .0773117 12.47 0.000 .8123992 1.115455
lgdpau | -.8692936 .8661526 -1.00 0.316 -2.566922 .8283343
lgdpdfrati~w | -.3289434 .3536589 -0.93 0.352 -1.022102 .3642153
lpopau | 1.611164 2.953755 0.55 0.585 -4.178089 7.400416
lpop | -.0212572 .092608 -0.23 0.818 -.2027655 .160251
lxrate1 | -.1270856 .0331001 -3.84 0.000 -.1919606 -.0622107
lremote | .5193001 .2378635 2.18 0.029 .0530962 .9855039
ldist | -1.47633 .3199316 -4.61 0.000 -2.103385 -.8492758
lopen | .3410673 .0761747 4.48 0.000 .1917676 .4903669
english | 1.495237 .227776 6.56 0.000 1.048804 1.941669
white | 1.384074 2.229472 0.62 0.535 -2.985611 5.753759
lwhitemg | .216699 .1947469 1.11 0.266 -.1649978 .5983958
_cons | -13.08223 27.89481 -0.47 0.639 -67.75505 41.5906
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1 lremote ldist
------+------
limmig | .00148
lgdp | -.001407 .005977
lgdpau | -.002272 .001451 .75022
lgdpdfrati~w | -.000517 .002221 -.023273 .125075
lpopau | .004591 -.009653 -2.50481 .062421 8.72467
lpop | .000384 -.005186 -.00077 -.001989 .003246 .008576
lxrate1 | .000119 .00085 .000277 .002507 -.00738 -.001164 .001096
lremote | .001454 .000168 -.031028 -.016192 .097329 .001766 -.00089 .056579
ldist | .003838 -.006926 -.021735 -.008002 .06527 .011102 -.000203 .022503 .102356
lopen | .000264 -.001108 .002829 .002082 -.017481 .002904 -.000169 .002366 -.000811
english | -.003005 .000648 .00934 .006728 -.022175 -.001825 .001705 -.012808 .013122
white | .003221 -.021006 .078105 -.001967 -.313865 .012901 .000622 .053082 -.038173
lwhitemg | -.000412 .000607 -.008347 -.001241 .034635 .000484 -.000189 -.001969 .007859
_cons | -.046055 .13777 22.3616 -.355944 -80.4369 -.169937 .117205 -1.52652 -1.72351
| lopen english white lwhitemg _cons
------+------
lopen | .005803
english | -.00212 .051882
white | .00769 .032487 4.97055
lwhitemg | -.000452 -.001949 -.423574 .037926
_cons | .183261 .111493 3.30399 -.431953 778.121
.
. **III. Liberal Estimates
. *3.1. Aggregate reference priced Imports (liberal)
. xtgls lrrefp_lm limmig lgdp lgdpau lgdpdfrationew lpopau lpop lxrate1 lremote ldist lopen eng
> lish 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) = 58445.90
Log likelihood = -913.1142 Prob > chi2 = 0.0000
------
lrrefp_lm | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .0235559 .0135941 1.73 0.083 -.0030881 .0501999
lgdp | 1.597821 .0533953 29.92 0.000 1.493168 1.702473
lgdpau | .7400323 .355227 2.08 0.037 .0438003 1.436264
lgdpdfrati~w | -.3005107 .1401673 -2.14 0.032 -.5752337 -.0257878
lpopau | -6.818185 1.202408 -5.67 0.000 -9.174861 -4.461509
lpop | -.2474236 .093314 -2.65 0.008 -.4303156 -.0645316
lxrate1 | -.0474696 .0191081 -2.48 0.013 -.0849207 -.0100185
lremote | -.6344704 .1510846 -4.20 0.000 -.9305908 -.3383501
ldist | -2.615393 .1667306 -15.69 0.000 -2.942179 -2.288607