LOGNORMDIST


Description Computes the cumulative lognormal distribution for x, where the logarithm of x is normally distributed.

Syntax LOGNORMDIST (x, mean, st_dev)

Argument Description
x The value at which you want to evaluate the function. It must be greater than or equal to 0.
mean The arithmetic mean of the logarithm of x.
st_dev The standard deviation of the logarithm of x.

Remarks LOGNORMDIST assumes the logarithm of x is normally distributed, meaning that, if you graph the distribution with a logarithmic X axis, the bell-shaped curve will appear.

Equation

Example This function returns 0.2232:

LOGNORMDIST(16,18,20)

See Also BETADIST, BINOMDIST, CHIDIST, COMBIN, CRITBINOM, FDIST, GAMMADIST, GAMMAINV, LOGINV, NORMDIST, NORMSDIST, POISSON