LOGINV
Syntax:
LOGINV ( probability , mean , standard-dev )
Description: Calculates the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard-dev.
Mathematical Formula:
Arguments:
Name |
Type |
Description |
---|---|---|
probability |
number |
A probability associated with the lognormal distribution. |
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
probability < 0 or probability > 1,
#NUM!
is returned.standard-dev ≤ 0,
#NUM!
is returned.
example: