How does the CHISQ.INV.RT function (DAX) work?

The CHISQ.INV.RT function (DAX) returns the inverse of the right-tailed probability of the chi-squared distribution.

CHISQ.INV.RT Formula Syntax


How do you use the CHISQ.INV.RT function?

If probability = CHISQ.DIST.RT(x,…), then CHISQ.INV.RT(probability,…) = x. Use this function to compare observed results with expected ones in order to decide whether your original hypothesis is valid.

Related Blog Posts

Related Support Forum Posts

Understanding DAX Formula
Developing Complex Dax functions

Considerations when using the CHISQ.INV.RT function

If either argument is nonnumeric, CHISQ.INV.RT returns the #VALUE! error value.

If probability < 0 or probability > 1, CHISQ.INV.RT returns the #NUM! error value.

If deg_freedom is not an integer, it is rounded.

If deg_freedom < 1, CHISQ.INV.RT returns the #NUM! error value.

Related Video Tutorials

Formula examples using the CHISQ.INV.RT function

=CHISQ.INV.RT( 0.1, 2 )

=CHISQ.INV.RT( 0.5, 1 )

=CHISQ.INV.RT( 0.75, 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.