Formulas and Functions
Modifying this control will update this page automatically

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
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.