| Line 10: |
Line 10: |
| | *which would be the expected under the assumption. The conditions of <math>\chi^2</math> test is | | *which would be the expected under the assumption. The conditions of <math>\chi^2</math> test is |
| | | | |
| − | 1.The table should be 2x2 or more than 2x2
| + | #The table should be 2x2 or more than 2x2 |
| − | 2.Each observations should not be dependent
| + | #Each observations should not be dependent |
| − | 3.All expected values should be 10 or greater.
| + | #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> | | <math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math> |
| Line 21: |
Line 21: |
| | *Oi-the observed value in the ith cell | | *Oi-the observed value in the ith cell |
| | *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 non-numeric
| + | #The x & df values are non-numeric |
| − | 2.The x value is negative or df value is not an integer
| + | #The x value is negative or df value is not an integer |
| − | 3. The df <1 or df>10^10
| + | #The df <1 or df>10^10 |
| − | 4.Here CHIDIST=P(X>x),where X is a <math>\chi^2</math> random variable.
| + | #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. |