value to lookup chi-square
table value and compare to table value.
|
|
Excel Programs (Interactive web Solutions) |
(requires Microsoft® Internet Explorer 4.01 or later and the Microsoft Office Web Components)
The following Functions are created for this class - you may click on functions to launch in Internet Explorer.
Update table with new values or entries and appropriate statistics will be automatically calculated.
(only change values highlighted in blue against a white background)
e.g.
| 19.46 |
Used appropriate df
and
value to lookup chi-square
table value and compare to table value.
If Since 
then accept the null hypothesis, otherwise the alternate hypothesis is
accepted (
).
Programs: Requires Microsoft® Internet Explorer 4.01 or later
To select appropriate program to use: If you have 2 Variables which
are categorized into 7 and
3 classifications
you may either use a 7
by 3 Matrix Table or a 7 by 4 and delete one row out of 4 to make
the 7 by 4 a 7
by 3.
Chi-square goodness of fit statistics
(after entry of observed frequencies, O and expected proportions,
p,
delete cells not needed or use Worksheets
to computer statistics)
| Goodness-of-fit
(up to 4 observations) or
Open in Excel (download) |
Goodness-of-fit
(Expected Frequencies, E is known) or
Open in Excel (download) |
Goodness-of-fit
(up to 10 observations) or
Open in Excel (download) |
Chi-square test for independent characteristics and
homogeneity:
(note: homogeneity and independence tables
can be used interchangeably)
Worksheet - Contingency Tableor
Chi-square test for Variance
Worksheet - Variance Test Matrix or
| Confidence
Interval for Variance
or Open in Excel (download) |