Formulas and functions > Functions from A to Z > LOGNORM.DIST (log-normal distribution)

Syntax:

LOGNORM.DIST(x, Mean, StdDev, Cumulative)

Description:

This returns the probabilities of a (cumulative) log-normally distributed random number.

You can use this function to view probability distributions in which the natural logarithm is normally distributed rather than the random variable itself.

x is the value to be evaluated. x must be > 0.

Mean is the mean of LN(x).

StdDev is the standard deviation of LN(x). StdDev must be > 0.

Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative normal distribution function is calculated. By entering the value FALSE, the normal probability density function is calculated.

Note:

The LOGNORM.DIST function supplements the previous LOGNORMDIST function with the additional argument Cumulative.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. The function is unknown in older versions.

Additional info:

The inverse function is LOGNORM.INV