------
log: K:\Exports\sireaLeone to Thailand.log
opened on: 1 Aug 2006, 22:27:13
. *Dropping Sirra Leone
. drop if ccode==166900
(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.1 1561183 8397.5 0 1.39e+07
immig | 1000 33460.5 117039 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.5363 16.76561 102.6999 60.87417 207.3465
gdpdfau | 1000 100.7173 4.633489 100.8223 94.42464 109.9797
pop | 1000 4.96e+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 1037.431 10902.06 13.89535 .0068 270182.6
remote | 1000 6740.638 4146.024 6797 1293 39620
dist | 1000 13338.35 3518.503 14215 2409 17972
open | 1000 .7116807 .3879272 .63975 .0887 3.2192
english | 1000 .37 .4830459 0 0 1
gdpdfratio~w | 1000 1.050818 .1792532 1.013736 .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 404946.3 1597577 3443.5 0 1.39e+07
immig | 870 14895.22 27126.04 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.6395 17.09528 101.6138 60.87417 207.3465
gdpdfau | 870 100.7173 4.633836 100.8223 94.42464 109.9797
pop | 870 5.35e+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 1176.456 11682.19 19.96485 .0068 270182.6
remote | 870 7167.202 4116.114 6955 1293 39620
dist | 870 13164.08 3403.632 14040 2410 17972
phone | 870 159.3242 241.8429 49.865 .54 1449.75
open | 870 .7196117 .4091822 .63975 .0887 3.2192
english | 870 .3793103 .4854945 0 0 1
gdpdfratio~w | 870 1.042128 .1838283 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) = 6789.93
Log likelihood = -998.7459 Prob > chi2 = 0.0000
------
lrexp | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .5443354 .0385837 14.11 0.000 .4687129 .619958
lgdp | 1.043538 .0378459 27.57 0.000 .9693613 1.117714
lgdpau | -3.392695 .8850203 -3.83 0.000 -5.127303 -1.658087
lgdpdfrati~w | -1.815342 .3425414 -5.30 0.000 -2.486711 -1.143973
lpopau | 5.039798 3.083245 1.63 0.102 -1.003252 11.08285
lpop | -.0080017 .0428879 -0.19 0.852 -.0920604 .076057
lxrate1 | -.001852 .0153727 -0.12 0.904 -.0319819 .0282778
lremote | .108964 .0799945 1.36 0.173 -.0478222 .2657503
ldist | -1.392796 .1453497 -9.58 0.000 -1.677676 -1.107916
lopen | .8573027 .0804055 10.66 0.000 .699711 1.014895
english | .2092318 .0986573 2.12 0.034 .0158671 .4025965
white | 3.045507 .5662613 5.38 0.000 1.935655 4.155358
lwhitemg | -.3776629 .0514855 -7.34 0.000 -.4785727 -.276753
_cons | .5981346 28.58783 0.02 0.983 -55.43298 56.62925
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .001489
lgdp | -.000838 .001432
lgdpau | -.002997 .002522 .783261
lgdpdfrati~w | .000733 -.001036 -.026082 .117335
lpopau | .011236 -.010259 -2.68446 .142835 9.5064
lpop | .000061 -.000759 .000982 -.000265 -.007509 .001839
lxrate1 | -1.7e-06 .000207 .00005 4.6e-06 -.000616 -.000082 .000236
lremote | -.000287 .001214 .004363 -.002217 -.023849 .000055 .000108
ldist | .003604 -.001978 -.004412 .003627 .00667 .001865 .000504
lopen | -.000448 .000225 .010419 -.001451 -.057356 .001046 -.000043
english | -.00093 .001677 -.002563 .001064 .017654 -.001093 .000498
white | .007177 -.001356 -.005819 -.009974 -.004176 .009862 .001802
lwhitemg | -.000809 .000179 .000702 .00064 -.000152 -.000874 -.000152
_cons | -.133819 .096806 23.9753 -1.80401 -87.0949 .069838 -.001373
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .006399
ldist | .002598 .021127
lopen | .002217 .001465 .006465
english | -.000209 .000779 -.003304 .009733
white | .014327 .03292 .000221 .002546 .320652
lwhitemg | -.001105 -.003362 -.000056 .000021 -.028779 .002651
_cons | .176528 -.234684 .635356 -.25619 -.411239 .043089 817.264
.
. **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) = 7440.10
Log likelihood = -1440.902 Prob > chi2 = 0.0000
------
lrrefp_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3541526 .0458288 7.73 0.000 .2643297 .4439754
lgdp | 1.086226 .0669273 16.23 0.000 .955051 1.217401
lgdpau | -.1843683 .5794038 -0.32 0.750 -1.319979 .9512423
lgdpdfrati~w | -.2360655 .3095238 -0.76 0.446 -.842721 .37059
lpopau | 3.202589 2.072126 1.55 0.122 -.858703 7.26388
lpop | .0290731 .0926964 0.31 0.754 -.1526084 .2107547
lxrate1 | -.0328908 .03034 -1.08 0.278 -.092356 .0265745
lremote | -.3311629 .1733201 -1.91 0.056 -.6708641 .0085383
ldist | -3.129569 .3837446 -8.16 0.000 -3.881695 -2.377444
lopen | -.0766019 .0593663 -1.29 0.197 -.1929576 .0397538
english | .6330351 .1788028 3.54 0.000 .282588 .9834822
white | 7.774293 1.107697 7.02 0.000 5.603246 9.945339
lwhitemg | -.8527671 .1181318 -7.22 0.000 -1.084301 -.6212331
_cons | -38.08107 20.64177 -1.84 0.065 -78.53821 2.376064
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .0021
lgdp | -.001588 .004479
lgdpau | .001035 -.000822 .335709
lgdpdfrati~w | -.001961 .003132 -.027586 .095805
lpopau | -.00542 .001878 -1.15693 .120264 4.2937
lpop | -.000141 -.00464 .002982 -.001189 -.017359 .008593
lxrate1 | .000131 .000425 .00064 .002681 -.006798 -.000605 .000921
lremote | .000154 .000266 -.023014 .002548 .097353 -.00368 .000553
ldist | .009458 -.01079 .002837 .002622 -.027738 .00497 .002302
lopen | .000026 -.000114 .00256 .001182 -.013084 .001094 -.000328
english | -.001089 -.001569 .006247 .0044 -.046601 .00341 .001677
white | .010452 -.025116 .019985 -.003457 -.153052 .031189 .001571
lwhitemg | -.001515 .001958 -.004549 .000548 .023741 -.002012 -.000134
_cons | -.000102 .066695 10.5549 -1.46961 -41.3225 .168319 .062376
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .03004
ldist | .003684 .14726
lopen | -.001545 .00082 .003524
english | -.005684 .000022 -.000835 .03197
white | -.012499 .057724 .002401 .039632 1.22699
lwhitemg | .004405 -.007245 -.000559 -.001988 -.125486 .013955
_cons | -1.26538 -.946447 .143174 .624093 1.57609 -.248569 426.083
.
.
. *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) = 3394.83
Log likelihood = -1546.585 Prob > chi2 = 0.0000
------
lrdiff_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .4530152 .0548823 8.25 0.000 .3454479 .5605824
lgdp | 1.079885 .0635222 17.00 0.000 .9553833 1.204386
lgdpau | 2.262607 2.035865 1.11 0.266 -1.727615 6.252828
lgdpdfrati~w | -2.206564 .8230673 -2.68 0.007 -3.819747 -.5933819
lpopau | -8.044418 7.010236 -1.15 0.251 -21.78423 5.695392
lpop | -.1755232 .0807895 -2.17 0.030 -.3338677 -.0171786
lxrate1 | -.0624873 .0288203 -2.17 0.030 -.1189742 -.0060005
lremote | -.0300022 .2035488 -0.15 0.883 -.4289505 .3689462
ldist | -2.217759 .242444 -9.15 0.000 -2.692941 -1.742577
lopen | .0571602 .0913521 0.63 0.532 -.1218867 .236207
english | .7930976 .1857909 4.27 0.000 .4289542 1.157241
white | 2.54827 1.151296 2.21 0.027 .2917707 4.804768
lwhitemg | -.2492824 .1044457 -2.39 0.017 -.4539921 -.0445726
_cons | 78.32444 64.54814 1.21 0.225 -48.1876 204.8365
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .003012
lgdp | -.002023 .004035
lgdpau | -.002821 .005753 4.14474
lgdpdfrati~w | -.003422 .001456 -.206722 .67744
lpopau | .009475 -.028405 -14.0567 .967803 49.1434
lpop | .00014 -.003434 -.000818 .001077 .00609 .006527
lxrate1 | .000244 .000466 .000787 -.000304 -.006668 -.000872 .000831
lremote | .004233 -.002431 .003284 -.008214 -.031854 -.000539 .001
ldist | .006906 -.006097 -.007798 .013102 .021095 .002477 .00319
lopen | -.000388 .000845 .015433 .002642 -.079528 .001118 -.000168
english | -.003261 .002261 -.000877 .011464 .015117 -.003125 .001312
white | .020417 -.019801 .039393 -.127279 -.181414 .010677 .003003
lwhitemg | -.001863 .001322 -.003322 .010781 .015125 -.000287 -.000204
_cons | -.159086 .371683 124.624 -11.4312 -447.12 -.121906 .049572
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .041432
ldist | .021853 .058779
lopen | .004093 .000143 .008345
english | -.014723 .002604 -.003752 .034518
white | .080537 .03448 -.002554 -.013184 1.32548
lwhitemg | -.004614 -.001036 .000336 .00123 -.116791 .010909
_cons | -.079347 -.865008 .84874 -.134941 1.19615 -.13613 4166.46
.
. *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) = 1222.90
Log likelihood = -1639.973 Prob > chi2 = 0.0000
------
lrhomo_cx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .6442649 .0639607 10.07 0.000 .5189042 .7696256
lgdp | .6339164 .1077713 5.88 0.000 .4226885 .8451443
lgdpau | 1.232779 1.743535 0.71 0.480 -2.184487 4.650046
lgdpdfrati~w | .0577767 .6361426 0.09 0.928 -1.18904 1.304593
lpopau | -10.18208 5.972909 -1.70 0.088 -21.88877 1.524603
lpop | .1551272 .1079906 1.44 0.151 -.0565306 .3667849
lxrate1 | .0762889 .0437619 1.74 0.081 -.0094827 .1620606
lremote | -1.078299 .305442 -3.53 0.000 -1.676954 -.4796435
ldist | -.8255963 .5882732 -1.40 0.160 -1.978591 .3273979
lopen | .2101051 .1065946 1.97 0.049 .0011835 .4190267
english | .3512353 .3321649 1.06 0.290 -.2997958 1.002266
white | 12.49294 2.884371 4.33 0.000 6.839672 18.1462
lwhitemg | -1.428009 .2963893 -4.82 0.000 -2.008921 -.8470965
_cons | 138.1183 55.82845 2.47 0.013 28.69658 247.5401
------
. vce
| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1
------+------
limmig | .004091
lgdp | -.004617 .011615
lgdpau | .003164 -.005052 3.03992
lgdpdfrati~w | -.007134 .013642 -.076454 .404677
lpopau | -.017268 .006418 -10.1595 .41174 35.6756
lpop | .000706 -.006385 -.001021 -.002988 .004549 .011662
lxrate1 | -.000078 .001251 .003855 .003915 -.026722 -.001262 .001915
lremote | .00175 .007459 -.052782 .007631 .147461 -.006618 -.000471
ldist | .021276 -.017474 .00015 -.010321 -.096421 .013522 .002474
lopen | -.001246 .001794 -.018472 .00315 .037041 .001236 .000242
english | -.003699 .004512 .027914 .01954 -.1266 .00635 .004963
white | .017375 -.038774 .150092 -.029545 -.700152 .038784 .005028
lwhitemg | -.00173 .002633 -.018113 .001895 .083137 -.003169 -.00048
_cons | .063219 -.023915 89.3943 -5.45723 -326.234 -.157709 .304582
| lremote ldist lopen english white lwhitemg _cons
------+------
lremote | .093295
ldist | .046487 .346065
lopen | .002893 -.006184 .011362
english | -.026418 .010043 -.002628 .110333
white | -.000102 .024674 -.009012 .132733 8.31959
lwhitemg | .004219 -.003722 .000925 -.014571 -.843183 .087847
_cons | -2.38547 -2.04247 -.143407 1.26233 7.59341 -.903762 3116.82
.
. **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) = 2073.42
Log likelihood = -1440.478 Prob > chi2 = 0.0000
------
lrrefp_lx | Coef. Std. Err. z P>|z| [95% Conf. Interval]
------+------
limmig | .3683001 .0470198 7.83 0.000 .2761429 .4604572
lgdp | .8846285 .0837232 10.57 0.000 .720534 1.048723
lgdpau | -.3461962 .4433709 -0.78 0.435 -1.215187 .5227947
lgdpdfrati~w | .1421823 .2410471 0.59 0.555 -.3302613 .6146259
lpopau | -1.352738 1.581387 -0.86 0.392 -4.4522 1.746724
lpop | .1845964 .0974417 1.89 0.058 -.0063859 .3755787