Performs a -test.
Syntax
CHISQUARE(ValueColumn a, ValueColumn b)
Input
ValueColumn a | is the observed frequency |
Domain type: | any Value domain |
ValueColumn b | is the expected frequency |
Domain type: | any Value domain |
Output
CHISQUARE returns: | a value |
Domain: | system domain Value |
Notes:
Tip:
When the definition symbol = is used, a dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output column has been calculated.
Usable in
Examples
TabCalc example:
If a fair die is cast 96 times, the expected number of times that each number of pips is observed is 96/6=16.
Die_nr |
Expected |
Observed |
CHI2 |
1 |
16 |
14 |
5.500 |
2 |
16 |
19 |
5.500 |
3 |
16 |
11 |
5.500 |
4 |
16 |
21 |
5.500 |
5 |
16 |
12 |
5.500 |
6 |
16 |
19 |
5.500 |
If we observe 14 ones, 19 twos, 11 threes, 21 fours, 12 fives, and 19 sixes then:
CHI2=CHISQUARE(Observed, Expected) |
is 5.500 |
The degree of freedom is 6-1=5 and this is not significant at the 5 percent level. The hypothesis that the die is fair is not rejected.
See also:
CNT | STDERR | ||
AVG | |||
STD | Column Statistics | ||
STDEV | COVAR |