SPSS Cochran Q test is a procedure for testing if the proportions of 3 or more dichotomous variables are equal in some population. These outcome variables have been measured on the same people or other statistical units.

## SPSS Cochran Q Test Example

The principal of some university wants to know whether three examns are equally difficult. Fifteen students took these examns and their results are in examn_results.sav.

## 1. Quick Data Check

It's always a good idea to take a quick look at what the data look like before proceeding to any statistical tests. We'll open the data and inspect some histograms by running FREQUENCIES with the syntax below. Note the TO keyword in step 3.

***1. Set default directory.**

cd 'd:downloaded'. /*or wherever data file is located.

***2. Open data.**

get file 'examn_results.sav'.

***3. Quick check.**

frequencies test_1 to test_3

/format notable

/histogram.

The histograms indicate that the three variables are indeed dichotomous (there could have been some “Unknown” answer category but it doesn't occur). Since N = 15 for all variables, we conclude there's no missing values. Values 0 and 1 represent “Failed” and “Passed”.We suggest you RECODE your values if this is not the case. We therefore readily see that the proportions of students succeeding range from .53 to .87.

## 2. Assumptions Cochran Q Test

Cochran's Q test requires only one assumption:

- independent observations (or, more precisely, independent and identically distributed variables);

## 3. Running SPSS Cochran Q Test

We'll navigate to

We move our test variables under ,

select under ,

select under and

click

This results in the syntax below which we then run in order to obtain our results.

***Run Cochran Q test.**

NPAR TESTS

/COCHRAN=test_1 test_2 test_3

/STATISTICS DESCRIPTIVES

/MISSING LISTWISE.

## 4. SPSS Cochran Q Test Output

The first table (**Descriptive Statistics**) presents the descriptives we'll report. Do not report the results from `DESCRIPTIVES`

instead.The reason is that the significance test is (necessarily) based on cases without missing values on any of the test variables. The descriptives obtained from Cochran's test are therefore limited to such complete cases too.

Since N = 15, the descriptives once again confirm that there are no missing values and

the proportions range from .53 to .87.Again, proportions correspond to means if 0 and 1 are used as values.

The table **Test Statistics** presents the result of the significance test.

The p-value (“Asymp. Sig.”) is .093; if the three tests really are equally difficult in the population, there's still a 9.3% chance of finding the differences we observed in this sample. Since this chance is larger than 5%, we do not reject the null hypothesis that the tests are equally difficult.

## 5. Reporting Cochran's Q Test Results

When reporting the results from Cochran's Q test, we first present the aforementioned descriptive statistics. Cochran's Q statistic follows a chi-square distribution so we'll report something like ** “Cochran's Q test did not indicate any differences among the three proportions, χ^{2}(2) = 4.75, p = .093”**.

## This tutorial has 6 comments

## By yowie on July 25th, 2016

Thank you for your effort to explain this differencess. However, i get lower p-values with Cochran's Q test...here is my data and output:

A,1,1,0,0,1,0,1,1,1,1,1,1,1,1,1,0,1,1,1,1,0,1,1,1,1,1,0,1,1,1,1,1,0,0,0,1

B,1,1,0,0,1,0,1,1,0,0,0,0,0,1,0,0,1,0,1,1,1,0,1,1,0,1,1,1,1,1,1,1,0,0,0,1

Test Statisticsa

A & B

N 36

Exact Sig. (2-tailed) .065b

a McNemar Test

b Binomial distribution used.

Test Statistics

N 36

Cochran's Q 4.455a

df 1

Asymp. Sig. .035

a 1 is treated as a success.

Thank you!

## By Ruben Geert van den Berg on July 21st, 2016

Hi Yowie, great question! I'll have to look it up and I'll try to do so today and get back to you later, ok?

For now, I believe Cochran's Q test is

notan extension of McNemar's test as the latter involves simpler calculations (which were a real issue in the era these tests were developed). My guess is that McNemar's test is a bit more accurate and therefore tends to come up with slightly lower p-values but I'll need to try that out.I should add that your reasoning

doeshold for one-way ANOVA versus the independent samples t test and similar examples. In fact, text books could completely skip the latter test since it's redundant. We actually considered doing just that on our website but it would probably confuse and dissatisfy our visitors.## By Yowie on July 20th, 2016

Since Cochran's Q test is somehow extension of McNemar's test, shouldnt it provide same result (sig.) if you use Cochran's Q test and put in 2 samples?

I do not know if i am doing smt wrong bc i get different results.

## By Ruben Geert van den Berg on January 21st, 2015

Yes, that is entirely correct: "sig." denotes "significance", which is used interchangeably with "p-value". Did you inspect your descriptives? The results suggests that all proportions are

exactlyequal.## By Swandito Septianto on January 20th, 2015

i have ran Cochran's Q test for my research which involved 40 respondent (N=40), mean is .95 . on the "Test Statistics" table, found that "Cochran's Q" is at .000a, "df" is at 3 and "Asmp. Sig." is at 1.000 . from those resulted. Please explain me if the p-value is at 1.000. Thanks