- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Compatibility - LOGINV Function
The LOGINV function replaces the LOGNORM.INV function in Excel 2010.
Description
The 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 = LOGNORMDIST(x,...), then LOGINV(p,...) = x
Use the lognormal distribution to analyze logarithmically transformed data.
Syntax
LOGINV (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
The inverse of the lognormal distribution function is −
$$LOGINV(p,\mu,\sigma )=e^{[\mu + \sigma x(NORMSINV(p))]}$$
If any argument is nonnumeric, LOGINV returns the #VALUE! error value.
If probability <= 0 or probability >= 1, LOGINV returns the #NUM! error value.
If standard_dev <= 0, LOGINV returns the #NUM! error value.
Example
advanced_excel_compatibility_functions.htm
Advertisements