ChiInv() returns the inverse of the one-tailed probability of the chi2 distribution.
Syntax:
CHIINV(prob, degrees_freedom)
Return data type: number
Arguments:
| Argument | Description |
|---|---|
| prob | A probability associated with the chi2 distribution. It must be a number between 0 and 1. |
| degrees_freedom | An integer stating the number of degrees of freedom. |
This function is related
to the ChiDist
function in the following way:
If prob = CHIDIST(value,df),
then CHIINV(prob, df) = value
Limitations:
All arguments must be numeric, else NULL will be returned.