LOGNORM.INV 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 = LOGNORM.DIST(x,...) then LOGNORM.INV(p,...) = x.

Use the lognormal distribution to analyze logarithmically transformed data.

Syntax

LOGNORM.INV(probability,mean,standard_dev)

Argument	Description	Remarks
probability	A probability associated with the lognormal distribution.	If this argument is equal to or less than zero, this function returns the #NUM! error value. If this argument is equal to or greater than 1, this function returns the #NUM! error value. If this argument is nonnumeric, this function returns the #VALUE! error value.
mean	A mean of ln(x).	If this argument is nonnumeric, this function returns the #VALUE! error value.
standard_dev	The standard deviation of ln(x).	If this argument is equal to or less than zero, this function returns the #NUM! error value. If this argument is nonnumeric, this function returns the #VALUE! error value.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

A	B
Data	Description
0.039084	Probability that is associated with the lognormal distribution
3.5	Mean of ln(x)
1.2	Standard deviation of ln(x)
Formula	Description (Result)
=LOGNORM.INV(A2,A3,A4)	Inverse of the lognormal cumulative distribution function for the terms in the table (4.000025)

See also
EXP function
LN function
LOG function
LOG10 function
LOGNORM.DIST function
List of all functions (by category)

Share your feedback about this topic

Rate this content: