Share
Explore BrainMass

Using: The Wilcoxon Signed Rank Test

Use the following data set for parts A& B (units unimportant).

Treatment Group 1 Treatment Group 2
92 102
90 89
92 96
85 80
89 92
97 77
88 101
86 87
85 102
78 76

A. Perform the sign test to analyze the difference in the matched pairs. It is not important what the numbers mean.

B. Perform the Wilcoxon signed-rank test on the same data.

For C & D, use the following independent data:
Group A (n=12): 91, 58, 32, 81, 99, 39, 36, 85, 51, 76, 92, 74
Group B (n=16): 35, 51, 17, 30, 49, 58, 78, 16, 14, 70, 51, 15, 46, 11, 11, 50

C. Perform the Wilcoxon rank-sum test on the independent data.

Solution Summary

This solution contains step-by-step instructions to conduct a Wilcoxon Signed Rank test in an Excel file. It also provides a null and alternative hypothesis and conducts a proportion test and a Z-test to decide to either reject of accept the null hypothesis.

$2.19