Formulas and functions > Functions from A to Z > LOGNORM.DIST (lognormal distribution)

Syntax:

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

Description:

Returns the probabilities of a (cumulative) log-normal distributed random number.

With this function you can view probability distributions in which not the random number itself but its natural logarithm is normally distributed.

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

Mean is the mean of LN(x).

StdDev is the standard deviation of LN(x). 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. In older versions, the function is unknown.

Annotation:

The inverse function is LOGNORM.INV