Question

An auto manufacturer wants to estimate the annual income of owners of a particular model of automobile. A random sample of 200 current owners is selected. The population standard deviation is known. Which Excel function would NOT be appropriate to use to construct a confidence interval estimate? a. NORM.S.INV b. COUNTIF C. STDEV d. AVERAGE

Answer 1

Answer: b. COUNTIF

Explanation:

The rest functions all employ techniques to construct a confidence interval estimate while COUNTIF function is just used to count the cells for a particular criterion.