LOGNORMDIST
Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.
Syntax
LOGNORMDIST(x,mean,standard_dev)
X is the value at which to evaluate the function.
Mean is the mean of ln(x).
Standard_dev is the standard deviation of ln(x).
Remarks
- If any argument is nonnumeric, LOGNORMDIST returns the #VALUE! error value.
- If x £ 0 or if standard_dev £ 0, LOGNORMDIST returns the #NUM! error value.
- The equation for the lognormal cumulative distribution function is:
Example
LOGNORMDIST(4,3.5,1.2)
equals 0.039084