0.30. You will enter some of your answers to the questions that follow in Consid

Question

0.30. You will enter some of your answers to the questions that follow in Consider a binomial experiment with n = 41 and p this sample Excel spreadsheet: (21) f(x s 16) 2 In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that x equals 21. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. What is the probability that x equals 21? (Round your answer to 4 decimal places.) O f(21)= 0.7248 f(21) 0.0168 O f(21) o.0022 f(21)0.4832 In cell B2 of the sample spreadsheet, select the correct Excel formula for computing the probability that x is less than or equal to 16. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. What is the probability that x is less than or equal to 16 (Round your answer to 4 decimal places.) O f(x 16) = 0.0621 O f(x 16) = 0.0345 O f(x s 16) 0.9211 O f(x s 16)-0.0724

Explanation / Answer

1.
Required formula is =BINOM.DIST(21,41,0.3,FALSE)
f(x=21)=0.002246
3rd Option is correct.

2.
Required Formula is =BINOM.DIST(16,41,0.3,TRUE)
Result= 0.921137
3rd Option is correct

Related Questions

Navigate

• Browse (All)
• Browse
• Subjects

---

---

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