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 of the answers are correct.

Question

Quizplus · Accepted Answer

The STDEV function calculates the standard deviation of a sample, which is not used in conducting a hypothesis test for a population proportion. The appropriate functions for this type of test include NORM.S.DIST for finding the cumulative distribution function of a normal distribution, and COUNTIF for counting the number of successes in a sample.

Which Excel Function Would NOT Be Appropriate to Use When