LOGINV

Used only in ReliaSoft Workbooks

Description: Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with a specified mean and standard deviation. 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:

  • All arguments must be numerical.
  • Probability must be greater than or equal to 0 and less than or equal to 1.
  • Standard_dev must be greater than 0.
  • The inverse of the lognormal distribution function is:

Example:

  • LOGINV(0.039084, 3.5, 1.2) = 4.000014

Related Topics and Links