LOGINV

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

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:

    Cc767588.ZA060511781033(en-us,TechNet.10).gif

Example

Probablility

Mean

StdDev

Formula

Description (Result)

0.039084

3.5

1.2

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

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

Show: