------

log: K:\Germany to Colombia.log

opened on: 26 Jul 2006, 07:34:09

. *Dropping Germany

. drop if ccode==462680

(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 459028 1537051 7348 0 1.39e+07

immig | 1000 32334.04 116811.3 2790 0 1137050

gdp | 1000 2.54e+11 9.44e+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.5381 16.85538 102.6185 60.87417 207.3465

gdpdfau | 1000 100.7173 4.633489 100.8223 94.42464 109.9797

pop | 1000 4.88e+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.102 10901.71 16.2185 .0068 270182.6

remote | 1000 6776.165 4128.184 6797 1293 39620

dist | 1000 13343.22 3522.529 14215 2409 17972

open | 1000 .7101519 .3894421 .63885 .0671 3.2192

english | 1000 .38 .4856293 0 0 1

gdpdfratio~w | 1000 1.050904 .1806973 1.011523 .5844526 2.009028

white | 1000 .12 .3251241 0 0 1

whitemg | 1000 19373.58 116113.8 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 | 880 400345.4 1589043 3126 0 1.39e+07

immig | 880 14727.79 27016.52 1505 0 158613

gdp | 880 2.35e+11 9.96e+11 1.05e+10 1.92e+08 8.99e+12

gdpau | 880 3.83e+11 4.44e+10 3.80e+11 3.19e+11 4.52e+11

gdpdefnew | 880 104.8121 17.21914 101.7094 60.87417 207.3465

gdpdfau | 880 100.7173 4.633806 100.8223 94.42464 109.9797

pop | 880 5.29e+07 1.64e+08 1.05e+07 41000 1.26e+09

popau | 880 1.82e+07 612835.6 1.82e+07 1.73e+07 1.92e+07

xrate1 | 880 1169.546 11615.77 21.6609 .0068 270182.6

remote | 880 7159.151 4093.339 6938.5 1293 39620

dist | 880 13201.9 3402.569 14045.5 2410 17972

phone | 880 157.5574 241.028 49.13 .54 1449.75

open | 880 .7155966 .4091255 .63385 .0671 3.2192

english | 880 .3863636 .4871925 0 0 1

gdpdfratio~w | 880 1.043893 .185446 1 .5844526 2.009028

white | 880 0 0 0 0 0

whitemg | 880 0 0 0 0 0

------

------

-> white = 1

variable | N mean sd p50 min max

------+------

rimp | 120 889367.1 984682.8 503533 40432 3843839

immig | 120 161446.5 300090.8 17525 2612 1137050

gdp | 120 3.96e+11 3.62e+11 2.40e+11 5.15e+10 1.31e+12

gdpau | 120 3.83e+11 4.46e+10 3.80e+11 3.19e+11 4.52e+11

gdpdefnew | 120 110.862 12.74583 111.5503 85.45601 141.4872

gdpdfau | 120 100.7173 4.65059 100.8223 94.42464 109.9797

pop | 120 1.86e+07 1.99e+07 8363820 3477200 5.87e+07

popau | 120 1.82e+07 615055.4 1.82e+07 1.73e+07 1.92e+07

xrate1 | 120 115.8531 304.1177 4.6693 .3774 1261.556

remote | 120 3967.6 3203.476 2831 1530 12501

dist | 120 14379.58 4173.487 15889 2409 17493

phone | 120 741.7883 272.3272 656.67 343.99 1487.08

open | 120 .6702242 .1871017 .6487 .3517 1.2967

english | 120 .3333333 .4733811 0 0 1

gdpdfratio~w | 120 1.102313 .1305911 1.090668 .8254872 1.441221

white | 120 1 0 1 1 1

whitemg | 120 161446.5 300090.8 17525 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) = 8282.47

Log likelihood = -554.8209 Prob > chi2 = 0.0000

------

lrimp | Coef. Std. Err. z P>|z| [95% Conf. Interval]

------+------

limmig | .3327465 .0312919 10.63 0.000 .2714154 .3940775

lgdp | 1.182934 .033066 35.77 0.000 1.118126 1.247742

lgdpau | -.1317221 .6157448 -0.21 0.831 -1.33856 1.075116

lgdpdfrati~w | -.7776466 .2513733 -3.09 0.002 -1.270329 -.2849639

lpopau | -1.920608 2.124052 -0.90 0.366 -6.083674 2.242457

lpop | .037519 .0457144 0.82 0.412 -.0520796 .1271176

lxrate1 | -.127036 .0169144 -7.51 0.000 -.1601876 -.0938844

lremote | -.4352979 .0839448 -5.19 0.000 -.5998266 -.2707692

ldist | -2.067544 .168646 -12.26 0.000 -2.398084 -1.737004

lopen | .2759141 .0558992 4.94 0.000 .1663536 .3854745

english | .8860449 .1258316 7.04 0.000 .6394195 1.13267

white | 4.602963 .5719066 8.05 0.000 3.482047 5.72388

lwhitemg | -.4284514 .0513391 -8.35 0.000 -.5290741 -.3278286

_cons | 37.13863 19.60168 1.89 0.058 -1.279961 75.55723

------

. vce

| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1

------+------

limmig | .000979

lgdp | -.000307 .001093

lgdpau | -.000784 .001296 .379142

lgdpdfrati~w | -.000845 .000211 -.011562 .063189

lpopau | .001304 -.007885 -1.28084 .056946 4.5116

lpop | -.000264 -.000694 -.000036 .000192 -.000182 .00209

lxrate1 | .000115 .000144 .000386 .000244 -.002685 -.000178 .000286

lremote | .000263 .000196 -.000541 -.001602 -.003954 .000477 -.000065

ldist | .001345 .001099 .000575 -.000965 -.017595 .001129 .001444

lopen | -.000196 .000628 .002256 .000977 -.015926 .000404 .000136

english | -.001139 .002695 .002657 .002182 -.010224 -.00118 .000525

white | .004831 -.001944 .003392 -.011069 -.027726 .004282 .000555

lwhitemg | -.000616 .000189 -.000348 .001033 .003013 -.000222 -.000092

_cons | -.011417 .07023 11.2871 -.687451 -40.9295 -.025351 .018797

| lremote ldist lopen english white lwhitemg _cons

------+------

lremote | .007047

ldist | .007007 .028441

lopen | .00156 .001196 .003125

english | -.002966 .003113 -.000718 .015834

white | -.001551 -.000688 -.00073 .001341 .327077

lwhitemg | .000436 -.000131 7.8e-06 .000069 -.028756 .002636

_cons | -.057758 -.110586 .161147 .046979 .328566 -.039586 384.226

.

. **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) = 64459.46

Log likelihood = -951.8021 Prob > chi2 = 0.0000

------

lrrefp_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]

------+------

limmig | .0521488 .0139987 3.73 0.000 .0247119 .0795858

lgdp | 1.596204 .0502208 31.78 0.000 1.497773 1.694635

lgdpau | .8660307 .3588132 2.41 0.016 .1627696 1.569292

lgdpdfrati~w | -.4286567 .1488839 -2.88 0.004 -.7204638 -.1368496

lpopau | -6.315588 1.211743 -5.21 0.000 -8.690561 -3.940616

lpop | -.3266555 .0823949 -3.96 0.000 -.4881467 -.1651644

lxrate1 | -.1215082 .0202955 -5.99 0.000 -.1612867 -.0817297

lremote | -.9757285 .0948629 -10.29 0.000 -1.161656 -.7898006

ldist | -3.25011 .1468656 -22.13 0.000 -3.537961 -2.962259

lopen | -.053507 .0267551 -2.00 0.046 -.105946 -.0010681

english | .9959083 .0858257 11.60 0.000 .8276931 1.164123

white | 4.780651 .7569694 6.32 0.000 3.297018 6.264284

lwhitemg | -.4710984 .0720879 -6.54 0.000 -.6123881 -.3298086

_cons | 95.20386 11.38695 8.36 0.000 72.88586 117.5219

------

. vce

| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1

------+------

limmig | .000196

lgdp | -.000255 .002522

lgdpau | -.001248 .001779 .128747

lgdpdfrati~w | -.000601 .000562 -.011907 .022166

lpopau | .004931 -.007493 -.425671 .024288 1.46832

lpop | .000144 -.003897 -.00144 .000384 .004444 .006789

lxrate1 | -.000029 .000297 -.000028 .000408 -.003173 -.000334 .000412

lremote | .000419 .000244 -.006537 -.003224 .022917 -.000982 .000072

ldist | .000563 -.000831 -.00626 -.001864 .016832 .001113 .000497

lopen | .000044 -.000097 -.000979 .00091 .003608 .000256 -.000074

english | -.000432 .000325 .003195 .002596 -.020285 .000149 .001102

white | .001063 -.010656 -.011273 -.005886 .046281 .015109 -.000745

lwhitemg | -.000088 .000476 .000517 .000401 -.003168 -.000532 .000113

_cons | -.054829 .087135 3.80036 -.082203 -13.4911 -.055828 .044793

| lremote ldist lopen english white lwhitemg _cons

------+------

lremote | .008999

ldist | .005017 .021569

lopen | .000631 .000218 .000716

english | -.002613 .001698 -.000405 .007366

white | .011159 -.037357 .00164 -.0033 .573003

lwhitemg | -.000391 .004659 -.000118 .000529 -.053013 .005197

_cons | -.325135 -.369753 -.04424 .244531 -.198505 -.005744 129.663

.

.

. *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) = 7351.16

Log likelihood = -926.9327 Prob > chi2 = 0.0000

------

lrdiff_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]

------+------

limmig | .1131967 .0241466 4.69 0.000 .0658704 .1605231

lgdp | 1.717011 .0706798 24.29 0.000 1.578481 1.855541

lgdpau | .0847305 .5679206 0.15 0.881 -1.028373 1.197834

lgdpdfrati~w | -.3819091 .2247513 -1.70 0.089 -.8224135 .0585953

lpopau | -2.416423 1.975257 -1.22 0.221 -6.287856 1.45501

lpop | -.6266944 .0793735 -7.90 0.000 -.7822636 -.4711251

lxrate1 | -.1575128 .0277518 -5.68 0.000 -.2119054 -.1031201

lremote | -.3748912 .1294192 -2.90 0.004 -.6285481 -.1212344

ldist | -4.03898 .3477406 -11.61 0.000 -4.720539 -3.357421

lopen | .071149 .0437224 1.63 0.104 -.0145453 .1568432

english | 1.016623 .1424178 7.14 0.000 .7374897 1.295757

white | 9.479986 2.013262 4.71 0.000 5.534065 13.42591

lwhitemg | -.7992159 .2029283 -3.94 0.000 -1.196948 -.4014838

_cons | 54.88929 18.65839 2.94 0.003 18.31952 91.45905

------

. vce

| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1

------+------

limmig | .000583

lgdp | -.000904 .004996

lgdpau | -.001964 .004907 .322534

lgdpdfrati~w | -.000888 .002054 -.018652 .050513

lpopau | .005291 -.023438 -1.09067 .063353 3.90164

lpop | .000631 -.004056 -.002828 -.001142 .011277 .0063

lxrate1 | .000031 .0005 .000285 .000955 -.005964 -.00074 .00077

lremote | -.000062 -.00093 -.006936 -.001605 .021385 -.001315 .000174

ldist | .002653 .007547 -.009318 -.002689 -.022344 -.001285 .001513

lopen | .000106 -.000624 .000154 .001734 -.000472 .00108 -.000209

english | -.001038 .003215 .006184 .003402 -.036315 .001458 .001964

white | .001334 -.029669 .006695 .002507 -.002935 .022072 .005305

lwhitemg | -.000119 .001539 -.002123 -.000687 .007482 -.001373 -.00056

_cons | -.0523 .149733 9.74456 -.600064 -35.8304 -.097291 .071623

| lremote ldist lopen english white lwhitemg _cons

------+------

lremote | .016749

ldist | .006527 .120924

lopen | .000518 -.000747 .001912

english | -.005748 .004781 -.001468 .020283

white | .012392 -.148262 .002406 .018829 4.05322

lwhitemg | .000994 .011762 -.000116 -.00266 -.400522 .04118

_cons | -.340937 -.75951 .003191 .339215 1.44916 -.198332 348.135

.

. *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) = 2243.72

Log likelihood = -1088.823 Prob > chi2 = 0.0000

------

lrhomo_cm | Coef. Std. Err. z P>|z| [95% Conf. Interval]

------+------

limmig | .0842909 .0394979 2.13 0.033 .0068763 .1617054

lgdp | .9547099 .0809461 11.79 0.000 .7960585 1.113361

lgdpau | -.3637736 .9261303 -0.39 0.694 -2.178956 1.451408

lgdpdfrati~w | -.381555 .373736 -1.02 0.307 -1.114064 .3509541

lpopau | -.0752647 3.172454 -0.02 0.981 -6.29316 6.14263

lpop | -.0138151 .1020023 -0.14 0.892 -.2137359 .1861057

lxrate1 | -.1350057 .0331895 -4.07 0.000 -.200056 -.0699554

lremote | .5427779 .2467771 2.20 0.028 .0591037 1.026452

ldist | -1.801694 .3348227 -5.38 0.000 -2.457935 -1.145454

lopen | .3637819 .085975 4.23 0.000 .1952739 .5322898

english | 1.918455 .2499954 7.67 0.000 1.428473 2.408437

white | 2.288151 2.206121 1.04 0.300 -2.035766 6.612069

lwhitemg | .0467504 .1899784 0.25 0.806 -.3256004 .4191012

_cons | 4.765585 30.00959 0.16 0.874 -54.05212 63.58329

------

. vce

| limmig lgdp lgdpau lgdpdf~w lpopau lpop lxrate1

------+------

limmig | .00156

lgdp | -.001488 .006552

lgdpau | -.001335 .000468 .857717

lgdpdfrati~w | -.000126 .001192 -.013076 .139679

lpopau | .001075 -.005364 -2.87378 .042791 10.0645

lpop | .000343 -.005985 .000927 -.000732 -.00431 .010404

lxrate1 | .000094 .000925 .000489 .002137 -.0075 -.00129 .001102

lremote | .001594 .000871 -.02897 -.016121 .090737 .000601 -.00093

ldist | .004077 -.006717 -.020751 -.007215 .065775 .010279 -.000556

lopen | .000256 -.00133 .006086 .003178 -.0324 .003581 -.000245

english | -.003493 .001044 .008493 .006139 -.013204 -.00136 .00168

white | .003168 -.020295 .0978 .003641 -.381303 .019298 .002438

lwhitemg | -.000436 .000386 -.010222 -.001923 .041939 .00005 -.000494

_cons | -.013945 .084769 25.618 -.318747 -92.894 -.082043 .118015

| lremote ldist lopen english white lwhitemg _cons

------+------

lremote | .060899

ldist | .024561 .112106

lopen | .00208 -.001037 .007392

english | -.017629 .012359 -.002459 .062498

white | .048612 -.048182 .008642 .025054 4.86697

lwhitemg | -.00119 .008971 -.000544 -.001408 -.409116 .036092

_cons | -1.52644 -1.86164 .344859 .019803 3.91398 -.508025 900.575

.

. **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) = 71325.96

Log likelihood = -884.7546 Prob > chi2 = 0.0000

------

lrrefp_lm | Coef. Std. Err. z P>|z| [95% Conf. Interval]

------+------

limmig | .0246344 .0136442 1.81 0.071 -.0021078 .0513767

lgdp | 1.557314 .0513642 30.32 0.000 1.456642 1.657986

lgdpau | .6590435 .3730738 1.77 0.077 -.0721676 1.390255

lgdpdfrati~w | -.2326431 .1312271 -1.77 0.076 -.4898434 .0245572

lpopau | -6.53019 1.260384 -5.18 0.000 -9.000497 -4.059884

lpop | -.1725354 .0857822 -2.01 0.044 -.3406655 -.0044053