Which Excel function would not be appropriate to use when conducting a hypothesis test for a population proportion?
A)NORM.S.DIST
B)COUNTIF
C)STDEV
D)All are appropriate.

Question

Quizplus · Accepted Answer

STDEV is a function used to calculate the standard deviation of a sample, but when conducting a hypothesis test for a population proportion, we would be dealing with categorical data and not continuous data. Therefore, an appropriate function would be one that deals with proportions or probabilities, such as BINOM.DIST or BINOM.INV. NORM.S.DIST could also be appropriate if using a normal approximation to the binomial distribution. COUNTIF would not be relevant for hypothesis testing.

Which Excel Function Would Not Be Appropriate to Use When