Mann Whitney U Test Equation. This tutorial explains how to perform a mann whitney u test in excel. J the number of tied ranks in group j note that the mann whitney u test is statistically equivalent to the wilcoxon rank sum test not to be confused with the wilcoxon signed rank sum test which is for paired data.
S x y 1 if y x 1 2 if y x 0 if y x. The scores from both samples will be ranked together. The test statistic for the mann whitney u test is denoted u and is the smaller of u 1 and u 2 defined below.
In every test u 1 u 2 is always equal to n 1 n 2.
U 1 n 1 n 2 n 2 n 2 1 2 r 2. Is approximately distributed as a normal distribution with a mean of 0 and a standard deviation of 1 n 0 1. A mann whitney u test sometimes called the wilcoxon rank sum test is used to compare the differences between two samples when the sample distributions are not normally distributed and the sample sizes are small n 30 it is considered to be the nonparametric equivalent to the two sample t test. In this case you want 2 times p u geq 23.
