Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

LOGINV

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