CHISQTEST
Returns a measure of 'goodness of fit'.
Syntax:
CHISQTEST(observed, expected)
observed and expected are ranges or arrays of observed and expected values. They must have the same number of rows and columns and there must be at least 2 values in each.
CHISQTEST calculates the statistic and degrees of freedom, then calls CHISQDIST.
Example:
CHISQTEST({8,9,7,8}, {8,8,8,8})
returns approximately 0.969.
