CHISQ.TEST Function Explained
The CHISQ.TEST Function in Microsoft Excel is used to calculate the chi-squared statistic for a contingency table. It takes two arguments: an array of observed frequencies and an array of expected frequencies. The function returns the chi-squared statistic, the degrees of freedom, and the p-value.
CHISQ.TEST Function Syntax
CHISQ.TEST(actual_range, expected_range)
- actual_range: The range of cells containing the observed frequencies.
- expected_range: The range of cells containing the expected frequencies.