CHIINV Function

One of Excel's most crucial statistical functions is CHIINV, which assists statisticians in deciding whether to accept or reject a null hypothesis. The function returns the inverse of the chi-squared distributions right-tailed probability. You may seamlessly identify the Chi-squared distributions critical value, which is further contrasted with the Chi-squared (X^2) test.

The Excel-CHIINV function is used in various tests, such as Hypothesis testing, Goodness of Fit, and Chi-Squared. In Excel 2010, the CHIINV function interchanges with the CHISQ.INV.RT function.

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 2021
Excel 2021 for Mac
Excel 2019
Excel 2019 for Mac
Excel 2016
Excel 2013
Excel 2011 for Mac
Excel 2007
Excel 2003
Excel 2000

Syntax

The syntax of CHIINV function is as follows −

CHIINV (probability,deg_freedom)

Arguments

You can use the following arguments with the CHIINV function −

Argument	Description	Required / Optional
Probability	It specifies the probability linked with the chi-squared distribution.	Required
Deg_freedom	The number of degrees of freedom.	Required

Points to Remember

The CHIINV function retrieves the error named #VALUE! for the non-numeric arguments.
This function retrieves the #NUM! Error if the p-value is less than zero or the p-value is greater than 1. Here, p denotes the probability.
The CHIINV function retrieves the #NUM! if the second argument, deg_freedom, contains a negative value.
The CHIINV function retrieves the #NUM! if the second argument, deg_freedom, is equal to 10^10.
It generally employs an iterative search algorithm; the CHINV function iterates to get the accurate result with the tolerance level &pm;3×10^-7.

Examples of CHIINV Function

Practice the following examples to learn the use of the CHIINV function in Excel.

Example 1

Consider the sample dataset where you need to enter the text Probability, Deg of Freedom, and Chi-Square Function separately in the range B2:B4 cells and enter their corresponding values in the C3 and C4 cells. Now, you may enter the formula =CHINV(C3,C4) in the C5 cell and press the Enter tab.

Therefore, the Chi-square value is 1.869168.

Example 2

The CHIINV function retrieves the error named #VALUE! for the non-numeric arguments.

Solution

Lets suppose that you enter the CHIINV formula =CHIINV("Harry",3) in the C8 cell and press the Enter tab.

As you can notice in the above screenshot, the probability you entered is text, which is prohibited.

Make sure that both arguments in the CHIINV function must be numeric; otherwise, #VALUE! error will come.

Example 3

This function retrieves the #NUM! Error if the p-value is less than zero or the p-value is greater than 1. Here, p denotes the probability.

Solution

Enter the formula =CHINV(6,3) in the C9 cell and press the Enter tab.

Here, you see, the #NUM! error while executing the CHIINV function because the probability is greater than 1.

Make sure that the probability that you entered inside the CHIINV function lies between 0 and 1, or else an error may occur.

Example 4

The CHIINV function retrieves the #NUM! if the second argument, deg_freedom, contains a negative value.

Solution

You can enter the formula =CHIINV(0.03,-4) in the C10 cell.

Example 5

The CHIINV function retrieves the #NUM! if the second argument, deg_freedom, is equal to 10^10.

Solution

Write the CHIINV formula =CHIINV(0.012,10^10) in the C11 cell and then press the Enter tab to obtain the result.

Save or share this article