NORMINV function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 14:09, 2 February 2024 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



NORMINV

Calculates the inverse of the cumulative NORMDIST normal distribution function.

Syntax:

NORMINV(p; α; λ)

The normal distribution is a family of continuous probability distributions, with two controlling parameters α and λ.
NORMINV returns the value n, such that NORMDIST(n; α; λ; 1) is p.

Example:

NORMINV(0.92; 63; 5)

returns approximately 70.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_NORMINV_function&oldid=260057"
Views
Personal tools
Navigation
Tools