Mann-Whitney U Test: Theory and Tutorial in Excel

The video tutorial explains the differences between parametric and nonparametric tests, focusing on when to use nonparametric tests like the Mann Whitney U test. It provides a detailed guide on performing the Mann Whitney U test using Excel, including calculating ranks and U statistics, and interpreting the results to determine statistical significance.

What are parametric tests and why are they commonly used in science courses?

What is the significance of normal distribution in parametric tests?

What should you do if your data does not follow a normal distribution?

Explain the benefits of using nonparametric tests.

What is the Wilcoxon rank sum test and when is it used?

How do you perform a Mann Whitney U test?

What is the importance of calculating R1 and R2 in the Mann Whitney U test?

Discuss the process of ranking data in the Mann Whitney U test.

What is the role of critical values in hypothesis testing?

How do you determine if the difference between two groups is statistically significant?