CHISQ.INV
The value whose chi-squared left-tail probability is the one given.
Group: Statistics. Compatible with DAX.
Syntax
CHISQ.INV ( <probability>, <deg_freedom> )| Parameter | Type | Description |
|---|---|---|
probability | Number | The left-tail probability: from 0 up to, but not including, 1. |
deg_freedom | Whole number | The degrees of freedom, 1 or more; rounded to a whole number. |
Returns
Number. The x below which the chi-squared distribution holds the given probability.
Remarks
- It is the inverse of
CHISQ.DIST( x, deg_freedom, TRUE ). CHISQ.INV ( 0.95, df )andCHISQ.INV.RT ( 0.05, df )give the same critical value.- A probability of 0 gives 0, and a blank one BLANK; a probability of 1 or more, or below 0, is an error.
Examples
The 95 % point
EVALUATE
ROW ( "1 df", CHISQ.INV ( 0.95, 1 ), "5 df", CHISQ.INV ( 0.95, 5 ) )| 1 df | 5 df |
|---|---|
| 3.84145882069412 | 11.0704976935163 |
Zero and blank
EVALUATE
ROW ( "Zero", CHISQ.INV ( 0, 3 ), "Blank", CHISQ.INV ( BLANK (), 3 ) )| Zero | Blank |
|---|---|
| 0 | (blank) |