CHITEST Function Explained
The CHITEST Function in Microsoft Excel is used to calculate the test for independence of two categorical variables. It returns the chi-square test for independence, which is used to determine if there is a significant association between two categorical variables. The function takes three arguments: array1, array2, and tails. Array1 and array2 are the two data sets that are being compared, and tails is the number of distribution tails (1 or 2).
CHITEST Function Syntax
CHITEST(actual_range, expected_range)
- actual_range: The range of cells containing the observed data.
- expected_range: The range of cells containing the expected data.