|DÉÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ»ÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
|Dº |5ExpressCalc Template |DºÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ
|DÈÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍͼÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍÍ

^C^1Chi-Square
^Cby
^CJohn A. Abele

   This template won our template contest for ExpressCalc, which appeared in
issue #12.  Templates are files you load into spreadsheets to make them do
useful things.  We may be publishing more contest entries in future issues.
Users are invited to submit other templates, whether for ExpressCalc, or for
other programs such as Lotus 1-2-3.  Write for our submission guidelines.

   This template calculates the Chi-square and Yate's corrected Chi-square
values for integers entered into the "grid" at A, B, C, and D.  The statistical
significance of the chi-square is computed and reported as the probabilty.  If
probability is <.05 then the null hypothesis of independence must be rejected
because a dependence or relationship between rows and columns has been
established by this test.

   A verbal interpretation of "significant" or "not significant" also appears in
the results box.  Refer to standard statistics texts to determine the
appropriateness of this test in any given situation.

   This program is for 2 X 2 contingency tables.  It calculates the Yate's
corrected chi-square if the value in A, B, C or D is less than or equal to 5,
otherwise the Yate's value is returned as "not applicable."  If the Yate's value
is applicable, then this value is used in determining significance, otherwise
the Chi-square value is used.

   The critical value reported in the results box is for the level of
probability reported.  If probability is reported as >.05 then the critical
value for the .05 level of significance is reported as .05, the minimal
statistically significant level.

   The accompanying CALC.PRO file is necessary to cause 3 iterations at !.

FILES USED BY THIS TEMPLATE:
^FCHISQX2
^FCALC.PRO