+ Reply to Thread
Results 1 to 7 of 7

Thread: Testing a log transformed reg model with the non-log transformed

  1. #1
    Points: 10, Level: 1
    Level completed: 19%, Points required for next Level: 40

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Testing a log transformed reg model with the non-log transformed




    Hello, I was wondering how one test two regression models against each other. One being the log transformed of the other like this:

    y = var1 + var2 + var3...
    log(y) = var1 + var2 + var3...

    Are model (2) nested in model 1? And how does one best compare these two (a test), for which is the best model in total? If possible

  2. #2
    TS Contributor
    Points: 7,081, Level: 55
    Level completed: 66%, Points required for next Level: 69

    Location
    Copenhagen , Denmark
    Posts
    515
    Thanks
    71
    Thanked 123 Times in 116 Posts

    Re: Testing a log transformed reg model with the non-log transformed

    The problem concerns functional form. Models are not nested (rules out LR testing). Simple approach is to compare using information criteria. Another approach would be regression specification error test (RESET). However RESET only tests whether there is a problem of functional form in general in the model without the logged dependent variable. Not whether the problem is specifically related to the dependent variable not being cast in logarithmic form.

  3. #3
    Omega Contributor
    Points: 38,374, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    6,998
    Thanks
    398
    Thanked 1,186 Times in 1,147 Posts

    Re: Testing a log transformed reg model with the non-log transformed

    What about Vuong test, though I cant remember what the test is for

  4. #4
    Points: 10, Level: 1
    Level completed: 19%, Points required for next Level: 40

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Testing a log transformed reg model with the non-log transformed

    Thank you both for answers! I am not really sure what the result from the RESET test mean, but I guess if we find a reasonable p-value for one of them, we can keep this over the other.

  5. #5
    Points: 3,457, Level: 36
    Level completed: 72%, Points required for next Level: 43

    Posts
    156
    Thanks
    42
    Thanked 43 Times in 40 Posts

    Re: Testing a log transformed reg model with the non-log transformed

    I don't think you should test these two models against each other, even if such a test were available. Certainly not a test based on R^2.

    You should take the log of the DV if it makes substantive sense to do so; and not take the log if it doesn't make sense.

    First define the problem, then find a solution. If you are even considering taking the log, the variable is probably skewed. If you decide that it doesn't make sense to take the log, you can use quantile regression. If you are using SAS, you can do this with PROC QUANTREG and methods are available in R and (I am sure) other packages as well. Quantile reg does not mind skewed variables - it's well suited to them.

    Does taking the log make sense? One common case where it does is when the DV is monetary - salary or the cost of something - because we usually think of money in multiplicative terms, not additive ones. That is, if you are shopping for a house and the cost is around $1,000,000 and they offer to take off $10,000 - that's pretty small. But if the cost is around $100,000 and they offer $10,000 off then that is a lot.

    I would transform monetary values with logs even if the result was more skewed than the original

  6. #6
    TS Contributor
    Points: 7,081, Level: 55
    Level completed: 66%, Points required for next Level: 69

    Location
    Copenhagen , Denmark
    Posts
    515
    Thanks
    71
    Thanked 123 Times in 116 Posts

    Re: Testing a log transformed reg model with the non-log transformed

    Quote Originally Posted by PeterFlom View Post
    Does taking the log make sense? One common case where it does is when the DV is monetary - salary or the cost of something - because we usually think of money in multiplicative terms, not additive ones. That is, if you are shopping for a house and the cost is around $1,000,000 and they offer to take off $10,000 - that's pretty small. But if the cost is around $100,000 and they offer $10,000 off then that is a lot.
    Just out of curiosity: Assuming we are modelling the price of a house and we are using a logged model such that dependent variable is log(price) and we also want to check for the added value of the house having an extra bathroom. One obvious strategy would be to include a dummy as independent variable indicating whether the house has an extra bathroom. But now the assumed constant beta-coefficient measures the percentage value added of having an extra bathroom. It does however seem - to me - highly unlikely that the effect in this case should be multiplicative. But then again one might imagine more expensive houses to have equally more expensive bathrooms. So perhaps both make sense and the choice of model is empirical?

  7. #7
    Points: 3,457, Level: 36
    Level completed: 72%, Points required for next Level: 43

    Posts
    156
    Thanks
    42
    Thanked 43 Times in 40 Posts

    Re: Testing a log transformed reg model with the non-log transformed


    I don't know for sure, but I would guess adding a bathroom does have a multiplicative effect. One could check this with data, if one had enough.

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats