CHISQINV 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
CHISQINV
Calculates the inverse of the CHISQDIST function.
Syntax
CHISQINV(p; k)
- k is the degrees of freedom for the χ2-distribution.
- Constraint: k must be a positive integer
- p is the given probability
- Constraint: 0 ≤ p < 1
Semantic
- CHISQINV(p; k) returns the value x, such that CHISQDIST(x; k;TRUE()) = p.
Example
CHISQINV(0.5; 9)
- returns approximately 8.342832692.
Remarks
If you need CHISQINV(p;k) for a non-integer parameter k, then use GAMMAINV(p;k/2;2) instead.
See Also
