Cross Validated is a question and answer site for people interested in statistics, machine learning, data analysis, data mining, and data visualization. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Possible Duplicate:
How should I transform non-negative data including zeros?

I have a question:

Suppose we have a data point $(0,10)$. We then convert to a log scale. Excel gets rid of this data point since the minimum x-value is $1$. How do we keep this data point?

Edit. Can't you change the x-coordinate to $1$? So instead we have $(1,10)$ instead of $(0,10)$. The rest of the values are not changed.

share|improve this question

marked as duplicate by Peter Flom, gung, Andy W, whuber Oct 11 '12 at 14:27

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

You can't take the log of 0, so you can't keep that data point if you want to take logs. – Peter Flom Oct 11 '12 at 13:12
This Q will also be helpful for you: How small a quantity should be added to x to avoid taking the log of zero. – gung Oct 11 '12 at 13:20

The convention is to add a small constant to all values in a vector before taking the log, whether it's base-10 or base-e. So you might use, e.g., log(x+1) or log(x+.001), depending on which would have the least effect given the range of values you're dealing with.

share|improve this answer
@ronaldo2: Can't you just change the x-coordinate to 1? – Rhubarb Joker Oct 11 '12 at 13:35

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