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
- Click on an empty cell (like F5).

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

3. In the insert function tab you will see all functions.
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.