Can I see how an Excel model would look for this question out of the \"Quantitat

ID: 3251617 • Letter: C

Question

Can I see how an Excel model would look for this question out of the "Quantitative Analysis for Management, Twelfth Edition would look like?

The answers are in the back of the book --- so I don't need just the answers...I need an Excel model. Thanks!

Question 2-32...out of Chapter 2

There are 10 questions on a true-false test. A student feels unprepared for this test and randomly guesses the answer for each of these.

(a) What is the Probability that the student gets exactly 7 correct?

(b) What is the Probability that the student gets exactly 8 correct?

(d) What is the Probability that the student gets exactly 10 correct?

(e) What is the Probability that the student gets more than 6 correct?

Answer - 2:

This will be a binomial distribution with parameters:

n = 10, p = P(Correct) = 1/2 = 0.5

q = 1 - p = 1 - 0.5 = 0.5

a) P(7 correct)

= P(X = 7)

= P(7, 10, 0.5, FALSE) [Excel Formula]

= 0.1172

b) P(8 correct)

= P(X = 8)

= binomdist(8, 10, 0.5, FALSE) [Excel Formula]

= 0.0439

c) P(9 correct)

= P(X = 9)

= binomdist(9, 10, 0.5, FALSE) [Excel Formula]

= 0.0098

d) P(10 correct)

= P(X = 10)

= binomdist(10, 10, 0.5, FALSE) [Excel Formula]

= 0.0010

e) P(More than 6 correct)

= P(X > 6)

= 1 - P(X < 6)

= 1 - binomdist(6, 10, 0.5, TRUE) [Excel Formula]

= 0.1719

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