This function calculates the inverse of the one-tailed probability of the chi-squared distribution.
Syntax
CHIINV(prob,deg)
Arguments
This function has these arguments:
| Argument | Description |
|---|---|
| prob | Probability of the chi-squared distribution |
| deg | Number of degrees of freedom; if not an integer, the number is truncated |
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
CHIINV(B5,D7)
CHIINV(R5C2,R7C4)
CHIINV(0.75,4) gives the result 1.9225575262
Version Available
This function is available in product version 1.0 or later.
See Also
CHIDIST | CHITEST | Statistical Functions