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.






 
Created with Zapof