Fixed effects panel regression in SPSS using Least squares dummy variable approach

In this video, I provide a demonstration of how to carry out fixed effects panel regression using SPSS. I begin with a short overview of the model and why it is used. Next, I cover steps for carrying out the fixed effects regression. Included in the video is an illustration of how to restructure your data from wide to long format, dummy coding, and running the regression analysis. I also provide an additional demonstration using General linear model to Univariate menus that may be useful when the number of cases in your dataset is large (and directly dummy coding variables may be especially tedious or impractical). Finally, after running the analyses I compare the results obtained through SPSS with results obtained using Stata's 'xtreg' and 'regress' functions (menus).
You are welcome to download a copy of the text document I review in the video here:
drive.google.com/file/d/1-TxU...
A copy of the SPSS data file in wide format can be downloaded here:
drive.google.com/file/d/1E2sj...
A copy of the data in long format can be downloaded here:
drive.google.com/file/d/1w6Um...

Пікірлер: 59

  • @elidireye8493
    @elidireye84932 жыл бұрын

    Thank you for sharing your knowledge with the world. I had trouble with panel data analysis in spss until I found your lecture. The example used to demonstrate the application of fixed effects regression on panel data is very useful. Keep posting more similar videos.

  • @anthonygikuri
    @anthonygikuri2 жыл бұрын

    Thank you for this video!!! Surely it's one of the best videos you continually devote your time to create and share with us! It's really makes difference.

  • @husseinbotchway8307
    @husseinbotchway8307 Жыл бұрын

    Sir Mike, we are Grateful. Continue making a Difference in the world !

  • @cuiweiqd
    @cuiweiqd3 жыл бұрын

    Thanks for explaining the fixed effect model. Very clear and helpful!

  • @beauyanvanderlans6235
    @beauyanvanderlans62354 жыл бұрын

    Mike, thanks for explaining this process in SPSS! Greetings from NL

  • @kawualhassan1837
    @kawualhassan18373 жыл бұрын

    Thanks, I thought SPSS has no capacity for panel data analysis but with this vedio am informed.

  • @uwewagschal3912
    @uwewagschal3912Ай бұрын

    Very Very useful. Brilliant explanation

  • @mikecrowson2462
    @mikecrowson24624 ай бұрын

    Hello everyone! It has come to my attention that a few of the links to the datasets, etc. under the video description were broken. I have updated these (as of March 18, 2024). My apologies (and honestly, I don't know how this happened). Additionally, I wanted to let you know that I also have a more recent video on this topic that also demonstrates the use of cluster-robust standard errors. Please go to kzread.info/dash/bejne/gH1mtdeFd8zZo8Y.html to view . As always, thank you for visiting!

  • @DrTC-cm5dn
    @DrTC-cm5dn2 жыл бұрын

    Outstanding video and explanation. Thank you, Mike!

  • @ekaterinamaklasova2092
    @ekaterinamaklasova20923 жыл бұрын

    Thank you for this video with step-by-step instruction. It was really helpful. Initially, I did the same via the mixed models` option but did not get the model fit. Now I have everything that I need.

  • @prof.gobindaroy
    @prof.gobindaroy5 жыл бұрын

    Very informative and useful. Thank you!

  • @ibrahimseylim3585
    @ibrahimseylim35855 жыл бұрын

    you are such a good teacher.......bravo....very clear and vital information.....will be glad if i can get to connect with you

  • @greggoodman6545
    @greggoodman65455 жыл бұрын

    I appreciate you big time!

  • @galebren8842
    @galebren8842 Жыл бұрын

    Excellent. Exactly what I needed. Thanks.

  • @yulinliu850
    @yulinliu8505 жыл бұрын

    Very much appreciated!

  • @kushvinderkaur6968
    @kushvinderkaur69683 жыл бұрын

    thanks for the nice illustration!!

  • @dr.hossamattia253
    @dr.hossamattia2534 жыл бұрын

    really we appreciate your great efforts & best

  • @mikecrowson2462

    @mikecrowson2462

    4 жыл бұрын

    thank you so much Hossam! best wishes!

  • @mehtapeklund3345
    @mehtapeklund3345 Жыл бұрын

    Thanks for this amazing video. appreciated.

  • @alekdenstore92
    @alekdenstore924 жыл бұрын

    Great video.

  • @Tom111589
    @Tom1115894 жыл бұрын

    Brilliant :)

  • @davidrubin6055
    @davidrubin60553 жыл бұрын

    Thanks for this video and your other great videos, Mike. Are you able to give any pointer on how to control for between-group variation using fixed effects dummy variables when the number of categories of the would-be dummy variable is very high? For example, country-level fixed effects when the number of countries is around 200. How might you create such a dummy variable in SPSS? Thanks again.

  • @sergretest410
    @sergretest4104 жыл бұрын

    Thank's a lot! Can you tell something about the non-stationarity of the variables? Is it possible to ignore it using fixed effects?

  • @Superpindaa1
    @Superpindaa13 жыл бұрын

    This is great!!!

  • @radhakrishnankalidoss624
    @radhakrishnankalidoss624 Жыл бұрын

    Thanks a lot for sharing this

  • @evaahartje
    @evaahartje3 жыл бұрын

    Thank you for this helpful video! Is this same approach also possible using multivariate logistic regression (in SPSS, via complex sample package)?

  • @1969GKOS
    @1969GKOS2 жыл бұрын

    Thanks, reaaly appreciate it! I have a question though. If you have a (time varying control variable) how is the best way to use it in this model ?

  • @katjalasser4883
    @katjalasser48835 жыл бұрын

    Thanks a lot for the video. Maybe I understood something wrong. Why can you just use the tools for a normal multiple regression for panel data without controlling for the time or that the different measurements over time for each state do probably have something in comen?

  • @mariskadonga8305
    @mariskadonga8305 Жыл бұрын

    hi thanks for the video. I have regression with control variables and fixed effects (country and time specific), how do i apply this in spss?

  • @mashael7048
    @mashael70485 ай бұрын

    Thank you.

  • @wilberforcejahonga194
    @wilberforcejahonga1944 жыл бұрын

    VERY INTERESTING WITH SPSS. DIDNT KNOW SPSS IS THIS RICH!!!!

  • @Liilaify
    @Liilaify3 жыл бұрын

    Thank you so much for this video! I was wondering: you do create a dummy variable for each characteristic. When running the regression, would I need to use one less dummy variable than I have? To avoid multicollinearity? That's what I understood from reviewing info on OLS models. Would so much appreciate your answer!

  • @ashwagalrudayni2630

    @ashwagalrudayni2630

    2 жыл бұрын

    Did you get the answer?

  • @harielvis
    @harielvis3 жыл бұрын

    Thanks a lot. I'm sure one unlike is purely unintentional.

  • @mikecrowson2462

    @mikecrowson2462

    3 жыл бұрын

    Hi Hari, thanks for visiting and your kind remark :) Best wishes to you!

  • @anthonygikuri
    @anthonygikuri2 жыл бұрын

    Suppose I have 500 cases measured over and over. Is it possible to create dummies for all these and use them in the model? I'm wondering how this model will look like!! Thank you

  • @lyndazhang
    @lyndazhang2 жыл бұрын

    The R-Squared value for the panel regression in STATA is 0.3920 overall, which is lower than 0.819, right?

  • @mikecrowson2462

    @mikecrowson2462

    2 жыл бұрын

    The R-square overall in Stata is computed differently than the R-square in spss, and I don't find the Stata overall R-square particularly useful. But I just created a new presentation on panel regression in spss with repeated measures data you might find helpful at kzread.info/dash/bejne/lYKTlrSola7ShJc.html

  • @hasnaagourram5675
    @hasnaagourram56754 жыл бұрын

    Hello ! Very interesting video! I am a phd student and would like to know if I can contact you personally via email to ask a question concerning Fixed Effects models. Thank you

  • @KaitlynStormes
    @KaitlynStormes6 ай бұрын

    Thanks for this great video. Is it possible to use a stepwise approach to adding variables in blocks/steps where the dummy-coded variables would enter on their own? If so, would they enter first, last, or in some other temporal fashion in alignment with our theoretical framework/literature that guides the research?

  • @KaitlynStormes

    @KaitlynStormes

    6 ай бұрын

    In my case, I'm using undergraduate student-level data, and I'm trying to account for differences across institutions. I have 16 institutions, and I'm selecting one as a reference group to leave out of the regression.

  • @mikecrowson2462

    @mikecrowson2462

    4 ай бұрын

    Hi Kaitlyn, If I am reading your question correctly, you are asking if you an enter the dummy variables first in an initial step in the first block, and then in the second block of variables set this to stepwise (to let the algorithm select the best set of within-case predictors). I have never done this myself or seen anyone else use this particular strategy before (truthfully, I am not a big fan of using stepwise approaches AND I have not really spent much time reflecting on this particular question before). As far as I can tell, there is nothing that would seemingly prohibit you from being able to do what you are describing in SPSS (I was able to accomplish it using the dataset from this video). In other words, Step 1 I entered the dummy variable with the entry method to ENTER; in Step 2, I entered the other predictors and reset the entry method to STEPWISE. Please be clear though, I am not endorsing or recommending this approach, but just telling you how it might be accomplished using SPSS. I hope this helps! Cheers!

  • @KaitlynStormes

    @KaitlynStormes

    4 ай бұрын

    Great, thanks for your clear and thoughtful response! @@mikecrowson2462

  • @TheMarinho1
    @TheMarinho18 ай бұрын

    Could you reupload the dataset on google? I get an error 404 from google drive.

  • @sophieollivier7874
    @sophieollivier78743 жыл бұрын

    is it possible to do hierarchical models with fixed effects?

  • @mikecrowson2462

    @mikecrowson2462

    3 жыл бұрын

    The fixed effects model does not assume random intercepts or slopes as you would see in hierarchical models. And it does not allow you to model between-group predictors of the outcome as you could do in the case of a random effects model. SPSS does not have a random effects mechanism as far as I've found. Assuming a reasonably large number of groups randomly sampled from the population of groups (level 2 units in multilevel terminology), I generally prefer to use a multilevel modeling approach. But this fixed effects approach is pretty good when you have a smaller number of level 2 units. If you have predictors you wish to model at the group level (level 2), it is possible to include them only by modeling interactions involving level 1 predictors. Here's a nice article I found that you might find useful: biol609.github.io/Readings/McNeish_Kelley_PsychMethods_2019.pdf

  • @awungfonkeng1858
    @awungfonkeng18584 жыл бұрын

    so nice and straight to the point. how does one chose between fixed effect and random effect using spss. how do does one know which model is best fit between fixed effect and random effect using spss in order to conduct a panel data analysis?

  • @1995Sailormoon

    @1995Sailormoon

    4 жыл бұрын

    I am wondering the same. How to do Hausman test of specification in SPSS?

  • @haiyingwang5987
    @haiyingwang59873 жыл бұрын

    How is this model different from a multiple linear regression model?

  • @mikecrowson2462

    @mikecrowson2462

    3 жыл бұрын

    Hi Haiying, it actually isn't different at all mathematically. It's basically a multiple regression using dummy coding of a group membership variable to control for any of the association between the iv's and dv that may be occurring between groups. By controlling for the variation occurring between groups, you end up with the within-groups associations remaining. Here is a link to a presentation that you might find helpful (of course the discussion is mainly in terms of Stata, but it does provides useful conceptual information): www.princeton.edu/~otorres/Panel101R.pdf

  • @haiyingwang5987

    @haiyingwang5987

    3 жыл бұрын

    @@mikecrowson2462 Thank you very much professor! Does this mean that if you want to estimate time-fixed effects, you can also just simply add the time variable to the multiple linear regression (e.g., year) which would be just the same as using a time-fixed effects model?

  • @FELIX-qr6vd
    @FELIX-qr6vd4 ай бұрын

    How does SPSS know that this is a panel data? On other Software we declare that this is panel data, but on SPSS I don't see that option.

  • @mikecrowson2462

    @mikecrowson2462

    4 ай бұрын

    Hi there. And thanks for the question. When you declare data to be panel data (such as in Stata if you are running a fixed-effects regression), the program takes care of various pre-processing steps prior to running the analysis. In theory, there are two different pre-processing steps can be used with our data when running a fixed-effects regression: Mean-deviation centering method or the creation of dummy coded variables (both methods assume your data are in long/vertical format). The default in Stata (I'll get to SPSS soon) when you use xtset along with the xtreg command and fe option is to recognize that panel data is being analyzed. As a result, Stata takes care of the pre-processing for you (using mean-deviation approach; see Allison, 2009) - and adjusts standard errors in your regression accordingly. If you are using the reg command in Stata, then the program would not recognize the data as panel. In this case, you would have to create dummy variables and then enter them into your regression (or, if you use the i. prefix, this can be used with your factor variable (which will lead to the automatic inclusion of the dummy variables in your regression). The latter method (Least-squares dummy variable approach) is essentially what we are doing in the example in my presentation with SPSS. BOTH SPSS and Stata have the capability to use GEE (Generalized Estimating Equations) with longitudinal data (in fact, I have a video on it in Stata here: kzread.info/dash/bejne/ZqqFyNeCgqzHmLw.html). In Stata, you would be using the xtreg command with pa (for population-averaged), whereas in SPSS you would be going through Generalized linear models --> Generalized estimating equations. I am unclear as to whether you are wondering about SAS or R; but the logic I use above is the same. I can't speak much to SAS, but I do believe the 'plm' package for R uses the same approach (mean-deviations approach) as I noted above for SPSS. I hope this answers your question!

  • @FELIX-qr6vd

    @FELIX-qr6vd

    4 ай бұрын

    @@mikecrowson2462 Yes, thank you.

  • @moritzro7464
    @moritzro74642 жыл бұрын

    i don't understand a thing. i'm lost...

  • @astiinayatimagfirah1094
    @astiinayatimagfirah10944 жыл бұрын

    Please upload video about fixed effect panel regression using first difference estimator

  • @rishiaryal8695
    @rishiaryal86953 жыл бұрын

    I spoilt so long organising data !!! You just taught in few clicks!!! I would have watched before!!! 😥

  • @astiinayatimagfirah1094
    @astiinayatimagfirah10944 жыл бұрын

    Please upload fixed effect regression using first difference estimator

  • @sobiawassan5914
    @sobiawassan59144 жыл бұрын

    thanks for this video sir i need your help kindly contact with me by mail