Difference between revisions of "Manuals/calci/CHIDIST"

Revision as of 07:00, 12 November 2013

CHIDIST(x,df)

This function gives the one_tailed probability of the chi-squared distribution.
It is denoted by $\chi ^{2}$ distribution.Normally categorical data's may displayed in tables.
The $\chi ^{2}$ static used to compare the observed value in each table to the value
which would be the expected under the assumption. The conditions of $\chi ^{2}$ test is

The test statistic is: $\chi ^{2}=\sum {\frac {(Oi-Ei)^{2}}{Ei}}$ The degrees of freedom are: (r–1)(c–1)

Where:

Also this function will the result as Error when

@@ Line 10: / Line 10: @@
 *which would be the expected  under the assumption. The conditions of <math>\chi^2</math> test is
-.The table should be 2x2 or more than 2x2
+#The table should be 2x2 or more than 2x2
-.Each observations should not be dependent
+#Each observations should not be dependent
-.All expected values should be 10 or greater.
+#All expected values should be 10 or greater.
 The test statistic is:
 <math>\chi^2=\sum\frac{(Oi-Ei)^2}{Ei}</math>
@@ Line 21: / Line 21: @@
 *Oi-the observed value in the ith cell
 *Ei- the expected value in the ith cell
 Also this function will the result as Error when
-.The x & df values are non-numeric
+#The x & df values are non-numeric
-.The x value is negative or df value is not an integer
+#The x value is negative or df value is not an integer
-. The df <1 or df>10^10
+#The df <1 or df>10^10
-.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.