Can you you show the step by step solution in excel of the following problem? A

Question

Can you you show the step by step solution in excel of the following problem? A game is played with 2 people. One person thinks of a whole number from 1 to 8 (including 1 and 8) and the other person tries to guess the number. They play the game 22 times. What is the probability that the person guesses the number INCORRECTLY at least 19 times of the 22 times the game is played? How many times should the game be played (disregard the 22 times above) such that you will be at least 71% certain that you will guess the number CORRECTLY at least 11 times?

Explanation / Answer

P(success) = 1/8

Thus, P(failure) = 1 - 1/8 = 7/8

a) We have to find

P(X 19) for failures = 22C19 * (7/8)^19 * (1/8)^3 ..+..................+ 22C22 * (7/8)^22 * (1/8)^0

P =0.7072

b) Here, for successes we have to find N such that P(X   11)

nC11 * (1/8)^11 * (7/8)^{n-11}..+.......+ nC11 *(1/8)^n * (7/8)^0 > 0.71

By trial and error,

n = 100

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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