writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 14:
Line 14: − X^2=summation(Oi-Ei)^2/Ei+ Line 21:
Line 21: − + − +
Manuals/calci/CHIDIST (view source)
Revision as of 12:55, 12 November 2013
, 12:55, 12 November 2013→Description
3.All expected values should be 10 or greater.
3.All expected values should be 10 or greater.
The test statistic is:
The test statistic is:
<math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math>
The degrees of freedom are: (r–1)(c–1)
The degrees of freedom are: (r–1)(c–1)
r =No. of rows and c = No. of columns
r =No. of rows and c = No. of columns
Ei- the expected value in the ith cell
Ei- the expected value in the ith cell
Also this function will the result as Error when
Also this function will the result as Error when
1.The x&df values are nonnumeric
1.The x&df values are non-numeric
2.The x value is negative or df value is not an integer
2.The x value is negative or df value is not an integer
3. The df <1or df>10^10
3. The df <1or df>10^10
4.Here CHIDIST=P(X>x),where X is a X^2 random variable.
4.Here CHIDIST=P(X>x),where X is a <math>\chi^2</math> random variable.
*CHIDIST(-2,1)=Error,because x is negative.
*CHIDIST(-2,1)=Error,because x is negative.