Skip to main content

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:

ArgumentDescription
probabilityThe probability associated with the lognormal distribution, a numeric value greater than 0 but less than 1.
meanThe mean of ln(x), a numeric value.
standard_devThe 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