LOGINV function

Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x. Use the lognormal distribution to analyze logarithmically transformed data.

Syntax

LOGINV(probability,mean,standard_dev)

Probability     is a probability associated with the lognormal distribution.

Mean     is the mean of ln(x).

Standard_dev     is the standard deviation of ln(x).

Remarks

  • If any argument is nonnumeric, LOGINV returns the #VALUE! error value.

  • If probability < 0 or probability > 1, LOGINV returns the #NUM! error value.

  • If standard_dev <= 0, LOGINV returns the #NUM! error value.

  • The inverse of the lognormal distribution function is:

    Equation

Example

Probability

Mean

StdDev

Formula

Description (Result)

0.039084

3.5

1.2

=LOGINV([Probability], [Mean], [StdDev])

Inverse of the lognormal cumulative distribution function for the specified arguments (4.000028)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×