Documentation/Calc Functions/LOGNORM.INV

From The Document Foundation Wiki
Jump to navigation Jump to search


Function name:

LOGNORM.INV

Category:

Statistical Analysis

Summary:

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

Im-jabber.svg

Note:
This function is identical to LOGINV and was introduced for interoperability with other office suites.

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.

Examples:

Formula Description Returns
=LOGNORM.INV(0.05;-0.5;1.5) The function calculates the inverse of the cumulative distribution function for the log-normal distribution.Here we can check that LOGNORM.DIST(0.051443022632501;-0.5;1.5;TRUE()) gives 0.05. 0.051443022632501
=LOGNORM.INV(1;-0.5;1.5) The function returns an error value since the Number is greater than or equal to 1. Err:502
=LOGNORM.INV(-0.5;-0.5;1.5) The function returns an error value since the Number is less than or equal to 0. Err:502

Related LibreOffice functions:

LOGINV

LOGNORM.DIST

LOGNORMDIST

ODF standard:

None

Equivalent Excel functions:

LOGNORM.INV