Chi | pearson's chi square excel
ThemethoddescribedinGoodnessofFit[1] canalsobeusedtodeterminewhethertwosetsofdataareindependentofeachother.Suchdataareorganizedinwhatarecalledcontingencytables,asdescribedinExample1.Inthesecasesdf=(rowcount–1)(columncount–1).ExcelFunction:TheCHISQ.TESTfunctiondescribedinGoodnessofFit[2]canbeextendedtosupportranges consistingofmultiplerowsandcolumns.For R1=thearrayofobserveddataandR2=thearrayofexpectedvalues,wehaveCHISQ.TEST(R1,R2)=CHISQ.DIST(x,df)where xiscalculatedfromR1andR2asinDefinition2...
The method described in Goodness of Fit[1] can also be used to determine whether two sets of data are independent of each other. Such data are organized in what are called contingency tables, as described in Example 1. In these cases df = (row count – 1) (column count – 1).
Excel Function: The CHISQ.TEST function described in Goodness of Fit[2] can be extended to support ranges consisting of multiple rows and columns. For R1 = the array of observed data and R2 = the array of expected values, we have
CHISQ.TEST(R1, R2) = CHISQ.DIST(x, df) where x is calculated from R1 and R2 as in Definition 2 of Goodness of Fit[3] and df = (row count – 1) (column count – 1).
The ranges R1 and R2 must have the same size and shape and can only contain numeric values.
For versions of Excel prior to Excel 2010, the CHISQ.TEST function doesn’t exist. Instead you need to use the equivalent function, CHITEST.
Example 1: A survey is conducted of 175 young adults who...