LEGACY.CHITEST

3.) LEGACY.CHITEST
> Note: Applications usually describe the CHITEST function as a
> Chi-square independence test. From a mathematical point of view this
> is not correct, as that would not involve testing some actual data
> against a set of expected values. It resembles more a Goodness-for-Fit
> test, but how the degree of freedom is calculated actually doesn't
> make sense then. This is specified to be inter operable with Excel and
> OpenOffice.org. Gnumeric gets different results if the number of rows
> and columns both are greater than 2.

Well, I suggest comparing the results with the FISHER-EXACT test, e.g. in R.

Also, every statistical package (R, EPI INFO, SPSS, ...) do NOT need the
expected values, as they compute them automatically from the n*m table.
I wonder why spreadsheets do NOT do it automatically, as well. Most
users simply fail to compute the correct value. Well, I try to teach
them, but almost everyone will get it wrong a week later. [It is way
easier to remember the shortcut for a 2x2 table, aka (ad-bc)^2 * N/(n1 *
n2 * n3 * n4), where n1-4 are the 4 subtotals, then compute accurately
the expected values.]