Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Observing within-variation when applying multiple fixed effects

    Hi,

    The setting:
    In a research project of mine I am researching the effect of a CEO's influence in the acquiring firm on the success of an acquisition made by the firm. My sample consists of around 3,000 transactions between 1996 and 2018 whereas each observation represents one Deal. For each deal I have data on acquiring firm level (e.g., CEO in place, size, profitability, listing status), CEO level (e.g., sex, age, tenure) and deal level (e.g., transaction volume, payment method).
    I have 4 continuous variables of interest that work as proxies for a CEOs influence in the acquiring firm.

    Question 1
    Fixed effect models rely on sufficient within variation of the variables of interest and - at least as to my understanding - insufficient within variation can cause some problems when running those models. While there are tests out there to help one to decide on whether run fe models I was wondering how you decide if the observed within variation is large enough. Here is the xtsum output for my four variables of interest (I dropped singleton observations as suggested by Correia 2015):

    Code:
    . xtsum Var1 Var2 Var3 Var4
    
    Variable         |      Mean   Std. dev.       Min        Max |    Observations
    -----------------+--------------------------------------------+----------------
    Var1     overall |  .1624156   .0471193   .0495121   .3118844 |     N =    2670
             between |             .0373512   .0532582   .3118844 |     n =     645
             within  |             .0291219   .0314556   .2888065 | T-bar = 4.13953
                     |                                            |
    Var2     overall |  .3191011   .7216935          0          4 |     N =    2670
             between |             .5993148          0          4 |     n =     645
             within  |             .4214965  -1.680899   3.845417 | T-bar = 4.13953
                     |                                            |
    Var3     overall |  .9621723   2.320448          0         13 |     N =    2670
             between |             1.942231          0         13 |     n =     645
             within  |             1.230062  -6.837828   11.79551 | T-bar = 4.13953
                     |                                            |
    Var4     overall |  .0544385    .063733          0   .3119208 |     N =    2670
             between |             .0546248          0   .3119208 |     n =     645
             within  |             .0377405  -.2184922   .2865345 | T-bar = 4.13953
    Related literature in my research field doesn't refer to any tests to specify whether fe would be appropriate so I was wondering if one could tell simply by looking at the xtsum output?

    Question 2
    How do I observe the within variance if I apply multiple fixed effects?

    My firm fixed effects model takes on the following form:
    Code:
    //Fe Model with Firm and Year fixed effects
    reghdfe DV var1 var2 var3 var4 $Acquiring_Firm_Controls $CEO_Controls $Deal_Controls, vce(cluster Acquiring_Firm_ID) absorb(Acquiring_Firm_ID Year)
    (output omitted)
    With Firm_Controls, CEO_Controls and Deal_Controls containing variables that have been found to impact merger success (the DV) on the firm (e.g., size), CEO (e.g., age) and Deal (e.g., payment method) level.
    I run this firm fixed effects model to adjust for unobservable firm level characteristics that are likely to influence my DV and IVs. I also include Year Fixed effects.

    A related concern is that unobservable CEO level characteristics bias the findings so that I would also like to check the robustness of my findings by including CEO firm fixed effects. In the firm fixed effects model above I compare the same firm that made several acquisitions in my sample but with varying values of my IVs (i.e., observing the within-firm variance).
    In a CEO firm fixed effects model I would compare the deals made by the same firm and same CEO but with varying IV (observing the within CEO-firm variance).
    Before conducting this analysis I would like to check the within variance (as in the firm effects model). I tried to observe the desired variation using xtsum and sumhdfe but didn't really get what I am looking for. Any help is much appreciated.

  • #2
    If your regressors are time-varying, they will surely have a coefficient in one-way fixed-effect estimation. They will almost certainly, especially if they are continuous, even have a coefficient in two-way fixed effect models.

    Here, you've pretty much hit the jackpot: if I understood correctly, you've got all of the following sources of variation: time, firm, CEO and deal.

    Am I correct in assuming that deals are nested within CEOs, who in turn are nested within firms?

    You could potentially interact fixed effects (e.g. firm*year) to capture even more confounding variation and limit bias arising from time-varying unobserved confounders.

    Basically, my point is, if Stata identifies a coefficient on one of your regressors, it has sufficient variation. In practice (at least in my field, applied microeconometrics), we just throw multi way fixed effects at the data by default and then take it from there.

    If you are really interested in going above and beyond to study within variation, you may want to manually perform least squares dummy variable models, and a fixed-effects estimation (https://journals.sagepub.com/doi/pdf...867X1201200305), looking at the coefficients step by step, etc. You could also average your variables across respondent and plot them against time.

    If you want to do robustness checks, try making your model as complex as possible (e.g. through fixed-effects interactions) until it breaks down, i.e. your variables of interest are omitted due to collinearity.

    Comment


    • #3
      Follow up question: Please could you give us details on your variables, notably the outcome variable? Perhaps by using an extract of your data with
      Code:
      dataex
      ?

      Comment


      • #4
        Maxence Morlet Thank you, I really appreciate you answer.

        Here, you've pretty much hit the jackpot: if I understood correctly, you've got all of the following sources of variation: time, firm, CEO and deal.
        I am not quite sure on this one. I don't have a real panel dataset but rather pooled cross sectional data. This is, I observed deals made between 1996 and 2018 in the U.S. market and often have acquirers multiple times in my sample as they conduct more than one acquisition during this time period.

        Here is an example of my data (for simplicity and due to dataex restrictions I left out a number of controls):

        Code:
        * Example generated by -dataex-. For more info, type help dataex
        clear
        input long Acq_ID str7 CEO_ID byte CEO_Age float(CEO_Tenure CEO_Influence1) byte(CEO_Influence2 CEO_Influence3) float CEO_Influence4 double Deal_ID int Deal_Announced byte Acq_Listed double Acq_CAR float Acq_logMktValue byte Acq_NumberDirectors
         71 "207071"  47   4.60274  .1435588 0 0          0 1422673020 15925 1   .9519993984731437 20.447237 12
         71 "207071"  47  4.947945  .1435588 0 0          0 1458849020 16051 1  -1.541903500906821 20.522636 12
         71 "207071"  50  7.323287  .1519759 0 0 .011284576 1755967020 16918 1   .8364199986664539   20.6743 12
         73 "337555"  59 3.8164384 .14403543 1 0  .01356768 1881636020 17343 1  2.6460057110489537 21.181936 13
         73 "337555"  67  .8986301   .203831 1 0  .11117947 2728851020 20149 1  -4.787644069315418         . 14
         73 "456194"  54 1.6575342 .15987206 1 2  .02739392 3089692020 20915 1  .19511691836717038    22.621 12
        112 "512084"  59  .3342466 .14502612 0 0          0 2595799020 19712 1   .5411933399895202 20.635014 12
        112 "512084"  60   .690411  .1522999 0 0  .04813341 2632656020 19842 1 -2.2986211045901275 20.746685 13
        113 "207147"  55  7.449315 .24435797 0 0 .007748139 2220840020 18514 1  -.5403433136260304 20.759224 11
        113 "207147"  58   9.90137  .1778809 0 0 .011199482 2498100020 19409 1  2.4946974085581974 20.973385 10
        113 "207147"  60  12.01096 .20040083 0 0 .015139215 2741427020 20179 1  -4.487339976030167  21.23965 11
        113 "207147"  62 14.545205 .18458274 0 0 .013812028 3163119020 21104 1  .48504035524075445 21.697866 11
        124 "206946"  45  4.208219 .11307847 0 0  .06885068 1307649020 15475 1  3.6687205514550456  21.61172 12
        151 "206069"  43 1.1123288 .15616007 0 0   .0109235 1431929020 15959 1 .026392322621639295  21.05489 11
        151 "499279"  62  7.150685 .15980762 0 0  .04447068 2654157020 19912 1   .7502576503749855  20.92529 13
        151 "499279"  63  8.498631 .16376945 0 0  .04247665 2819669020 20404 1   .5536335988657116  21.03767 13
        151 "499279"  64  9.128767 .15973645 0 0  .04509972 2977848020 20634 1   3.590825426789135   21.1077 14
        152 "1338321" 53  1.789041  .1240363 0 0  .02550852 2777021020 20285 1  3.9530808072579684 19.455883  7
        152 "1338321" 54  .1917808  .1544483 0 0  .02717505 3034336020 20768 1    9.36308608910677 20.066315  8
        152 "1338321" 56 1.3561643 .08948028 0 0  .06823823 3201163020 21193 1   12.47101824461725 20.603193  9
        190 "270497"  51 1.1945206  .3118844 1 0  .13105185 1423323020 15928 1  -2.644106849677599   20.7085 12
        190 "334661"  52 .25205478  .2188542 0 0 .008784038 1512240020 16163 1 -3.6346442715639484  20.93806 13
        190 "511742"  44   .720548 .15887764 0 0 .005715001 1904006020 17419 1  -1.762056906238326 21.017786 10
        190 "511742"  47  3.663014  .1585295 0 0  .01083439 2212623020 18493 1   -5.22601741072109  21.70982  9
        275 "347338"  47  .3671233 .11864538 0 0          0 1624254020 16418 1 -13.816844600049105 21.182116  7
        276 "535362"  43 1.1424657 .15252943 0 0  .01625073 2283294020 18680 1  4.0346841181037885  20.36287  8
        276 "535362"  45  3.008219 .16601743 0 0  .03753942 2483820020 19361 1   3.582171326103593         .  9
        276 "535362"  46  4.578082 .16554445 0 0   .0464628 2660501020 19934 1   -1.07461278651107 22.498676 10
        324 "1135478" 54 4.5561643 .15015487 0 0  .08106737 3246521020 21325 1  -7.896034254994485  23.79165 12
        324 "34064"   39 .24657534 .07947874 0 0          0  856653020 14304 1   1.850095552909985         . 24
        324 "34064"   39   .539726 .07947874 0 0          0  893760020 14411 1  -6.398814218036208  23.66599 24
        324 "34064"   39  .6027398 .07947874 0 0          0  903211020 14434 1  .31846880674315653  23.62557 24
        324 "34064"   40  1.750685 .08952031 0 0          0 1042509020 14853 1   2.983633572428436  23.74665 24
        324 "34064"   40 1.9041096 .08952031 0 0          0 1059790020 14909 1  1.3271396580365893  23.84298 24
        324 "34064"   40 1.9726027 .08952031 0 0          0 1066473020 14934 1  -5.913551001671871  23.95456 24
        324 "34064"   42 3.6438355 .11973118 0 0 .032505587 1314375020 15544 1   5.072822046456308  24.33942 19
        335 "493041"  36 1.4821918 .20272747 0 0  .12847874 2182212020 18383 1 -10.516050924879018 18.552784  5
        335 "493041"  37  .4493151  .2162162 0 0  .18315746 2344302020 18882 1   5.890566950790053  19.32777  4
        394 "320202"  54 .18356164 .11826298 0 0          0 3017167020 20426 1 -1.1167919629815055  20.51526 11
        394 "536492"  44   .739726 .13332741 0 0 .011532642 1955618020 17588 1 -1.8563171933604607  20.82371 11
        428 "1302567" 47  .6712329  .1200243 0 0 .008397065 2915628020 20485 1     2.4002311438912 24.908295 11
        428 "33484"   47  .7232876 .08512575 0 0          0 1255857020 15330 1   2.597590129181088 24.334633 14
        428 "33484"   49  2.169863 .12787671 0 0   .0597643 1400369020 15858 1  -.7975461813901362 24.030554 13
        428 "33484"   49 2.3123288 .12787671 0 0   .0597643 1417761020 15910 1  -4.272882046419594  24.18946 13
        428 "33484"   49  2.487671 .12787671 0 0   .0597643 1436776020 15974 1   .8079482011548147  24.04755 13
        428 "33484"   55  5.589041 .18364824 1 0  .09023573 2104870020 18142 1   .2784752865880654 24.207834 13
        428 "33484"   59  9.457534  .2035623 3 0  .12562007 2546802020 19554 1  1.3248273079298414  24.78246 11
        428 "33484"   60 10.747945 .19793825 3 0  .13236801 2690163020 20025 1  2.1026365774716163  24.90119 11
        428 "33523"   55 4.5178084 .12301464 2 2  .04588657  902694020 14433 1  -6.111688199168854  24.12237 13
        430 "335855"  44  8.216438  .1779433 0 0  .16044904 2518276020 19480 1  7.0572306060601555  19.64824  9
        end
        format %tdDD/NN/CCYY Deal_Announced
        label values Acq_Listed Acq_Listed1
        label def Acq_Listed1 1 "Public", modify
        tostring Acq_ID, replace
        tostring Deal_ID, replace
        order Deal_ID
        format Deal_ID %15.0g
        Each entry represents one acquisition.
        My sample consists of 3,167 acquisitions made by 1,142 firms and 1,488 CEOs.
        The y variable (Acq_CAR) is the Cumulative Abnormal Return (CAR) of an acquirer measured around the date on which a deal was announced. This is a widely used proxy to gauge the markets reaction to the announcement of an acquisition and reflects whether the deal destroys shareholder value (negative CAR) or generates shareholder value (positive CAR) when it is announced.
        My CEO_Influence* variables are proxies for the influence of the CEO in the acquiring firm. My simplified research question is therefore: How do powerful CEOs influence the outcome of M&A?

        Code:
        xtset CEO_ID
        xtsum CEO_Influence*
        Variable         |      Mean   Std. dev.       Min        Max |    Observations
        -----------------+--------------------------------------------+----------------
        CEO_In~1 overall |  .1620211   .0477253   .0495121   .3118844 |     N =    3167
                 between |             .0455882   .0495121   .3118844 |     n =    1488
                 within  |             .0206581   .0288081    .296281 | T-bar = 2.12836
                         |                                            |
        CEO_In~2 overall |  .3252289   .7291022          0          4 |     N =    3167
                 between |             .6745873          0          4 |     n =    1488
                 within  |             .2637943  -1.674771   3.325229 | T-bar = 2.12836
                         |                                            |
        CEO_In~3 overall |  .9602147   2.300745          0         13 |     N =    3167
                 between |             2.181867          0         13 |     n =    1488
                 within  |             .5978512  -4.706452   11.36021 | T-bar = 2.12836
                         |                                            |
        CEO_In~4 overall |  .0548581   .0640552          0   .3119208 |     N =    3167
                 between |             .0606204          0   .3119208 |     n =    1488
                 within  |             .0272823  -.2180726   .2546405 | T-bar = 2.12836
        Code:
        sumhdfe CEO_Influence* , absorb(CEO_ID)
        
        Panel C: Variables that are constant within a fixed effect group
        ----------------------------------------------------------
                         |    Number of ...   |      CEO_ID*    
                Variable |      Obs     Singl |  #Groups      #Obs
        -----------------+--------------------+-------------------
          CEO_Influence1 |    3,167       826 |      104       230
          CEO_Influence2 |    3,167       826 |      532     1,767
          CEO_Influence3 |    3,167       826 |      590     2,004
          CEO_Influence4 |    3,167       826 |      118       266
        Panel C of the user written -sumhdfe- command shows the number of obs. together with the number of singletons and also shows how often each variable is constant within a given fixed effect group (within a given CEO in this case)

        It appears that I have 826 CEOs in my sample that did not conduct more than one deal in the sampling period. This leaves me with 1,488-826 = 662 unique CEOs for which I might be able to observe within-CEO variation in my variables of interest (if variation actually exist). What makes me worrying however is the large number of groups that have no within-variation in the variables CEO_Influence 2 and CEO_Influence 3. For example, for 532 unique CEOs (1,767 obs.), the CEO_Influence2 variable does not change, i.e., has no within-variation. I assume that this is a problem which would have an influence on the coefficients, even though Stata is able to calculate coefficients on these variables? Or am I wrong and this shouldn't bother me at all?
        Last edited by Klaus Klausen; 18 Aug 2022, 06:49.

        Comment

        Working...
        X