CHIINV function
From Apache OpenOffice Wiki
< Documentation | How Tos
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
CHIINV
Calculates the inverse of the CHIDIST function.
Syntax:
CHIINV(p; k)
- k is the (positive integer) degrees of freedom for the χ2-distribution.
- CHIINV(p; k) returns the value x, such that CHIDIST(x; k) is p.
Example:
CHIINV(0.5724; 3)
- returns approximately 2.
Issues:
- The international standard ODFF calls this function LEGACY.CHIINV, and defines a new CHISQINV function.
See Also
