Hi,
I am New to this site as well as new to Stata. I am doing my Mater degree research by using gravity model on Impact of infrastructure investment on Trade, as an empirical investigation for Sri Lanka. I am Using 30 years data of ten major Exporters of Sri Lanka and I am using panel data.
Sri Lanka`s Export values to those countries are the dependent variable of my model and GDP of Sri lanaka and trade Partner countries, Capital stock data of Sri lanaka and trade Partner countries, and distance between two capital cities are the independent variables.
my main regression model is as follow.
log (X 1j,t ) = α + β1 log(Y 1,t ) + β2 log(Y j,t ) + β3 log(GG 1,t ) + β4 log(GG j,t ) + β5 (D1j ) + U1jt
Where X 1j,t are exports from country 1 (Sri Lanka) to country j (trading partner) at time t, Y 1,t and Y j,t are the GDPs of country 1 (Sri Lanka)and j, (trading partner) respectively, at time t, GG 1j,t are General Government capital stock of country 1 (Sri Lanka) and j, (trading partner) respectively, at time t and D1j is the distance between the capital cities of the two countries.
Further, I have to check following regressions as well:
2. Regression with country fixed effect:
log (X 1j,t ) = α + β1 log(Y 1,t ) + β2 log(Y j,t ) + β3 log(GG 1,t ) + β4 log(GG j,t ) +δj + U1jt
3. Regression with time fixed effect:
log (X 1j,t ) = γ +η1 log(Y j,t ) + η2 log(GG j,t ) + η3 (D1j ) + δt + V1jt
4. Regression with country and time fixed effects:
log (X 1j,t ) = γ +η1 log(Y j,t ) + η2 log(GG j,t ) +δj + δt + V1jt
my problems:
1. How can I incorporate distance data to my main data set. ( I have already combined GDP, Capital stock Data and Export values in Stata format and ran basic commands and got summary of my data other than distance data) please see the attachments do_research.do combined.csv
2. What kind of variables should i create to get output for the above regression? what should be the my final dta data file?
Therefore it is grateful and much appreciated if you could instruct me how can I run my regression and get output with distance data as well please. further, can I see a sample of final dta file (datafile) which has this kind of regression?
kind regards
Kuloja
I am New to this site as well as new to Stata. I am doing my Mater degree research by using gravity model on Impact of infrastructure investment on Trade, as an empirical investigation for Sri Lanka. I am Using 30 years data of ten major Exporters of Sri Lanka and I am using panel data.
Sri Lanka`s Export values to those countries are the dependent variable of my model and GDP of Sri lanaka and trade Partner countries, Capital stock data of Sri lanaka and trade Partner countries, and distance between two capital cities are the independent variables.
my main regression model is as follow.
log (X 1j,t ) = α + β1 log(Y 1,t ) + β2 log(Y j,t ) + β3 log(GG 1,t ) + β4 log(GG j,t ) + β5 (D1j ) + U1jt
Where X 1j,t are exports from country 1 (Sri Lanka) to country j (trading partner) at time t, Y 1,t and Y j,t are the GDPs of country 1 (Sri Lanka)and j, (trading partner) respectively, at time t, GG 1j,t are General Government capital stock of country 1 (Sri Lanka) and j, (trading partner) respectively, at time t and D1j is the distance between the capital cities of the two countries.
Further, I have to check following regressions as well:
2. Regression with country fixed effect:
log (X 1j,t ) = α + β1 log(Y 1,t ) + β2 log(Y j,t ) + β3 log(GG 1,t ) + β4 log(GG j,t ) +δj + U1jt
3. Regression with time fixed effect:
log (X 1j,t ) = γ +η1 log(Y j,t ) + η2 log(GG j,t ) + η3 (D1j ) + δt + V1jt
4. Regression with country and time fixed effects:
log (X 1j,t ) = γ +η1 log(Y j,t ) + η2 log(GG j,t ) +δj + δt + V1jt
my problems:
1. How can I incorporate distance data to my main data set. ( I have already combined GDP, Capital stock Data and Export values in Stata format and ran basic commands and got summary of my data other than distance data) please see the attachments do_research.do combined.csv
2. What kind of variables should i create to get output for the above regression? what should be the my final dta data file?
Therefore it is grateful and much appreciated if you could instruct me how can I run my regression and get output with distance data as well please. further, can I see a sample of final dta file (datafile) which has this kind of regression?
kind regards
Kuloja
Comment