Statistical - LOGNORM.INV Function

Description

The 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)

Arguments

Argument	Description	Required/ Optional
Probability	A probability associated with the lognormal distribution.	Required
Mean	The mean of ln(x)	Required
Standard_dev	The standard deviation of ln(x).	Required

Notes

If any argument is nonnumeric, LOGNORM.INV returns the #VALUE! error value.
If probability <= 0 or probability >= 1, LOGNORM.INV returns the #NUM! error value.
If standard_dev <= 0, LOGNORM.INV returns the #NUM! error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_statistical_functions.htm