Perform Mann Whitney U test on 2 data sets

Version 1

for small sample sizes (N ≤ 20)

↓↓Copy/paste data sets into the cells↓↓

Or choose a data text file to upload →→

Data in file is in:	Columns Rows

Explanations & examples:

If the data in your text file looks like this:

Two data sets organized in columns before performing mann-whitney (wilcoxon) U test

Then you should choose the option "data in file is in columns" to the right when copy/pasting or uploading.
If, on the other hand, the data in your text file looks like this:

Two data sets organized in rows before performing mann-whitney (wilcoxon) U test

Two data sets organized in rows before performing mann-whitney (wilcoxon) U test

Then you should choose the option "data in file is in rows" to the right when copy/pasting or uploading.

In a Mann-Whitney (Wilcoxon) U Test two data sets are tested for equality (whether they could be assumed to be distributed identically). The two data sets involved in a Mann-Whitney U test cannot be assumed normally distributed, for if they had been normally distributed, a parametric test would have been used instead like a z-test or a t-test where the mean and the standard deviation of the data sets are input as parameters during the test. A Mann-Whitney U Test is therefore a non-parametric test where the mean values and standard deviations of the data sets don't have to be calculated beforehand. Instead the Mann-Whitney U Test is based on the ranks of the observations in each group.

The rank of each value in the two data sets is calculated as follows: All the numbers from both data sets are sorted in ascending order in one list. The first (lowest) number in the list has rank 1, no matter what data set it belongs to. The next number has rank 2 ... etc. If there are more than one number with the same value, an average rank is given to all the numbers with that same value.

The test statistic U is then calculated in the following way:

For smaller sample sizes (N < 20): Use the section "Version 1"

For each number (observation) in data set 1 it's counted how many numbers in data set 2 that it is larger than (has a higher rank than). If it's equal to a number in data set 2 it counts as ½. For each number in data set 1 we then get a sum of its "victories" and ties over all the numbers in data set 2. By adding together all these "sums of victories" for all the numbers in data set 1 we obtain the number U₁. The number U₂ is obtained conversely by counting for each single number in data set 2 its victories over and ties with all the numbers in data set 1. The test statistic U is the smallest of the two numbers U₁ and U₂. The obtained U value is then compared with the critical U value in the table over critical U values. If the obtained U value is smaller than the critical table value of U the null hypothesis H0 is rejected. For if the value of U is small, that means that there is one of the data sets in which there are not very many of the numbers that are larger than the numbers in the other data set. Therefore it is very unlikely that the two data sets could be assumed to have the same distribution, and therefore the p-value is small (p < 0.05 or p < 0.01 depending on the significance level) and we reject the null hypothesis claiming that the data sets could be equally distributed. So this is a big difference from and the complete opposite of for eg. a z-test where the p-values will become smaller for larger values of z.
Two data sets input into a table before performing mann-whitney U test

Two data sets input into a table before performing mann-whitney U test

The calculated results of a mann-whitney U test

For larger sample sizes (N > 20): Use the section "Version 2"
The two U-values U₁ and U₂ are calculated as follows:
$$ U_1 = R_1 - \frac{n_1(n_1 + 1)}{2} \text{ and } U_2 = R_2 - \frac{n_2(n_2 + 1)}{2} $$ Here, n₁ is the sample size (no. of values) in data set 1 and R₁ is the sum of the ranks of the values in data set 1. Same for n₂ and R₂ just for data set 2 instead.
For large sample sizes, U is approximately normally distributed, so the z-value can be calculated as:
$$ z = \frac{U - m_U}{\sigma_U} , $$ where m_U is the mean value of U and σ_U is the standard deviation of U. For more infos and formulas, please see under page formulas.

No. of rows:

Sort?

Rank

	Rank

Results

	N	Mean	SD	Q1	Q2	Q3	Sum Of Ranks	f value	r value	U Value	P Value
Sample 1
Sample 2

Critical U Values (click here to show/hide)

n₁	α	n₂
n₁	α	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
1	0.05	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
1	0.01	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
2	0.05	...	...	...	...	...	...	...	0	0	0	0	1	1	1	1	1	2	2	2	2
2	0.01	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	0	0
3	0.05	...	...	...	...	0	1	1	2	2	3	3	4	4	5	5	6	6	7	7	8
3	0.01	...	...	...	...	...	...	...	...	0	0	0	1	1	1	2	2	2	2	3	3
4	0.05	...	...	...	0	1	2	3	4	4	5	6	7	8	9	10	11	11	12	13	13
4	0.01	...	...	...	...	...	0	0	1	1	2	2	3	3	4	5	5	6	6	7	8
5	0.05	...	...	0	1	2	3	5	6	7	8	9	11	12	13	14	15	17	18	19	20
5	0.01	...	...	...	...	0	1	1	2	3	4	5	6	7	7	8	9	10	11	12	13
6	0.05	...	...	1	2	3	5	6	8	10	11	13	14	16	17	19	21	22	24	25	27
6	0.01	...	...	...	0	1	2	3	4	5	6	7	9	10	11	12	13	15	16	17	18
7	0.05	...	...	1	3	5	6	8	10	12	14	16	18	20	22	24	26	28	30	32	34
7	0.01	...	...	...	0	1	3	4	6	7	9	10	12	13	15	16	18	19	21	22	24
8	0.05	...	0	2	4	6	8	10	13	15	17	19	22	24	26	29	31	34	36	38	41
8	0.01	...	...	...	1	2	4	6	7	9	11	13	15	17	18	20	22	24	26	28	30
9	0.05	...	0	2	4	7	10	12	15	17	21	23	26	28	31	34	37	39	42	45	48
9	0.01	...	...	0	1	3	5	7	9	11	13	16	18	20	22	24	27	29	31	33	36
10	0.05	...	0	3	5	8	11	14	17	20	23	26	29	33	36	39	42	45	48	52	55
10	0.01	...	...	0	2	4	6	9	11	13	16	18	21	24	26	29	31	34	37	39	42
11	0.05	...	0	3	6	9	13	16	19	23	26	30	33	37	40	44	47	51	55	58	62
11	0.01	...	...	0	2	5	7	10	13	16	18	21	24	27	30	33	36	39	42	45	46
12	0.05	...	1	4	7	11	14	18	22	26	29	33	37	41	45	49	53	57	61	65	69
12	0.01	...	...	1	3	6	9	12	15	18	21	24	27	31	34	37	41	44	47	51	54
13	0.05	...	1	4	8	12	16	20	24	28	33	37	41	45	50	54	59	63	67	72	76
13	0.01	...	...	1	3	7	10	13	17	20	24	27	31	34	38	42	45	49	53	56	60
14	0.05	...	1	5	9	13	17	22	26	31	36	40	45	50	55	59	64	67	74	78	83
14	0.01	...	...	1	4	7	11	15	18	22	26	30	34	38	42	46	50	54	58	63	67
15	0.05	...	1	5	10	14	19	24	29	34	39	44	49	54	59	64	70	75	80	85	90
15	0.01	...	...	2	5	8	12	16	20	24	29	33	37	42	46	51	55	60	64	69	73
16	0.05	...	1	6	11	15	21	26	31	37	42	47	53	59	64	70	75	81	86	92	98
16	0.01	...	...	2	5	9	13	18	22	27	31	36	41	45	50	55	60	65	70	74	79
17	0.05	...	2	6	11	17	22	28	34	39	45	51	57	63	67	75	81	87	93	99	105
17	0.01	...	...	2	6	10	15	19	24	39	34	39	44	49	54	60	65	70	75	81	86
18	0.05	...	2	7	12	18	24	30	36	42	48	55	61	67	74	80	86	93	99	106	112
18	0.01	...	...	2	6	11	16	21	26	31	37	42	47	53	58	64	70	75	81	87	92
19	0.05	...	2	7	13	19	25	32	38	45	52	58	65	72	78	85	92	99	106	113	119
19	0.01	...	0	3	7	12	17	22	28	33	39	45	51	56	63	69	74	81	87	93	99
20	0.05	...	2	8	14	20	27	34	41	48	55	62	69	76	83	90	98	105	112	119	127
20	0.01	...	0	3	8	13	18	24	30	36	42	46	54	60	67	73	79	86	92	99	105

Version 2

for larger sample sizes (N ≥ 20)

↓↓Copy/paste data sets into the cells↓↓

Or choose a data text file to upload →→

Data in file is in:	Columns Rows

No. of rows:

Sort?

Rank

	Rank

Results

	N	Mean	SD	Q1	Q2	Q3	Sum of Ranks	f value	r value	U Value	m_U	σ_U	Z Value	P Value
Sample 1
Sample 2