The ranges R1 and R2 must have the same size and shape and can only contain numeric values.įor versions of Excel prior to Excel 2010, the CHISQ.TEST function doesn’t exist. 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). ![]() In these cases df = (row count – 1) (column count – 1).Įxcel Function: The CHISQ.TEST function described in Goodness of Fit can be extended to support ranges consisting of multiple rows and columns. Such data are organized in what are called contingency tables, as described in Example 1. ![]() The method described in Goodness of Fit can also be used to determine whether two sets of data are independent of each other.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |