Definition of Log-Normal Distribution
A log-normal distribution is a statistical distribution of logarithmic values from a related normal distribution. A log-normal distribution can be translated to a normal distribution and vice versa using associated logarithmic calculations.
:max_bytes(150000):strip_icc()/dotdash_Final_Log_Normal_Distribution_Nov_2020-01-fa015519559f4b128fef786c51841fb9.jpg)
Understanding Normal and Lognormal
A normal distribution is a probability distribution of outcomes that is symmetrical or forms a bell curve. In a normal distribution 68% of the results fall within one standard deviation and 95% fall within two standard deviations.
While most people are familiar with a normal distribution, they may not be as familiar with log-normal distribution. A normal distribution can be converted to a log-normal distribution using logarithmic mathematics. That is primarily the basis as log-normal distributions can only come from a normally distributed set of random variables.
There can be a few reasons for using log-normal distributions in conjunction with normal distributions. In general, most log-normal distributions are the result of taking the natural log where the base is equal to e=2.718. However, the log-normal distribution can be scaled using a different base which affects the shape of the lognormal distribution.
Overall the log-normal distribution plots the log of random variables from a normal distribution curve. In general, the log is known as the exponent to which a base number must be raised in order to produce the random variable (x) that is found along a normally distributed curve.
Applications and Uses of Log-Normal Distribution in Finance
Normal distributions may present a few problems that log-normal distributions can solve. Mainly, normal distributions can allow for negative random variables while log-normal distributions include all positive variables.
One of the most common applications where log-normal distributions are used in finance is in the analysis of stock prices. The potential returns of a stock can be graphed in a normal distribution. The prices of the stock, however, can be graphed in a log-normal distribution. The log-normal distribution curve can therefore be used to help better identify the compound return that the stock can expect to achieve over a period of time.
Note that log-normal distributions are positively skewed with long right tails due to low mean values and high variances in the random variables.
Lognormal Distribution in Excel
Lognormal distribution can be done in Excel. It is found in the statistical functions as LOGNORM.DIST.
Excel defines it as the following:
LOGNORM.DIST (x,mean,standard_dev,cumulative)
Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
To calculate LOGNORM.DIST in Excel you will need the following:
x = value at which to evaluate the function
Mean = the mean of ln(x)
Standard Deviation = the standard deviation of ln(x) which must be positive