Formulas and Functions
LOGINV
The LOGINV function returns the inverse of the log-normal cumulative distribution function of x. All arguments are number values.
LOGINV(probability, mean, stdev)
probability: The probability associated with the distribution. probability must be greater than 0 and less than 1.
mean: The mean of the natural logarithm, that is, ln(x). mean is the average (arithmetic mean) of ln(x), the natural logarithm of x.
stdev: The standard deviation of the population. stdev must be greater than 0.
Notes
LOGINV is appropriate where the logarithm of x is normally distributed.
Example |
---|
=LOGINV(0.78, 1.7, 2.2) returns 29.9289150377259. |
See alsoLNLOGNORMDIST