the following problem are to be done in excel using the BINOM.DIST command. show

Question

the following problem are to be done in excel using the BINOM.DIST command. show both command (without = sign ) and the answer to 5 decimal places

at a certain university the probability that an entering freshman will graduate in 4 years is .62. If in the incoming class of 2016 there were 1050 entering freshmen, determine the flowing probabilities

a) exactly 673 will graduate in 4 years

b) at most 690 will graduate in 4 years

c) 650 or more will graduate in 4 years

d) between 680 and 720 (inclusive) will graduate in 4 years

show both BINOM.DIST command (without = sign) and the answer

Explanation / Answer

p is 0.62 and N is 1050

a) P(x=673) will be BINOM.DIST(673,1050,0.62,FALSE) which gives 0.00958 ( we use FALSE because we are interested in finding point probability and not cummulative probability)

b) P(x<=690) will be BINOM.DIST(690,1050,0.62,TRUE) which is 0.9942355

c) P(x>=650) or 1-P(x<=649) will be 1-BINOM.DIST(649,1050,0.62,TRUE) =0.538987

d) P(680<=x<=720)= P(z<=720)-P(z<=680)= BINOM.DIST(720,1050,0.62,TRUE)-BINOM.DIST(680,1050,0.62,TRUE) =0.02988

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

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