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:
See Also BETADIST, BINOMDIST, CHIDIST, COMBIN, CRITBINOM, FDIST, GAMMADIST, GAMMAINV, LOGINV, NORMDIST, NORMSDIST, POISSON