CHISQ.INV.RT Function

The Excel CHISQ.INV.RT function is based on the Chi-square distribution and retrieves the right-tailed probabilitys inverse. It determines the Chi-square distributions critical value according to the likelihood and degree of freedom. This function is just opposite to the CHISQ.DIST.RT function. Research scholars employ this function for hypothesis testing and verify the outcome values with the expected values.

Compatibility

This advanced Excel function is compatible with the following versions of MS-Excel −

Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2024
Excel 2024 for Mac
Excel 2021
Excel 2021 for Mac
Excel 2019
Excel 2016

Syntax

The syntax of CHISQ.INV.RT function is as follows −

=CHISQ.INV.RT(probability,deg_freedom)

Arguments

You can use the following arguments with the CHISQ.INV.RT function −

Argument	Description	Required/Optional
Probability	A numeric value that is linked with Chi-square distribution.	Required
Deg_freedom	A numeric value denotes the degree of freedom.	Required

Points to Remember

If Deg_freedom argument contains a decimal value, it will be truncated.
If any of the arguments contain a value other than numeric, then the CHISQ.INV.RT function will retrieve the #VALUE! error value
If probability doesn’t lie between 0 and 1, the CHISQ.INV.RT function returns the #NUM! error.
If deg_freedom argument contains the non-positive value, then CHISQ.INV.RT function will return the #NUM! error.
An iterative search technique is used by this function. If the search has not been successful till 64 iterations, then the function will retrieve the #N/A error value.

Examples of CHISQ.INV.RT Function

Practice the following examples to learn the use of the CHISQ.INV.RT function in Excel.

Example 1

If deg_freedom argument contains a decimal value, it will be truncated.

Solution

Assume the sample dataset to compute the CHISQ.INV.RT function where the probability and deg_freedom values are 0.4 and 3.8 as specified in the C2 and C3 cells. Write the formula =CHISQ.INV.RT(C2,C3) in the C4 cell. Here, the deg_freedom value is 3.8, which is truncated to 3.

Therefore, the result is 2.9462.

Example 2

If probability doesnt lie between 0 and 1, the CHISQ.INV.RT function returns the #NUM! error.

Solution

You may rewrite the probability value to 2 in the C2 cell. Double-click on the C4 cell and enter the formula =CHISQ.INV.RT(C2,C3).

Therefore, the CHISQ.INV.RT function returns the #NUM! error as probability is larger than one.

Example 3

If deg_freedom argument contains the non-positive value, then CHISQ.INV.RT function will return the #NUM! error.

Solution

Whenever you enter the negative value in the deg_freedom argument, the CHISQ.INV.RT function yields an error. As you can observe in the screenshot, the deg_freedom value is -6, as depicted in the C3 cell. Double-click on the C4 cell and type the formula =CHISQ.INV.RT(C2,C3).

Once you hit the Enter tab, the CHISQ.INV.RT function will return the #NUM! error.

Download Practice Sheet

You can download and use the sample data sheet to practice the CHISQ.INV.RT function.

Save or share this article