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.
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
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
This results in the syntax below which we then run in order to obtain our results.
/COCHRAN=test_1 test_2 test_3
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”.