How does the CHISQ.INV function (DAX) work?
The CHISQ.INV function (DAX) returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.INV Formula Syntax
How do you use the CHISQ.INV function?
The chi-squared distribution is commonly used to study variation in the percentage of something across samples, such as the fraction of the day people spend watching television.
Related Blog Posts
Related Support Forum Posts
Considerations when using the CHISQ.INV function
Things to remember about the CHISQ.INV Function.
If argument is nonnumeric, CHISQ.INV returns the #VALUE! error value.
If probability < 0 or probability > 1, CHISQ.INV returns the #NUM! error value.
If deg_freedom is not an integer, it is rounded.
If deg_freedom < 1 or deg_freedom > 10^10, CHISQ.INV returns the #NUM! error value.
Related Video Tutorials
Formula examples using the CHISQ.INV function
=CHISQ.INV( 0.5, 1 )
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.