The LOGINV function is one of the statistical functions. It is used to return the inverse of the lognormal cumulative distribution function of the given x value with the specified parameters.
Syntax
LOGINV(probability, mean, standard_dev)
The LOGINV function has the following arguments:
Argument | Description |
---|
probability | The probability associated with the lognormal distribution, a numeric value greater than 0 but less than 1. |
mean | The mean of ln(x), a numeric value. |
standard_dev | The standard deviation of ln(x), a numeric value greater than 0. |
Notes
How to apply the LOGINV function.
Examples
The figure below displays the result returned by the LOGINV function.
