3. (USE BINOMDIST) The odds that a given incoming freshmen graduates from Saint

Question

3. (USE BINOMDIST) The odds that a given incoming freshmen graduates from Saint Francis University in 4 years is 70%.

a. If Dr. Miko has 10 incoming freshmen as advisees, what is the probability that exactly 5 graduate in 4 years?

b. What is the probability that 6 or more graduate in 4 years?

c.What is the probability that none graduate in 4 years?

I'd like you to complete the following problems on Excel. Copy the results to a Word document to be submitted and to uploaded through this assignment. Please also attach your Excel file where you entered the formulas.For each problem, I'd also like you to briefly describe the results in narrative form.

Explanation / Answer

Solution:-

a. BINOM.DIST(5,10,0.7,FALSE) = 0.10292

b. 1 - BINOM.DIST(5,10,0.7,TRUE) = 0.84973

c. BINOM.DIST(0,10,0.7,FALSE) = 0.00001

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

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