13
$\begingroup$

Probably, this is a very basic question but I don't seem to be able to find a solid answer for it. I hope here, I can.

I'm currently reading papers as a preparation for my own master's thesis. Currently, I'm reading a paper which researches the relationship between tweets and stock market features.

In one of their hypothesis, they propose that "increased tweet volume is associated with an increase in trading volume".

I would expect them, in the pairwise correlations, to correlate tweetVolume with tradingVolume, but instead they report using the logged versions: LN(tweetVolume) and LN(tradingVolume).

For my thesis, I have replicated this bit of their paper. I have collected tweets about 100 companies for over 6 months (tweetVolume) and stock trading volume for the same timeframe. If I correlate the absolute variables, I find r=.282, p.000 but when I use the logged verions, I find r=.488, p=.000.

I don't understand why researchers sometimes use logged versions of their variables and why correlation seems so much higher if you do so. What is the reasoning here, and why is it OK to use logged variables?

Your help is greatly appreciated :-)

$\endgroup$
1

1 Answer 1

25
$\begingroup$

Reasons to use logged variables fall into two categories: Statistical and substantive.

Statistically, if your variables are right-skew (that is, they have a long tail at the high end) then a measure such as correlation or regression can be influenced a lot by one or a few cases at the high end on one or both variables (outliers, leverage points, influential points). Taking the log can help this by reducing or eliminating skew.

Substantively, some concepts are better thought of in terms of ratios than differences. Take the two volume measures you discuss. Now, compare two companies: One a small company trading on NASDAQ that few people have heard of, the other a mega-corporation. The former will get very few tweets per day. The latter will get many; similarly for trading volume. Suppose (just to pick numbers) that company A typically gets 100 tweets a day and the latter gets 100,000.

If company A's tweets go up from 100 to 500 (a difference of 400, a ratio of 5) that's huge news - something must be going on. But if company B's go up from 100,000 to 100,400 (a difference of 400, a ratio very close to 1) no one cares. The rough equivalent would be if it went from 100,000 to 500,000.

$\endgroup$
3
  • $\begingroup$ thank you for your quick reply. Two more questions come from your answer. First, if I have 3 properties for an object (stock tradingvolume, returns, and volatility) and take the logged version for one of them? What you say for company A and B tweets, might also count for their returns: if company A stock rises from 1 tot 1,50 then returns are (50%) 0.50. Company B needs an increase from 400 to 600 (200) for a similar %-return. And stemming from that: if returns are negative, LN(-0.50) obviously doesnt work. Is it then allowed to take -LN(0.50)? $\endgroup$
    – Pr0no
    Aug 2, 2012 at 11:48
  • $\begingroup$ Also, if I understand correctly, taking the logged variable isn't a free choice - it has to be argumented by skweness-charts (statistically)? And substantively is just more a logical reasoning for taking logged that actually provide proff for doing so? In other words, are there rules of thumb here, defining threshholds above which you should take logged version or is it a matter of interpretation? $\endgroup$
    – Pr0no
    Aug 2, 2012 at 11:53
  • 1
    $\begingroup$ You don't want to take logs of percentages in this case: Taking the percentage does what the log would do. That is, it makes things ratios. Certainly you can take the log of some variables and not others. Taking the log doesn't require skewness charts, but usually variables that ought to be logged are right-skew. But the main thing is substance. If it makes no substantive sense to take the log, then don't do it. Instead, use statistical methods that work with skewed variables. SUBSTANCE comes first. $\endgroup$
    – Peter Flom
    Aug 2, 2012 at 12:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.