Cochrans Q in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Cochrans Q capabilities.
For further information visit UNISTAT User's Guide section 6.5.8. Cochrans Q.
Here we provide a sample 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 |