Running a Cochran C test to detect outlying variances with XLSTAT

Dataset for testing variances with a Cochran C test

An Excel sheet with both the data and the results can be downloaded by clicking here.

Four samples have been obtained from two different distribution: 3 with a normal distribution with mean 0 and variance 2 and one with a normal distribution with mean 0 and variance 5 .We wish to test if there is a variance larger than the others

Goal of this tutorial

We would like to detect if a variance is larger than the others using the Cochran C test. You can find some detail on the test here.

Setting up a Cochran C test to detect an outlying variance

To start the Cochran C test go to the menu Testing outliers / Cochran's C test.

cochran c test menu

In the General tab, select the data. Four columns should be selected with the option one column per group. Since the number of observation per sample are equal, we use the balanced option.

cochran c test dialog box general

As an alternative hypothesis choose the two-sided option. The default significance level is left as is: 5%.

cochran c test dialog box options

When ready click on OK.

Results of a Cochran C test

The result is that the p-value for this test is smaller than 0.0001. That means that the null hypothesis should be rejected.

cochran test result

In the following table, the detected variances and outliers are given.

cochran test outlier

Then, a graphic with all variances represented is displayed.

cochran test graph

We have shown that there is an outlying variance in our dataset.

Click here for other tutorials.

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