Question

A manufacturer wants to estimate the proportion of defective items that are produced by a certain machine. A random sample of 50 items is selected. Which Excel function would NOT be appropriate to construct a confidence interval estimate?

Answer 1

Answer:

The correct answer to the following question will be "STDEV".

Explanation:

• The method Excel STDEV generates the standard data variance describing a variable or to estimate or measure the standard deviation in a test, this method will be used.
• To find a population's standard deviation will be using the STDEV. P function in and later on throughout Excel. Either use STDEVA or STDEVPA unless you include rational or document values in the computation.

The manufacturer must, therefore, use the STDEV function, because of this.