For R1 = the array of observed data and R2 = the array of expected values, we haveĬHISQ.TEST(R1, R2) = CHISQ.DIST( x, df) where x is calculated from R1 and R2 as in Definition 2 of Goodness of Fit and df = (row count – 1) (column count – 1). Excel worksheet functionĮxcel Function: The CHISQ.TEST function described in Goodness of Fit can be extended to support ranges consisting of multiple rows and columns. In these cases df = (row count – 1) (column count – 1). Such data are organized in what are called contingency tables, as described in Example 1.
We can use the method described in Goodness of Fit to determine whether two sets of data are independent of each other.
