Hello,
We have calculated the ChiSquare value of two columns, one of them observed and the
other expected. We are comparing sample sizes for individual percentiles.
Here is an example of the columns:
19
27.12
77
27.12
117
27.12
89
27.12
103
27.12
102
27.12
107
27.12
109
27.12
91
27.12
538
27.12
732
406.8
357
678
144
678
44
406.8
6
27.12
7
27.12
7
27.12
9
27.12
5
27.12
7
27.12
7
27.12
3
27.12
7
27.12
Using the formula for ChiSquare
(o-e)*(o-e))/e
I get this column for the chisquare:
2.431209
91.74094
297.8766
141.1923
212.3073
206.7483
235.2808
247.21
150.4666
9623.834
259.9681
151.9779
420.5841
323.5591
16.44743
14.92678
14.92678
12.10673
18.04183
14.92678
14.92678
21.45186
14.92678
However, I cannot seem to get this calculated in SigmaPlot 12
I have to create a 2x2 contigency table.
For the first row in the above, 19 is the observed and 27 is the expected.
So a chi-square that is calculated in SigmaPlot is 0.0448, which is clearly
not 2.43.
How do I get the chiSquare values to be calculated correctly in SigmaPlot 12
We have calculated the ChiSquare value of two columns, one of them observed and the
other expected. We are comparing sample sizes for individual percentiles.
Here is an example of the columns:
19
27.12
77
27.12
117
27.12
89
27.12
103
27.12
102
27.12
107
27.12
109
27.12
91
27.12
538
27.12
732
406.8
357
678
144
678
44
406.8
6
27.12
7
27.12
7
27.12
9
27.12
5
27.12
7
27.12
7
27.12
3
27.12
7
27.12
Using the formula for ChiSquare
I get this column for the chisquare:
2.431209
91.74094
297.8766
141.1923
212.3073
206.7483
235.2808
247.21
150.4666
9623.834
259.9681
151.9779
420.5841
323.5591
16.44743
14.92678
14.92678
12.10673
18.04183
14.92678
14.92678
21.45186
14.92678
However, I cannot seem to get this calculated in SigmaPlot 12
I have to create a 2x2 contigency table.
For the first row in the above, 19 is the observed and 27 is the expected.
So a chi-square that is calculated in SigmaPlot is 0.0448, which is clearly
not 2.43.
How do I get the chiSquare values to be calculated correctly in SigmaPlot 12