DAX Function Guide

CHISQ.INV
Empty image or helper icon

Sam McKay

CEO & Founder

How does the CHISQ.INV work?
The CHISQ.INV function (DAX) returns the inverse of the left-tailed probability of the chi-squared distribution.
CHISQ.INV Formula Syntax

CHISQ.INV(
     probability,deg_freedom
)

How do you use the CHISQ.INV?

This function is used to study the variations in the percentage of a data across samples.

Related Blog Posts

Loading

Considerations when using the CHISQ.INV?

If the argument is nonnumeric in nature, the CHISQ.INV function will return a #VALUE! Error message. If probability < 0 or probability > 1, CHISQ.INV will return a #NUM! error value.  

If the 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

Loading

Formula examples using the CHISQ.INV

=CHISQ.INV(0.93,1)

=CHISQ.INV(0.6,2)

=CHISQ.INV( 0.5, 1 )

Related Courses

Loading