CHISQ.DIST
The chi-squared distribution at a value, as a density or a cumulative probability.
Group: Statistics. Compatible with DAX.
Syntax
CHISQ.DIST ( <x>, <deg_freedom>, <cumulative> )| Parameter | Type | Description |
|---|---|---|
x | Number | The value, 0 or more. |
deg_freedom | Whole number | The degrees of freedom, 1 or more; rounded to a whole number. |
cumulative | Boolean | TRUE for the cumulative probability, the chance of a value up to x; FALSE for the density at x. |
Returns
Number. The chi-squared density at x, or the left-tail probability up to x.
Remarks
- A test's p-value is the right tail: use
CHISQ.DIST.RT, which is 1 minus the cumulative result here. - Degrees of freedom that are not whole are rounded to the nearest whole number: 2.5 counts as 3, as in Power BI.
- A blank x gives BLANK. A negative x, or fewer than 1 degree of freedom, is an error.
Examples
Density and left tail at 3.84
EVALUATE
ROW (
"Density", CHISQ.DIST ( 3.84, 1, FALSE ),
"Cumulative", CHISQ.DIST ( 3.84, 1, TRUE )
)| Density | Cumulative |
|---|---|
| 0.0298468874830606 | 0.949956478751295 |
Degrees of freedom are rounded
2.5 is rounded up to 3, so the first two columns agree.
EVALUATE
ROW (
"df 2.5", CHISQ.DIST ( 3, 2.5, TRUE ),
"df 3", CHISQ.DIST ( 3, 3, TRUE ),
"df 2", CHISQ.DIST ( 3, 2, TRUE )
)| df 2.5 | df 3 | df 2 |
|---|---|---|
| 0.608374823728911 | 0.608374823728911 | 0.77686983985157 |