Difference between revisions of "Manuals/calci/CHITEST"

Revision as of 22:42, 26 November 2013

CHITEST(ar,er)

$ar$ is the array of observed values
$er$ is the array of expected values

Description

This function gives the the value from the chi-squared distribution and the appropriate degrees of freedom. i.e it calculates $\chi ^{2}$ statistic and degrees of freedom, then calls CHIDIST.

The conditions of $\chi ^{2}$ test is

The table should be 2x2 or more than 2x2
Each observations should not be dependent
All expected values should be 10 or greater. 
Each cell has an expected frequency of at least five.

The $\chi ^{2}$ test first calculates a $\chi ^{2}$ statistic using the formula:

$\chi ^{2}=\sum _{i=1}^{columns}\sum _{j=1}^{rows}{\frac {(observed_{ij}-expected_{ij})^{2}}{grandtotal}}$

$observed_{ij}$ is the array of the observed values in a given set of values
$expected_{ij}={\frac {(column_{i}total)*(row_{j}total)}{grandtotal}}$
observed and expected must have the same number of rows and columns and there must be atleast 2 values in each.
A low result of $\chi ^{2}$ is an indicator of independence.
From the formula of $\chi ^{2}$ we will get $\chi ^{2}$ is always positive or 0.
0 only if $observed_{ij}=expected_{ij}$ for each $i$ and $j$ .
CHITEST uses the $\chi ^{2}$ distribution with the number of Degrees of Freedom df.
where $df=(r-1)(c-1),r>1$ and $c>1$ .
If $r=1$ and $c>1$ , then $df=c-1$ or if $r>1$ and $c=1$ , then $df=r-1$ .

If  $r=c=1$  then this function will give the error result

Examples

A student investigated the chance of getting viral fever in a school for a period that took vitamin tablets every day. The total number of students 880. In that 639 students didn't get viral fever and 241 students got fever .But the expected ratio is 1:3
Answer

If the ratio is 1:3 and the total number of observed individuals is 880, then the expected numerical values should be: 660 will not get fever and 220 students will get fever.

	No Fever	Get Fever
Observed Values	639	241
Expected Values	660	220
${\frac {(oi-ei)^{2}}{ei}}$	0.668	2

The $\chi ^{2}$ value is 2.668
Now $df=(r-1)(c-1)=(2-1)(2-1)=1$
From the Chi Squared Distribution probability table with $df$ is 1, the $\chi ^{2}$ value of 2.668 is 0.10.

CHITEST(or,er) = 0.10

References

CHI-SQUARE Distribution

@@ Line 11: / Line 11: @@
   Each cell has an expected frequency of at least five.
 *The <math>\chi^2</math> test first calculates a <math>\chi^2</math> statistic using the formula:
-<math>\chi^2 = \sum_{i=1}^{columns} \sum_{j=1}^{rows} \frac{(observed _ij-expected _ij)^{2}}{grand total}</math>
+<math>\chi^2 = \sum_{i=1}^{columns} \sum_{j=1}^{rows} \frac{(observed _{ij}-expected _{ij})^{2}}{grand total}</math>
-*<math>observed ij</math> is the array of the observed values in a given set of values
+*<math>observed _{ij}</math> is the array of the observed values in a given set of values
-*<math>expected ij = \frac{(column _i total)*(row _j total)}{grand total} </math>
+*<math>expected _{ij} = \frac{(column _i total)*(row _j total)}{grand total} </math>
 *observed and expected must have the same number of rows and columns and there must be atleast 2 values in each.
 *A low result of <math>\chi^2</math> is an indicator of independence.
 *From the formula of <math>\chi^2</math> we will get <math>\chi^2</math> is always positive or 0.
-*0 only if <math>observed _ij = expected _ij</math> for each <math>i</math> and <math>j</math>.
+*0 only if <math>observed _{ij} = expected _{ij}</math> for each <math>i</math> and <math>j</math>.
 *CHITEST uses the <math>\chi^2</math> distribution with the number of Degrees of Freedom df.
 *where <math>df=(r-1)(c-1),r>1</math> and <math>c>1</math>.

Difference between revisions of "Manuals/calci/CHITEST"

Revision as of 22:42, 26 November 2013

Contents

Description

Examples

See Also

References

Navigation menu

Search