Apple iWork '09 - Manual (Page 241)

Chapter 10 Statistical Functions 241
Example
Given the following table:
=CHITEST(A2:B6,A9:B13) returns 5.91020074984668E-236.
Each expected value is computed by multiplying the sum of the row by the sum of the
column and dividing by the grand total. The formula for the first expected value (cell A9) is
=SUM(A$2:B$2)*SUM($A2:$A6)/SUM($A$2:$B$6). This formula can be extended to cell B9 and then
A9:B9 extended to A13:B13 to complete the expected values. The resulting formula for the final
expected value (cell B13) is =SUM(B$2:C$2)*SUM($A6:$A11)/SUM($A$2:$B$6).
Related Topics
For related functions and additional information, see:
“CHIDIST” on page 239
“CHIINV” on page 239
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41