Documentation/How Tos/Calc: CHISQINV function

CALC FUNCTIONS

FUNCTIONS

Measures of Central Tendency

Measures of dispersion / spread

Probability and statistics

Correlation and line fitting

See also (in the Array Function category); GROWTH, LINEST, LOGEST, TREND

Ranking

CHISQINV

Calculates the inverse of the CHISQDIST function.

CHISQINV(p; k)

k is the degrees of freedom for the χ²-distribution.

Constraint: k must be a positive integer

p is the given probability

Constraint: 0 ≤ p < 1

CHISQINV(p; k) returns the value x, such that CHISQDIST(x; k;TRUE()) = p.

CHISQINV(0.5; 9)

returns approximately 8.342832692

.

If you need CHISQINV(p;k) for a non interger parameter k, then use GAMMAINV(p;k/2;2) instead.

See Also