Excel CHISQ.TEST Function

What is CHISQ.TEST function in Excel?

The CHISQ.TEST function is one of the Statistical functions of Excel.

It Returns the test for independence: the value from the chi-squared distribution for the statistic and the appropriate degrees of freedom.

We can find this function in Statistical category of the insert function Tab.

How to use CHISQ.TEST function in excel

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select CHISQ.TEST function.

6. Then select ok.

7. In the function arguments Tab you will see CHISQ.TEST function.

8. Actual_range is the range of data that contains observations to test against expected values.

9. Expected_range is the range of data that contains the ratio of the product of row totals and column totals to the grand total.

10. You will see the results in the formula result section.

Examples of CHISQ.TEST function in Excel

CHISQ.TEST related functions 

  • Use CHISQ.DIST function to return the left-tailed probability of the chi-squared distribution.
  • Use CHISQ.DIST.RT function to return the right-tailed probability of the chi-squared distribution.
  • Use CHISQ.INV function to return the inverse of the left-tailed probability of the chi-squared distribution.
  • Use CHISQ.INV.RT function to return the inverse of the right-tailed probability of the chi-squared distribution.

Leave a Reply

Your email address will not be published. Required fields are marked *