UNISTAT - the ultimate
Excel statistics add-in
Cochran's Q in Excel with Unistat
The Unistat statistics add-in extends Excel with Cochran's Q capabilities.
Further documentation is available at section 6.5.8 of the manual, Nonparametric Tests > Cochrans Q.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Cochran's Q
| Cases | 0 | 1 | |
|---|---|---|---|
| Problem 1 | 10 | 4 | 6 |
| Problem 2 | 10 | 3 | 7 |
| Problem 3 | 10 | 3 | 7 |
| Problem 4 | 10 | 1 | 9 |
| Total | 40 | 11 | 29 |
| Number of Columns | 4 |
|---|---|
| Number of Rows | 10 |
| Chi-Square Statistic | 1.9655 |
| Degrees of Freedom | 3 |
| Right-Tail Probability | 0.5796 |