CHITEST

Definition: CHITEST is a function that tests the independence of two sets of data.

Syntax: =CHITEST(actual_range, expected_range)

Situation: This formula is suitable when you need to test whether two sets of data are independent, such as testing whether gender and political affiliation are independent.

Example: If you have actual data in cells A1:A5 and expected data in cells B1:B5, the test can be performed using the formula =CHITEST(A1:A5, B1:B5), which returns a p-value indicating the probability of independence.