Difference between revisions of "Documentation/How Tos/Calc: NORMINV function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Example:)
(See also:)
Line 20: Line 20:
  
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 +
 +
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
 +
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]

Revision as of 14:04, 13 September 2008


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:

NORMDIST, NORMSDIST, NORMSINV

Statistical functions

Functions listed alphabetically, Functions listed by category

Personal tools