For this problem, you must use Excel to perform the necessary calculations. Belo

Question

For this problem, you must use Excel to perform the necessary calculations. Below are the formulas and equations you will need to use. Click on the image below to download a power point version if the text is blurry or too small. If it is appropriate to use the binomial distribution, use the formula binom.dist(number_s,trials,probability,cumulative) to calculate the probability. In this formula, number_s is the number of successful trials, trials is the total number of trials, probability is the probability for a single trial expressed as a decimal, and cumulative should be set as false. This will report the binomial distribution probability for a single outcome. You are tasked with reporting a cumulative probability If it is appropriate to use the normal approximation of the binomial distribution, calculate Z using the correct equation from the option below and then use either the formula(1-(norm.dist(Z,0,1,TRUE))) when calculating a probability >Z or the formula -(norm.dist(Z,0,1,TRUE)) for the probabity or PrIX s Observed] -Pr Z

Explanation / Answer

a) probability of purple = 1 - 0.53 = 0.47

b)

n = 6 , p = 0.53

here normal approximation is not appropriate

P(X>= 3) = 0.71068

c)

n = 260 ,

P(X <= 150)

P(X < 150.5)

= P(Z <(150.5 - 260* 0.53)/sqrt(260*0.53*0.47))

=P(Z < 1.5780)

= 0.9427

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.