Announcement

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

  • Back transform log transformed coeffcients

    Hello there!

    I have run a linear regression where the dependent variable has been log transformed due to skewness of the data. I have been asked to back transform the coefficients of the regression. I tried this with the command disp exp(X). However, the coefficients negative and as far as I know they cannot be exponentiated? How can I translate them into their non log value?

  • #2
    Originally posted by Ionas Papassotiriou View Post
    . . the coefficients negative and as far as I know they cannot be exponentiated?
    . di exp(-1)
    .36787944


    Two better options . . .

    First choice:
    Code:
    help glm
    especially note the link functions.

    Alterrnative: tell the referee off.

    Comment


    • #3
      You did not show how you fitted the regression. If you have used 'regress' command, 'eform' gives you the exponentiated coefficients:

      Code:
      reg y x1 x2, eform("exp")
      Roman

      Comment


      • #4
        Beware that with log transforming the dependent variable combined with the eform() option you no longer model the conditional arithmetic ("normal") mean but the conditional geometric mean: https://doi.org/10.1177%2F1536867X0400300412

        If you want to model the conditional arithmetic mean you need to use glm with the link(log) and vce(robust) options, or equivalently poisson with the vce(robust) options: https://blog.stata.com/2011/08/22/us...tell-a-friend/
        ---------------------------------
        Maarten L. Buis
        University of Konstanz
        Department of history and sociology
        box 40
        78457 Konstanz
        Germany
        http://www.maartenbuis.nl
        ---------------------------------

        Comment

        Working...
        X