------
log: K:\Exports\Canada to Congo Rep.log
opened on: 1 Aug 2006, 21:34:34
. *Dropping Canada
. drop if ccode==141200
(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 482156.7 1561309 7348 0 1.39e+07
immig | 1000 33204.61 117083.5 2790 0 1137050
gdp | 1000 2.73e+11 9.69e+11 1.63e+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.7483 16.93397 103.0148 60.87417 207.3465
gdpdfau | 1000 100.7173 4.633489 100.8223 94.42464 109.9797
pop | 1000 4.93e+07 1.54e+08 1.02e+07 41000 1.26e+09
popau | 1000 1.82e+07 612793.8 1.82e+07 1.73e+07 1.92e+07
xrate1 | 1000 1043.105 10901.71 16.2185 .0068 270182.6
remote | 1000 6755.779 4142.208 6797 1293 39620
dist | 1000 13341.35 3521.065 14215 2409 17972
open | 1000 .7079635 .3898348 .63385 .0671 3.2192
english | 1000 .37 .4830459 0 0 1
gdpdfratio~w | 1000 1.052994 .1813893 1.019483 .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 394555 1597152 2944.5 0 1.39e+07
immig | 870 14601.1 27145.22 1403.5 0 158613
gdp | 870 2.30e+11 1.00e+12 1.00e+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.8832 17.29743 101.7714 60.87417 207.3465
gdpdfau | 870 100.7173 4.633836 100.8223 94.42464 109.9797
pop | 870 5.32e+07 1.65e+08 1.03e+07 41000 1.26e+09
popau | 870 1.82e+07 612839.6 1.82e+07 1.73e+07 1.92e+07
xrate1 | 870 1182.978 11681.74 22.9426 .0068 270182.6
remote | 870 7184.606 4109.882 6955 1293 39620
dist | 870 13167.53 3406.852 14040 2410 17972
phone | 870 150.8965 233.8471 47.025 .54 1449.75
open | 870 .7153391 .4113407 .62865 .0671 3.2192
english | 870 .3793103 .4854945 0 0 1
gdpdfratio~w | 870 1.04463 .1863362 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 Exports
. 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) = 7052.70
Log likelihood = -1027.131 Prob > chi2 = 0.0000
------
lrexp | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .5385323 .0380084 14.17 0.000 .4640373 .6130274
lgdp | 1.07914 .043759 24.66 0.000 .9933741 1.164906
lgdpau | -3.216116 .8965918 -3.59 0.000 -4.973404 -1.458829
lgdpdfrati~w | -1.941123 .3423663 -5.67 0.000 -2.612148 -1.270097
lpopau | 3.854106 3.125613 1.23 0.218 -2.271984 9.980196
lpop | -.0142543 .0438824 -0.32 0.745 -.1002622 .0717536
lxrate1 | .006056 .014973 0.40 0.686 -.0232905 .0354026
lremote | .1595015 .084188 1.89 0.058 -.005504 .324507
ldist | -1.30507 .1628289 -8.01 0.000 -1.624209 -.9859313
lopen | .8994445 .0786478 11.44 0.000 .7452976 1.053591
english | .2721618 .1224736 2.22 0.026 .0321179 .5122057
white | 3.274089 .5715638 5.73 0.000 2.153845 4.394334
lwhitemg | -.4008253 .052073 -7.70 0.000 -.5028866 -.2987641
_cons | 13.82227 28.93618 0.48 0.633 -42.8916 70.53614
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .001445
lgdp | -.000807 .001915
lgdpau | -.003022 .003088 .803877
lgdpdfrati~w | .000669 -.001864 -.024869 .117215
lpopau | .011515 -.013724 -2.75887 .140271 9.76946
lpop | .000066 -.001043 .000531 .000384 -.00474 .001926
lxrate1 | 1.1e-06 .000241 .000066 -.000114 -.000697 -.0001 .000224
lremote | -.000328 .001769 .004871 -.002938 -.026893 -.000249 .000134
ldist | .003536 -.000272 -.003158 .000785 -.00055 .000926 .000662
lopen | -.000545 .000409 .010591 -.001268 -.057301 .000878 -.000054
english | -.000713 .003266 -.000834 -.002287 .006259 -.002083 .000663
white | .007281 -.000424 -.005415 -.010564 -.005435 .008897 .001727
lwhitemg | -.000812 .000026 .00058 .000791 .000404 -.000757 -.000152
_cons | -.13737 .111625 24.6453 -1.74858 -89.3704 .052284 -.002611
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .007088
ldist | .00427 .026513
lopen | .002286 .001198 .006185
english | .002037 .007389 -.002711 .015
white | .015815 .037482 -.000229 .006627 .326685
lwhitemg | -.001283 -.003982 -.000017 -.000594 -.029348 .002712
_cons | .183622 -.238352 .630385 -.216391 -.465429 .046342 837.302
.
. **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) = 5500.83
Log likelihood = -1429 Prob > chi2 = 0.0000
------
lrrefp_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3397519 .0461008 7.37 0.000 .2493961 .4301077
lgdp | 1.125382 .067654 16.63 0.000 .9927823 1.257981
lgdpau | -.132084 .5719358 -0.23 0.817 -1.253058 .9888895
lgdpdfrati~w | -.2713505 .3072131 -0.88 0.377 -.8734771 .330776
lpopau | 2.3083 2.040295 1.13 0.258 -1.690606 6.307205
lpop | .0074873 .0924808 0.08 0.935 -.1737717 .1887464
lxrate1 | -.0438294 .0302792 -1.45 0.148 -.1031755 .0155168
lremote | -.3838417 .170083 -2.26 0.024 -.7171983 -.0504852
ldist | -3.112935 .377518 -8.25 0.000 -3.852856 -2.373013
lopen | -.0550053 .0588723 -0.93 0.350 -.1703928 .0603823
english | .6406407 .1807193 3.54 0.000 .2864374 .9948441
white | 7.57535 1.08956 6.95 0.000 5.439852 9.710849
lwhitemg | -.8509358 .1158823 -7.34 0.000 -1.078061 -.6238106
_cons | -24.58886 20.24738 -1.21 0.225 -64.273 15.09528
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .002125
lgdp | -.001649 .004577
lgdpau | .00114 -.000973 .327111
lgdpdfrati~w | -.001935 .003176 -.027329 .09438
lpopau | -.005779 .002169 -1.12512 .119874 4.16281
lpop | -.000089 -.004598 .00277 -.001289 -.016646 .008553
lxrate1 | .00014 .000413 .000685 .00257 -.00673 -.00059 .000917
lremote | .000109 .000381 -.022181 .002824 .092248 -.003442 .000535
ldist | .00895 -.009646 .002731 .002547 -.030965 .004996 .002158
lopen | .00002 -.000121 .002417 .001264 -.012102 .001046 -.000335
english | -.00125 -.000495 .005622 .004409 -.043836 .002485 .00163
white | .010802 -.024859 .019546 -.003769 -.148168 .030765 .001647
lwhitemg | -.001544 .001946 -.004422 .000588 .023019 -.001985 -.000146
_cons | .008784 .051059 10.2523 -1.46956 -39.9246 .15928 .06171
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .028928
ldist | .003757 .14252
lopen | -.001427 .000959 .003466
english | -.005415 .001576 -.000959 .032659
white | -.012051 .055932 .002104 .03516 1.18714
lwhitemg | .004209 -.007149 -.000514 -.001779 -.121079 .013429
_cons | -1.19949 -.868693 .129099 .568043 1.51885 -.239067 409.956
.
.
. *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) = 3478.90
Log likelihood = -1553.704 Prob > chi2 = 0.0000
------
lrdiff_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .4685945 .0545107 8.60 0.000 .3617554 .5754336
lgdp | 1.064831 .0648188 16.43 0.000 .9377884 1.191873
lgdpau | 1.917621 2.024369 0.95 0.344 -2.05007 5.885311
lgdpdfrati~w | -2.25152 .8215353 -2.74 0.006 -3.8617 -.6413407
lpopau | -7.305414 6.969694 -1.05 0.295 -20.96576 6.354935
lpop | -.1318702 .0816149 -1.62 0.106 -.2918324 .028092
lxrate1 | -.0622777 .0281263 -2.21 0.027 -.1174043 -.0071511
lremote | .1663524 .2094144 0.79 0.427 -.2440922 .576797
ldist | -2.245958 .2343279 -9.58 0.000 -2.705232 -1.786683
lopen | .0796997 .0892576 0.89 0.372 -.0952419 .2546414
english | .5471184 .1931163 2.83 0.005 .1686175 .9256194
white | 3.161845 1.186918 2.66 0.008 .8355293 5.488161
lwhitemg | -.2886888 .1074537 -2.69 0.007 -.4992943 -.0780833
_cons | 73.30415 64.20294 1.14 0.254 -52.53129 199.1396
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .002971
lgdp | -.002137 .004201
lgdpau | -.003128 .006504 4.09807
lgdpdfrati~w | -.003698 .001495 -.201829 .67492
lpopau | .010648 -.030579 -13.8944 .956417 48.5766
lpop | .000306 -.003621 -.001913 .001532 .009991 .006661
lxrate1 | .000194 .00046 .000807 -.000562 -.006805 -.000805 .000791
lremote | .004548 -.003469 -.000751 -.007863 -.015381 .000689 .001033
ldist | .00652 -.006029 -.006949 .011282 .017537 .002874 .002806
lopen | -.000426 .000797 .015376 .00297 -.07749 .001057 -.000144
english | -.003443 .003463 .003931 .010625 -.00569 -.004392 .001196
white | .021636 -.022083 .025233 -.124039 -.127102 .01184 .002687
lwhitemg | -.001916 .001428 -.002487 .010623 .011757 -.000244 -.000151
_cons | -.168882 .396196 123.179 -11.3602 -442.09 -.172 .054457
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .043854
ldist | .021641 .05491
lopen | .003412 .000437 .007967
english | -.018448 .002018 -.002731 .037294
white | .094263 .026955 -.003784 -.029148 1.40877
lwhitemg | -.005611 -.000197 .000422 .002122 -.123868 .011546
_cons | -.264127 -.791751 .821081 .117936 .644131 -.104395 4122.02
.
. *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) = 1198.55
Log likelihood = -1640.291 Prob > chi2 = 0.0000
------
lrhomo_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .6276604 .0671913 9.34 0.000 .4959679 .7593529
lgdp | .7035258 .113993 6.17 0.000 .4801037 .926948
lgdpau | 1.63357 1.994893 0.82 0.413 -2.276348 5.543489
lgdpdfrati~w | -.0941153 .713121 -0.13 0.895 -1.491807 1.303576
lpopau | -11.87936 6.834504 -1.74 0.082 -25.27474 1.516024
lpop | .1470108 .109414 1.34 0.179 -.0674367 .3614583
lxrate1 | .0764188 .0446034 1.71 0.087 -.0110023 .1638399
lremote | -1.074171 .3152738 -3.41 0.001 -1.692096 -.4562457
ldist | -.8125182 .606037 -1.34 0.180 -2.000329 .3752924
lopen | .2276158 .1202464 1.89 0.058 -.0080628 .4632944
english | .4307865 .3316 1.30 0.194 -.2191376 1.080711
white | 12.25018 2.900413 4.22 0.000 6.565479 17.93489
lwhitemg | -1.423051 .2981195 -4.77 0.000 -2.007355 -.8387476
_cons | 154.4415 63.70996 2.42 0.015 29.57231 279.3108
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .004515
lgdp | -.005188 .012994
lgdpau | .00077 -.001214 3.9796
lgdpdfrati~w | -.007531 .013513 -.107168 .508542
lpopau | -.009159 -.008233 -13.3221 .545734 46.7104
lpop | .00081 -.006703 -.001544 -.002571 .006211 .011971
lxrate1 | -.000155 .001444 .003469 .003759 -.026081 -.001372 .001989
lremote | .002399 .007268 -.054912 .006213 .14774 -.006539 -.000437
ldist | .022613 -.016566 -.017497 -.012331 -.043927 .012966 .001769
lopen | -.001007 .001165 -.015365 .005691 .02228 .001933 .000336
english | -.005358 .008678 .026835 .018971 -.123629 .005112 .004669
white | .018169 -.039934 .152865 -.036523 -.72889 .039429 .00391
lwhitemg | -.001731 .002476 -.019054 .002446 .088279 -.003184 -.000359
_cons | -.017108 .087468 117.364 -6.95104 -426.761 -.164768 .308338
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .099398
ldist | .057716 .367281
lopen | .003585 -.004616 .014459
english | -.026405 .001421 -.002715 .109959
white | .004559 .009959 -.005489 .116424 8.4124
lwhitemg | .00407 -.002355 .000704 -.01364 -.852536 .088875
_cons | -2.49225 -2.76329 .000255 1.2591 8.1245 -.973673 4058.96
.
. **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) = 3089.77
Log likelihood = -1435.535 Prob > chi2 = 0.0000
------
lrrefp_lx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3036314 .0447715 6.78 0.000 .215881 .3913819
lgdp | 1.069644 .075456 14.18 0.000 .9217533 1.217536
lgdpau | .0565128 .5503287 0.10 0.918 -1.022112 1.135137
lgdpdfrati~w | -.0079641 .2689751 -0.03 0.976 -.5351456 .5192174
lpopau | -3.567207 1.940468 -1.84 0.066 -7.370455 .2360402
lpop | .0689859 .099661 0.69 0.489 -.1263462 .2643179
lxrate1 | -.0037837 .0291331 -0.13 0.897 -.0608834 .0533161