Documentation/Calc Functions/LOGNORM.INV
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
LOGNORM.INV
Category:
Statistical Analysis
Summary:
Calculates the inverse of a probability value from the cumulative distribution function of a log-normal distribution.
A random variable [math]\displaystyle{ x }[/math] is log-normally distributed if [math]\displaystyle{ \text{log}(x) }[/math] is normally distributed. The log-normal distribution is a family of continuous probability distributions that are typically used to model positive, right-skewed data. The distribution has two characteristic parameters, usually denoted as mu (μ) and sigma (σ), that control its location and shape respectively. μ represents the mean value of the underlying normal distribution, while σ represents the standard deviation of the underlying normal distribution.
LOGNORM.INV calculates the value [math]\displaystyle{ x }[/math] such that [math]\displaystyle{ \text{LOGNORM.DIST}(x;\:\mu;\:\sigma;\:1)\:=\:p }[/math], where the given probability [math]\displaystyle{ p }[/math] lies in the range (0, 1).
Syntax:
LOGNORM.INV(Number[; Mean[; STDEV]])
Returns:
Returns a positive real number, which is the inverse of the given probability value from the cumulative distribution function for the given log-normal distribution.
Arguments:
Number is a real number in the range (0, 1), or a reference to a cell containing that number, which is a probability in the cumulative distribution function of the log-normal distribution.
Mean is a real number, or a reference to a cell containing that number, which is the value of the location parameter (μ) of the log-normal distribution. If omitted, the default value of 0 is utilized.
STDEV is a positive real number, or a reference to a cell containing that number, which is the value of the shape parameter (σ) of the log-normal distribution. If omitted, the default value of 1 is utilized.
- If any of Number, Mean, or STDEV is non-numeric, then LOGNORM.INV reports a #VALUE! error.
- If Number is outside the range (0, 1), then LOGNORM.INV reports an invalid argument error (Err:502).
- If STDEV is less than or equal to 0.0, then LOGNORM.INV reports an invalid argument error (Err:502).
Additional details:
- Calc's LOGINV and LOGNORM.INV functions perform the same calculations. The requirements for LOGINV are specified in ODF 1.2; LOGNORM.INV is provided for interoperability with Microsoft Excel.
- The following figure shows inverse cumulative distribution function probability plots for four sample log-normal distributions.
- The name space for LOGNORM.INV is
COM.MICROSOFT.LOGNORM.INV
. - For more information on the log-normal distribution, visit Wikipedia's Log-normal distribution page.
Examples:
Formula | Description | Returns |
---|---|---|
=LOGNORM.INV(A1; A2; A3) where cells A1:A3 contain the values 0.6, -0.5, and 1.5 respectively. | Here the argument values are passed by cell reference. Note that the formula =LOGNORM.DIST(LOGNORM.INV(A1; A2; A3); A2; A3; 1) returns 0.6, the same as the value in cell A1. |
0.886938755985172 |
=LOGNORM.INV(0.25) | Here the Mean and STDEV arguments are omitted and so take their default values of 0 and 1 respectively. Note that the formula =LOGNORM.INV(0.25; 0; 1) returns the same value. |
0.509416283863278 |
Related LibreOffice functions:
ODF standard:
None
Related (or similar) Excel functions:
LOGNORM.INV