```Date: Thu, 12 Dec 2002 17:03:07 -0500 Reply-To: Richard Ristow Sender: "SPSSX(r) Discussion" From: Richard Ristow Subject: Re: log transform Comments: To: jkenty@lynx.dac.neu.edu In-Reply-To: <000201c2a223\$a1639bd0\$5f4c0a81@neu.edu> Content-Type: text/plain; charset="us-ascii"; format=flowed At 04:15 PM 12/12/2002 -0500, Jessica L. Kenty wrote: >I have very skewed data. I want to use log transformation to "fix" >it. I realize I can't have any 0's (need to add +1 to all >values). But, my variable has negative & positive values. Do I need >to adjust all values to be above zero (i.e. -85000 adjust by adding >85001 to = 1)? Well, you'd have to do something like that; but I think you should look at your data and give some thought to what a 'fix' would mean. What does the distribution look like? Is it skewed away from zero in both directions? If you log-transform, say, income (I'm looking at your institutional affiliation in your sig), you're making an implicit judgement (with, I believe, some support in psychology) that the perceived size of a change in income is the proportional change: that a doubling of your income or mine, and Bill Gates's, would affect us all about equally. If, say, you're looking at net worth skewed in both directions, it might work better to take the log of the absolute value in each direction. Alternatively (following Tukey and others), you can accept that any transformation is fundamentally arbitrary, and use non-parametric statistical methods on your data. Unfortunately, in an economic project you may be committed to multiple regression, which doesn't have non-parametric analogs that I know of. Sorry for more questions than answers. You sound, though, like you have a situation where the proper statistics depend on what you're measuring, and what you regard as meaningful about it. -Richard Ristow >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Jessica L. Kenty-Drane >Research Assistant >Assets & Educational Inequality Project >Department of Sociology and Anthropology >Northeastern University >Boston, MA ```

Back to: Top of message | Previous page | Main SPSSX-L page