Previously, we implemented the CHISQ.DIST Function. In this blog, we will learn another important function that is closely related is CHISQ.INV Function in Excel.

So let us begin.

**When to Use CHISQ.INV Function in Excel?**

The CHISQ.INV Function calculates the inverse of Left Tailed Probability of Chi Square Distribution. It calculates the result based on the specified value of cumulative probability and degree of freedom.

CHISQ.INV can be categorized under the Statistical Functions of Excel. It came into existence in Excel 2010 and cannot be used in earlier versions of Excel.

**Syntax and Arguments**

**=CHISQ.INV(probability,deg_freedom)**

The information regarding the inputs required by CHISQ.INV Function is stated below.

This is the specified value of left tailed probability or cumulative probability of the Probability Density Function. Its value must lie in the interval [0,1] because it is probability.*probability –*– This specifies the degree of freedom for Chi Square Distribution. It is an integral value lying between 1 and 10*deg_freedom*^{10}.

**Important Points Regarding CHISQ.INV Function **

Before we start implementing the formula, here we have some important notes about CHISQ.INV Function in Excel.

- CHISQ.INV Function is an updated version of CHINV Function. If you have excel 2007 or an earlier version of excel, then you would use CHINV Function.
- The function truncates the value after the decimal point for a nonintegral value of the
*deg_freedom*argument. - The CHISQ.INV function returns a #VALUE! error for any non-numerical value supplied as any of the function’s input.
- We would encounter a #NUM! the error probably when:
- The value of the
*probability*argument is less than zero or greater than 1. - The
*deg_freedom*argument does not lie in the interval [1,10^{10}]

- The value of the

**Example to Learn CHISQ.INV Function**

Here, we would plot a graph for Chi Squared Distribution when degrees of freedom = 3 by using the **CHI.DIST Function ( cumulative=FALSE )** .

We would now find the inverse of the left tailed probability of Chi Square distribution when degree of freedom = 3 and left tailed probability = 0.738

=CHISQ.INV(0.738,3)

As a result, we get the value of x as 4.

**Explanation – **We have supplied the *probability *and *deg_freedom* argument as 0.738 and 3 respectively. The function calculates the value of x for the specified arguments. This is represented through the shaded area under the curve in the graph of the Probability Density function of Chi-Square Distribution.

This brings us to the end of the blog.

Thank you for reading.