LOGINV Function

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.

LOGINV Function