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

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey


Like us on Facebook Facebook

Get in Touch

  • Email:
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414