Documentation/Calc Functions/LOGNORM.INV

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

LOGNORM.INV

Category:

Statistical Analysis

Summary:

Returns the inverse of the lognormal distribution.

Syntax:

LOGNORM.INV(Number; Mean; StDev)

Returns:

Arguments:

Number (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.

Mean (required) is the arithmetic mean of the standard logarithmic distribution.

StDev (required) is the standard deviation of the standard logarithmic distribution.

Additional details:

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

Examples:

=LOGNORM.INV(0.05;0;1) returns 0.1930408167.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: