LOGNORMDIST ( x , mean , standard-dev )
Description: Calculates the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard-dev.
Mathematical Formula:
Arguments:
|
Name |
Type |
Description |
|
number |
The value at which to evaluate the function. | |
|
mean |
number |
The mean of ln(x). |
|
standard-dev |
number |
The standard deviation of ln(x). |
Return Type and Value: number – The inverse of the lognormal cumulative distribution function of x.
However, if
• x ≤ 0, #NUM! is returned.
• standard-dev ≤ 0, #NUM! is returned.
[Example:
LOGNORMDIST(4,3.5,1.2) results in 0.039083556
end example]