LOGNORMDIST
Syntax:
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 |
---|---|---|
x |
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: