DAX Statistical - CHISQ.DIST function
Description
Returns the chi-squared distribution.
DAX CHISQ.DIST function is new in Excel 2016.
Syntax
CHISQ.DIST (x, deg_freedom, cumulative)
Parameters
Sr.No. | Term & Definition |
---|---|
1 |
x The value at which you want to evaluate the distribution. |
2 |
deg_freedom The number of degrees of freedom. |
3 |
cumulative A logical value that determines the form of the function. TRUE: CHISQ.DIST returns the cumulative distribution function. FALSE: CHISQ.DIST returns the probability density function. |
Return Value
The chi-squared distribution.
Remarks
If deg_freedom is not an integer, it is rounded to the nearest integer.
If any of the parameters – x, deg_freedom is nonnumeric, CHISQ.DIST returns an error value.
If any of the parameters – x, deg_freedom is negative, CHISQ.DIST returns an error value.
Example
= CHISQ.DIST(0.5,1, TRUE ()) returns 0.520499877813047.