Excel's ____ function can be used to conduct the Wilcoxon signed-rank test.
A)POISSON.DIST
B)BINOM.DIST
C)CHISQ.DIST.RT
D)NORM.S.DIST

Question

Quizplus · Accepted Answer

The Wilcoxon signed-rank test requires the calculation of ranks and the comparison of the ranks between two dependent samples. The NORM.S.DIST function in Excel can be used to calculate the probability of a particular z-score based on a normal distribution, which is the basis for the Wilcoxon signed-rank test. Therefore, option D is the best choice. Options A, B, and C are not applicable to the Wilcoxon signed-rank test.

Excel's ____ Function Can Be Used to Conduct the Wilcoxon