Changes

*It is denoted by  <math>\chi^2</math> distribution.Normally categorical data's may displayed in tables.  

*It is denoted by  <math>\chi^2</math> distribution.Normally categorical data's may displayed in tables.  

*The <math>\chi^2</math> static used to compare the observed value in each table to the value  

*The <math>\chi^2</math> static used to compare the observed value in each table to the value  

*which would be the expected  under the assumption. The conditions of X^2 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

1.The table should be 2x2 or more than 2x2

<math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math>

<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

*c = No. of columns

Where:

Where:

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

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 <1 or df>10^10

4.Here  CHIDIST=P(X>x),where X is a <math>\chi^2</math> 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.

*CHIDIST(2,-1)=Error, because df<1

*CHIDIST(2,-1)=Error, because df<1