Excel's ____ function can be used to conduct a sign test.
A)POISSON.DIST
B)T.INV
C)BINOM.DIST
D)CHISQ.DIST.RT

Question

Quizplus · Accepted Answer

The BINOM.DIST function in Excel can be used to conduct a sign test, which is a non-parametric test that can be used when comparing two related samples to test for differences in medians. The test involves counting the number of times that one sample is greater than the other, and then using the binomial distribution to calculate the probability of observing that many or more differences by chance alone.

Excel's ____ Function Can Be Used to Conduct a Sign