Ask Question
3 June, 21:53

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 confidence interval estimate? a. Countifb. Norm. s. invc. Stdevd. all of these answer are correct

+3
Answers (1)
  1. 3 June, 22:33
    0
    c. Stdev

    Step-by-step explanation:

    Excel stdev function is not appropriate to construct confidence interval estimate, because the estimation of the proportion of defective items that are produced by a certain machine has binomial distribution.

    stdev fuction is used for calculating standard deviations where sample has more than two different values. (multinomial)

    Norm. s. inv function calculates inverse of the standard normal cumulative distribution, and countif counts the number of cells that meet a criterion. Both functions are used to construct confidence interval estimate
Know the Answer?
Not Sure About the Answer?
Get an answer to your 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 ...” in 📙 Mathematics if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers