Running a Grubbs test to detect outliers with XLSTAT

Dataset for testing outliers with Grubbs test

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

The data have been obtained from a normal distribution with mean 0 and variance 3. One outlier has been added. We wish to test if there is one outlier in the sample.

Goal of this tutorial

We would like to detect an outlier from a sample using Grubbs test. You can find some detail on the test here.

Setting up a Grubbs test to detect an outlier

To start the Grubbs test go to the menu Testing outliers / Grubbs test.

grubbs test menu

In the General tab, select the data and the Grubbs test option ('t Lam G test can be used to detect two outliers.

grubbs test dialog box general

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

grubbs test dialog box options

When ready click on OK.

Results of a test for detecting an outlier

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

grubbs test result

In the following table, the detected outlier is given.

grubbs test outlier

You can also find the Z score to detect outliers in the output of this test.

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