Excel\'s _ function can be used to compute the variance of a discrete random var
ID: 3182115 • Letter: E
Question
Excel's _ function can be used to compute the variance of a discrete random variable. SUMPRODUCT AVERAGE median VAR When using Excel's BINOM.DIST function, one should choose TRUE for the fourth input if a probability is desired a cumulative probability is desired the expected value is desired the correct answer is desired The Poisson probability distribution is a continuous probability distribution discrete probability distribution uniform probability distribution normal probability distribution In the textile industry, a manufacturer is interested in the number of blemishes or flaws occurring in each 100 feet of material. The probability distribution that has the greatest chance of applying to this situation is the normal distribution binomial distribution Poisson distribution uniform distribution When sampling without replacement, the probability of obtaining a certain sample is best given by a hypergeometric distribution binomial distribution Poisson distribution normal distributionExplanation / Answer
1. Answer is VAR function i.e (d)
2. Answer is (b) i.e. a cumulative probability is desired
3. The Poisson probability distribution is a discrete probability distribution, because, its underlying variable x (say) assumes the values 0, 1, 2, 3, 4, ....
4. In this situation, Poisson distribution is used, because the chance of occuring the blemishes or flaws is very small in each hundred feet of materials.
5. The answer is (a) i.e. Hypergeometric Distribution. Because, it describes the probability of k (say) successes in n (say) draws without replacement from a finite population of size N (say)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.