0
$\begingroup$

My datasets histogram is the following:

enter image description here

It contains a lot of zeros, that is why the high bar around zero. How can I transform this to a normal distribution? My problem is that the high bar coming from the zeros will not vanish after applying the usually suggested log transformation, and neither the reciprocal transformation helps, as in that case the high bar will be at 1.

Thanks in advance!

$\endgroup$
3
  • $\begingroup$ "It has a lot of zeroes" --- then you can't transform it to be approximately normal. e.g. See stats.stackexchange.com/questions/222167/… and stats.stackexchange.com/questions/124059/… $\endgroup$
    – Glen_b
    Commented Jul 21, 2019 at 15:37
  • $\begingroup$ Thanks Glen_b! You are so right. Now I see, that this is obvious. Does this mean, that using this feature in a linear model is not a good idea, as its distribution is far away from normal? $\endgroup$
    – bayerb
    Commented Jul 22, 2019 at 9:09
  • $\begingroup$ There's really no need for predictors (features) in a linear model to be normally distributed and trying to make them so may well ruin a previously linear relationship. (A number of answers and comments one site discuss this, too) $\endgroup$
    – Glen_b
    Commented Jul 22, 2019 at 23:52

0

Browse other questions tagged or ask your own question.