parent nodes: Bigger Smaller or not equal test | Choosing a statistical test | index | IndexBasicStat | Indexch | indexnl | Mean | Median | non parametric | Result table | Sample size Calculations | Statistical software | Support | t-test | What to do with not normally distributed Data


Wilcoxon–Mann–Whitney-test

Main Help

Basic Statistics
Mean
n
Median
STDEV
Cp Cpk % out of tolerance
Min/Max
Compare with
Calculate Difference
Diff mean normally
Diff median not normally
Diff variation normally
Diff variation not normally
Normally test
Correlation
Regression
Kurtosis
Skewness


Full version of Develve
For commercial use
75 EURO

1 sample Wilcoxon test

If Diff median is selected and one of the comparing column contains 1 value the 1 sample Wilcoxon test is calculated. To calculate the if there is a significant difference in Median between a data-set and a Hypothesized value.



This non parametric test is for not normally distributed data but before using this test try to find out why the data is not normally distributed see "What to do with not normally distributed data".

Interpretation

For a good result the data must

Options

Colors of the cells

Formula

formula

With tie correction

Ties are data point with the same value.
formula

With the z value the p value can be found in the normal table.

Legend

formula = smallest sum of ranks
formula = Amount of samples minus values that are the same as comparing value
formula = amount of ties of the absolute rank

Sample size

Sample size calculation is the same as with the 1 sample t-test but with 15% more samples.
The result is the minimum sample size of the data-set.

not equal

formula

bigger smaller

formula

Example

To use the 1 sample Wilcoxon test first select "non normal distributed" when the box is unselected the one sample t-test is calculated. Then select Diff median. In this example E is significantly different from the median of A and D not. For both test the sample size is to low but for the comparison D to A it is maybe worth to invest to do more measurements.

Data file

2 sample Mann whitney test

If Diff median is selected and the comparing column and this column contains more than 1 value, the Mann–Whitney-test is calculated between this column and the comparing column. This to calculate if there is a significant difference of the Median of the two data-sets.



This non parametric test is for not normally distributed data but before using this test try to find out why the data is not normally distributed see "What to do with not normally distributed data"

Interpretation

For a good result the data must

Options

Colors of the cells

Formula

Both data-sets are sorted and ranked in order. The sum of the ranks of each data-set is calculated (formula and formula)

formula
formula

With the smallest U value the z score is calculated.

formula

With tie correction

Ties are data point with the same value.
formula
With the z value the p value can be found in the normal table.

Legend

formula and formula = Sum of ranks (the ranking is the absolute value of the difference)
formula and formula = Amount of samples
formula = amount of ties of a rank

Sample size

Sample size calculation is the same as with the 2 sample t-test but with 15% more samples.
formulais the biggest one of the two comparing data sets. The result is the minimum sample size for both data sets.

not equal

formula

bigger smaller

formula

Example

To use the 2 sample Mann Whitney test first select "non normal distributed" when the box is unselected the 2 sample t-test is calculated. Then select Diff median. In this example C is significantly different from the median of A and B not. The minimum sample size for the comparison A and B is to low but the difference in not significant so it is not worth to invest in more measurements.

Data file

External links