Wilcoxon Rank Sum Test: Theory and Tutorial in Excel

The video tutorial explains the differences between parametric and nonparametric tests, focusing on when to use each type. It highlights the importance of data normality and introduces nonparametric tests like the Mann Whitney U test and the Wilcoxon rank sum test. The tutorial provides a detailed guide on performing these tests using Excel, emphasizing the calculation of W statistics and critical values to determine statistical significance.

What is a key assumption of parametric tests?

• Data must be categorical.

• Data must be ranked.

• Data must be ordinal.

• Data must be normally distributed.

When should you consider using a nonparametric test?

• When data is categorical.

• When data is continuous.

• When data is not normally distributed.

• When data is normally distributed.

Which type of data can nonparametric tests be used on?

• Only continuous data

• Ordinal and ranked data

• Only nominal data

• Only categorical data

What is the nonparametric equivalent of the unpaired T test?

• Friedman test

• Kruskal-Wallis test

• Mann Whitney U test

• Wilcoxon signed-rank test

What is the nonparametric equivalent of the paired T test?

• Mann Whitney U test

• Chi-square test

• Wilcoxon rank sum test

• Kruskal-Wallis test

What is the first step in performing the Wilcoxon rank sum test in Excel?

• Calculate the difference between groups

• Calculate the standard deviation

• Calculate the mean of the data

• Sort the data in ascending order

How do you determine the W statistic in the Wilcoxon rank sum test?

• By calculating the mean of the ranks

• By summing the positive and negative ranks

• By calculating the standard deviation

• By finding the median of the data

What does it mean if the W statistic is greater than the critical W?

• Data is not normally distributed

• Reject the null hypothesis

• Data is normally distributed

• Fail to reject the null hypothesis

What is the critical W value analogous to in hypothesis testing?

• P value

• Z score

• Alpha level

• Beta level

What is the main purpose of conducting a Wilcoxon rank sum test?

• To test for normality in a dataset

• To calculate the mean of a dataset

• To determine if there is a significant difference between two groups

• To find the correlation between two variables