<< Click to Display Table of Contents >> 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
See also:
LOGNORMDIST, LN, LOGNORM.INV/LOGINV, NORM.DIST/NORMDIST, NORM.S.DIST/NORMSDIST