Documentation/Calc Functions/NORMINV

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

NORMINV

Category:

Statistical Analysis

Summary:

Returns the inverse of the normal cumulative distribution.

Syntax:

NORMINV(Number; Mean; StDev)

Returns:

Arguments:

Number represents the probability value used to determine the inverse normal distribution.

Mean represents the mean value in the normal distribution.

StDev represents the standard deviation of the normal distribution.

Additional details:

Examples:

=NORMINV(0.9;63;5) returns 69.41. If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than 69.41g grams.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: