Hi everyone, I tried to transform the exponentially distributed data from you excel file "Daily Views.xlsx" to a Normal one by taking ln of the variable "Daily Views" but the resultant distrbution is completely different to a Normal distribution. Basically the result is the linearized distribution but not a normal one. Why is this? Is there another way to do this trasformation? Did I do something wrong? Thanks.

Thanks a lot, Hristina. I perfectly understand your explanation, threfore I would like to know if the follwing picture gotten from the video explaining the exponential distribition is right or wrong. If I do not understand wrongly the picture shows that taking ln of a exponential distribution the resultant variable is normally distributed, but you just told me that this is not the case so could you please show me where am I getting lost? Thanks, Alberto.

Hey Alberto, Thank you for your question! An exponential function has the form (omitting any constants): By taking the natural logarithm of this function, you transform it as follows: The function y = x is a straight line. That is why the plot you get is transformed from an exponential to a line. Unfortunately, I am not aware of a transformation that maps an exponential distribution to a normal one. Hope this helps! Kind regards, 365 Hristina