CHISQ.INV.RT
The value whose chi-squared right-tail probability is the one given.
Group: Statistics. Compatible with DAX.
Syntax
CHISQ.INV.RT ( <probability>, <deg_freedom> )| Parameter | Type | Description |
|---|---|---|
probability | Number | The right-tail probability: above 0, at most 1. |
deg_freedom | Whole number | The degrees of freedom, 1 or more; rounded to a whole number. |
Returns
Number. The x above which the chi-squared distribution holds the given probability: a test's critical value.
Remarks
- A statistic above
CHISQ.INV.RT ( 0.05, df )is significant at the 5 % level. - A probability of 1 gives 0; one of 0 or less, or above 1, is an error.
Examples
Critical values at 5 %
EVALUATE
ROW ( "1 df", CHISQ.INV.RT ( 0.05, 1 ), "5 df", CHISQ.INV.RT ( 0.05, 5 ) )| 1 df | 5 df |
|---|---|
| 3.84145882069413 | 11.0704976935164 |
Three confidence levels, 3 degrees of freedom
EVALUATE
VAR Wanted = DATATABLE ( "Confidence", DOUBLE, { { 0.90 }, { 0.95 }, { 0.99 } } )
RETURN
ADDCOLUMNS ( Wanted, "Critical value", CHISQ.INV.RT ( 1 - [Confidence], 3 ) )| Confidence | Critical value |
|---|---|
| 0.9 | 6.25138863117033 |
| 0.95 | 7.81472790325118 |
| 0.99 | 11.3448667301444 |