UNISTAT - the ultimate
Excel statistics add-in
One Sample Chi-square Test in Excel with Unistat
The Unistat statistics add-in extends Excel with One Sample Chi-square Test capabilities.
Further documentation is available at section 6.3.1 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.
One Sample Chi-square Test
For Frequency
| Row | Observed (Frequency) | Expected | Difference |
|---|---|---|---|
| 1 | 33.0000 | 33.3333 | -0.3333 |
| 2 | 28.0000 | 33.3333 | -5.3333 |
| 3 | 39.0000 | 33.3333 | 5.6667 |
| 4 | 30.0000 | 33.3333 | -3.3333 |
| 5 | 38.0000 | 33.3333 | 4.6667 |
| 6 | 32.0000 | 33.3333 | -1.3333 |
| Expected Frequency | 33.3333 |
|---|---|
| Chi-Square Statistic | 2.8600 |
| Degrees of Freedom | 5 |
| Right-Tail Probability | 0.7216 |