CHISQ.INV Function in Excel – Inverse Chi Square Distribution

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.

infographics CHISQ.INV Function in Excel

Syntax and Arguments


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

  • probability – 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.
  • deg_freedom – This specifies the degree of freedom for Chi Square Distribution. It is an integral value lying between 1 and 1010.

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,1010]

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 ) .

graph of chi square distribution

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

example of CHISQ.INV Function in excel

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.

example of CHISQ.INV Function in excel explanation

This brings us to the end of the blog.

Thank you for reading.

Leave a Comment