XLSTAT - Cochran’s Q test
Cochran’s Q test definition
The Cochran’s Q test is presented as a particular case of the Friedman’s test (comparison of k paired samples) when the variable is binary.
As a consequence, the null H0 and alternative Ha hypotheses for the Cochran’s Q test are:
- H0: the k treatments are not significantly different.
- Ha: the k treatments are significantly different.
Input data for the Cochran’s Q test
Two possible formats are available for the input data:
- You can select data in a "raw" format. In this case, each column corresponds to a treatment and each row to a subject (or individual, or bloc).
- You can also select the data in a "grouped" format. Here, each column corresponds to a treatment, and each row corresponds to a unique combine of the k treatments. You then need to select the frequencies corresponding to each combine.
This analysis is available in the XLStat-Basic addin for Microsoft Excel™