Returns the test for independence. CHISQ.TEST returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom. You can use χ2 tests to determine whether hypothesized results are verified by an experiment.
| Excel version | Available |
|---|---|
| Excel 2007 | ✓ |
| Excel 2013 | ✓ |
| Excel 2019 | ✓ |
| Excel 2021 | ✓ |
| Microsoft 365 | ✓ |