Chi-Square Tests in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Chi-Square Tests capabilities.
For further information visit UNISTAT User's Guide section 6.3.1. Chi-Square Tests.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Chi-square Tests
| Valid Cases | Missing | Mean | Standard Deviation | Expected Frequency | Chi-Square Statistic | Degrees of Freedom | Right-Tail Probability | |
|---|---|---|---|---|---|---|---|---|
| Observed | 8 | 0 | 50.0000 | 39.2538 | 50.0000 | 215.7200 | 7 | 0.0000 |
| Expected | 8 | 0 | 49.9875 | 36.6127 | 49.9875 | 187.7151 | 7 | 0.0000 |
| Observed – Expected | 8 | 0 | 6.0150 | 7 | 0.5380 |