Mann-Whitney U Test: Theory and Tutorial in Excel

Mann-Whitney U Test: Theory and Tutorial in Excel

Assessment

Interactive Video

Statistics

10th - 12th Grade

Hard

Created by

Quizizz Content

FREE Resource

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.

Read more

10 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

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

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

3 mins • 1 pt

What is the significance of normal distribution in parametric tests?

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

3 mins • 1 pt

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

Evaluate responses using AI:

OFF

4.

OPEN ENDED QUESTION

3 mins • 1 pt

Explain the benefits of using nonparametric tests.

Evaluate responses using AI:

OFF

5.

OPEN ENDED QUESTION

3 mins • 1 pt

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

Evaluate responses using AI:

OFF

6.

OPEN ENDED QUESTION

3 mins • 1 pt

How do you perform a Mann Whitney U test?

Evaluate responses using AI:

OFF

7.

OPEN ENDED QUESTION

3 mins • 1 pt

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

Evaluate responses using AI:

OFF

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?