You will compute the probability of a given event based on the data provided. Th

Question

You will compute the probability of a given event based on the data provided.

The population data base is constant for all questions.

The event changes for each question as indicated.

You must use the correct Excel 2010 function for 100% credit.

x probability Event 15 0.08 A = greater than 16 16 0.15 B = less than 20 17 0.10 C = greater than and equal to 17 18 0.13 D = less than and equal to 19 19 0.12 E = greater than 17 and less than and equal to 20 20 0.10 21 0.20 22 0.12 Event Probability Question 9 A Question 10 B Question 11 C Question 12 D Question 13 E

Explanation / Answer

I have put the given probabilities from B2 to B9 here.

Thus, here are the results:

x probability Event 15 0.08 A = greater than 16 16 0.15 B = less than 20 17 0.1 C = greater than and equal to 17 18 0.13 D = less than and equal to 19 19 0.12 E = greater than 17 and less than and equal to 20 20 0.1 21 0.2 22 0.12 Event Probability Formula used Question 9 A 0.77 =SUM(B4:B9) Question 10 B 0.58 =SUM(B2:B6) Question 11 C 0.77 =SUM(B4:B9) Question 12 D 0.58 =SUM(B2:B6) Question 13 E 0.35 =SUM(B5:B7)

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

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