Re: Entering panel-data (cross-sectional time-series data) into SPSS for regression

Posted by Bruce Weaver on Dec 01, 2012; 1:08pm
URL: http://spssx-discussion.165.s1.nabble.com/Entering-panel-data-cross-sectional-time-series-data-into-SPSS-for-regression-tp5716565p5716566.html

With 42 countries, I would guess you want to treat country as random rather than fixed.  Assuming your "simple regression" has a continuous outcome variable, take a look at the MIXED procedure, which allows you to run random intercept & random coefficient models.  If you are unfamiliar with these types of models, I recommend Jos Twisk's introductory book as a good starting point.  One of the chapters includes examples of how to run the models he describes in various packages, including SPSS.

http://books.google.ca/books/about/Applied_Multilevel_Analysis.html?id=N5nCQgAACAAJ&redir_esc=y

HTH.

fazzmo wrote

I am kind of desperate as I dont know how to enter pooled data (I have data about 42 countries over 7 years per variable) into SPSS and then run a simple regression.

So far SPSS does not assign the observations to a certain country and year and rather treats each variable as independent. How do I tell SPSS that I have 42 observations (one for each country) for 7 years per variable and not 294 (7*42) observations?

This is how I arranged it so far:



Do I need to create some Interaction variables (Time*Variable)?

Once I manage to enter this correctly, 4 independent variables (Ease, BusFree, PropRight, Corrup) make up one latent variable which is supposed to have an effect on one dependent variable. I will use SPSS Amos to perform a confirmatory factor analysis and to run a regression, if that's possible.

I would appreciate your help very much as I've been trying to figure this out for days :/ I just need a simple way to get some legitimate results, it does not have to be highly scientific.

Thank you so much in advance.