Documentation/Calc Functions/LOGNORM.INV

Function name:
LOGNORM.INV

Category:
Statistical Analysis

Summary:
Calculates the inverse of the cumulative distribution function for the log-normal distribution.

Syntax:
LOGNORM.INV(Number[; Mean[; StDev]])

Returns:
Returns a positive real number which is the inverse of the cumulative distribution function for the log-normal distribution.

Arguments:
Number is a real number between 0 and 1 or a reference to a cell containing that number which is the probability value for which the inverse log-normal distribution is to be calculated.

Mean is a real number or a reference to the cell containing that number which is the mean value of the log-normal distribution.

StDev is a positive real number or a reference to the cell containing that number which is the standard deviation of the log-normal distribution.


 * If Number is greater than or equal to 1 or less than or equal to 0 then the function returns an error value.
 * If StDev is negative or zero then the function returns an error value.
 * If any of the arguments passed is non-numeric or a reference to a cell containing that value then the function returns #VALUE! error.

Additional details:

 * It is such that if LOGNORM.DIST(x;m;s;TRUE) = p then LOGNORM.INV(p;m;s) = x.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/LOGINV LOGINV]

[[Special:MyLanguage/Documentation/Calc_Functions/LOGNORM.DIST LOGNORM.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/LOGNORMDIST LOGNORMDIST]

ODF standard:
None

Equivalent Excel functions:
LOGNORM.INV