The `LOGNORMDIST` function in Excel is used to calculate the cumulative log-normal distribution of a given value. This function has been replaced with newer functions in more recent versions of Excel, such as `LOGNORM.DIST`, but you can still use `LOGNORMDIST` in versions of Excel that support it for compatibility.
Here’s how to use the `LOGNORMDIST` function:
Syntax
LOGNORMDIST(x, mean, standard_dev)
- x: The value at which to evaluate the function.
- mean: The mean of the natural logarithm of the distribution.
- standard_dev: The standard deviation of the natural logarithm of the distribution.
Example
Suppose you have a log-normally distributed random variable, and you want to find the probability that the random variable is less than or equal to 5. Assume the mean of the natural logarithm of the distribution is 1.5, and the standard deviation is 0.2.
You would enter the following formula in an Excel worksheet:
=LOGNORMDIST(5, 1.5, 0.2)
This function would return the cumulative probability that a log-normally distributed random variable with the given parameters is less than or equal to 5.
Notes
- Make sure that all arguments are numeric; otherwise, the function will return a `#VALUE!` error.
- `LOGNORMDIST` is useful in risk analysis and financial modeling.
- If you’re using Excel 2010 or later, consider using `LOGNORM.DIST` with the `cumulative` parameter set to TRUE for better accuracy and compatibility with newer Excel standards.
Transition to `LOGNORM.DIST`
In Excel 2010 and later, it is encouraged to use:
LOGNORM.DIST(x, mean, standard_dev, cumulative)
- cumulative: A logical value; use TRUE for the cumulative distribution function or FALSE for the probability density function.
The improved version offers more flexibility, including the ability to compute the probability density function when `cumulative` is set to FALSE.
By using these guidelines, you should be able to effectively apply the `LOGNORMDIST` function or its successor in your Excel calculations.
Unlock Your Potential
Excel
Access
Power BI
