Running a Mann-Whitney test on two independent samples with XLSTAT

Principle of the Mann-Whitney test

The Mann-Whitney test is a non parametric test that allows to compare two independent samples.

Three researchers, Mann, Whitney, and Wilcoxon, separately perfected a very similar non-parametric test which can determine if the samples may be considered identical or not on the basis of their ranks.

This test can only be used to study the relative positions of the samples. For example, if we generate a sample of 500 observations taken from an N(0,1) distribution and a sample from a distribution of 500 observations from an N(0,4) distribution, the Mann-Whitney test will find no difference between the samples.

The results proposed by XLSTAT are based on the U statistic of Mann-Whitney.

Dataset for a Mann-Whitney test

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

The data are from [Fisher M. (1936), The Use of Multiple Measurements in Taxonomic Problems. Annals of Eugenics, 7, 179 -188] and correspond to 100 Iris flowers, described by four variables (sepal length, sepal width, petal length, petal width) and their species. The original dataset contains 150 flowers and 3 species, but we have isolated for this tutorials the observations belonging to the versicolor and virginica species. Our goal is to test if for the four variables, there is a clear difference between the two species.

The goal of this tutorial is to compare the two species with respect to the four variables independently.

Setting up a Mann-Whitney test on two independent samples

Once XLSTAT-Pro is activated, select the XLSTAT / Nonparametric tests / Comparison of two samples (Wilcoxon, Mann-Whitney, ...) command, or click on the corresponding button of the Nonparametric test menu (see below).

menu test mann whitney 

Once you've clicked the button, the dialog box appears. You can then select the data on the Excel sheet. Select the one column per variable option because, we have 4 columns of data and one column corresponding to the species identifiers.

 dialog box test mann whitney general

In the options tab, we suppose that the difference between samples is equal to 0. Note that exact p-value can be computed with XLSTAT.

 dialog box test mann whitney options

After you have clicked on the OK button, the results are displayed on a new Excel sheet (because the Sheet option has been selected for outputs).

Interpreting the results of a Mann Whitney test on two independent samples

The first results displayed are the statistics for the various samples. For each variable, we obtain a test result.

We can see that for the first variable, the null hypothesis of equality is rejected. We can consider that the sepal length is significantly different from one specie to the other.

results test mann whitney

Results for the other variables are also available in the output.

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