This function calculates the inverse of the right-tailed probability of the chi-squared distribution.
CHISQ.INV.RT(prob,deg)
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 |
The #VALUE! error value is returned if either argument is nonnumeric.
Accepts numeric data for both arguments. Returns numeric data.
CHISQ.INV.RT(B5,D7)
CHISQ.INV.RT(R5C2,R7C4)
CHISQ.INV.RT(0.75,4) gives the result 1.9225575262293264
This function is available in Spread for Windows Forms 11.0 or later.