UNISTAT - the ultimate
Excel statistics add-in
Two Sample Chi-square Test in Excel with Unistat
The Unistat statistics add-in extends Excel with Two Sample Chi-square Test capabilities.
Further documentation is available at section 6.3.2 of the manual, Goodness of Fit > Chi-Square Tests.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Two Sample Chi-square Test
Observed Frequency: Observed, Expected Frequency: Expected
| Row | Observed (Observed) | Expected | Difference |
|---|---|---|---|
| 1 | 34.0000 | 33.3333 | 0.6667 |
| 2 | 68.0000 | 33.3333 | 34.6667 |
| 3 | 112.0000 | 33.3333 | 78.6667 |
| 4 | 94.0000 | 33.3333 | 60.6667 |
| 5 | 55.0000 | 33.3333 | 21.6667 |
| 6 | 21.0000 | 33.3333 | -12.3333 |
| 7 | 12.0000 | 33.3333 | -21.3333 |
| 8 | 4.0000 | 33.3333 | -29.3333 |
| Chi-Square Statistic | 6.0150 |
|---|---|
| Degrees of Freedom | 7 |
| Right-Tail Probability | 0.5380 |