Statistical - LOGNORM.INV Function
Advertisements
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
Advertisements