CHIINV
Name
Inverse chi distribution
Description
Calculates the inverse of the one-tailed probability of the chi-squared distribution.
Syntax
CHIINV(prob,deg)
Remarks
This function has the following 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 Type
Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
CHIINV(B2,D7)
CHIINV(R5C2,R7C4)
CHIINV(0.75,4)=1.9225575262