LOGINV
Description
Returns the inverse of the log-normal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard deviation.
Syntax
LOGINV(
probability
,
mean
,
standard_dev
)
- probability: The probability associated with the log-normal distribution.
- mean: The mean of ln(x).
- standard_dev: The standard deviation of ln(x).
Example
Formula | Result |
|---|---|
=LOGINV(0.039084, 3.5, 1.2) | 4.000025219 |
Notes
- This function does the same action as LOGNORM.INV() and LOGNORMINV().