<< Click to Display Table of Contents >> LOGNORMDIST (log-normal distribution)

Note: LOGNORMDIST is supplemented by the new function LOGNORM.DIST with additional functionality, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

LOGNORMDIST(x, Mean, StdDev)

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). It must be > 0.

See also:

LOGNORM.DIST, LN, LOGNORM.INV/LOGINV, NORM.DIST/NORMDIST, NORM.S.DIST/NORMSDIST