use Excel or calculator. justify your answers by giving the excel or calculator

Question

use Excel or calculator. justify your answers by giving the excel or calculator function
3. Suppose 60% of recent college graduates plan on pursuing a graduate degree. Seventeen recent college graduates are randomly selected. (a) What is the probability that no more than 7 of the college graduates plan to pursue a graduate degree? (b) What is the probability that more than 13 of the college graduates plan to pursue a graduate degree? (c) What is the probability that at least 10 but no more than 15 of the college graduates plan to pursue a graduate degree?

Explanation / Answer

Ans:

Binomial distribution:

n=17,p=0.6

P(x=r)=17Cr*0.6r*(1-0.6)17-r

a)P(x<=7)=BINOMDIST(7,17,0.6,TRUE)=0.0919

b)P(x>13)=1-P(x<=13)=1-BINOMDIST(13,17,0.6,TRUE)=1-0.9536=0.0464

c)P(10<=x<=15)=BINOMDIST(15,17,0.6,TRUE)-BINOMDIST(9,17,0.6,TRUE)

=0.9979-0.3595

=0.6384

r BINOMDIST(r,17,0.6,FALSE) 0 0.0000 1 0.0000 2 0.0001 3 0.0004 4 0.0021 5 0.0081 6 0.0242 7 0.0571 8 0.1070 9 0.1606 10 0.1927 11 0.1839 12 0.1379 13 0.0796 14 0.0341 15 0.0102 16 0.0019 17 0.0002

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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