Question

Use Excel to answer the following question. Use an Excel function for each answer – DO NOT just type in a number. Change the name of this worksheet to Cards. In a standard deck of 52 cards, 12 are face cards (king, queen, jack of all four suits). Assume that 5 cards are selected with replacement out of a well-shuffled deck. a) What is the probability of getting exactly two face cards? b) What is the probability of getting at least two face cards?

Needing answer and solution please:)

Answer 1

Here there are 52 cards, 12 are face cards.

Here 5 cards are selected with replacement out of a well shuffled dect.

(A) So, here it would be a binomiall didstribution as the selection is with replacement.

so here the parameters are

n = 5, and p = 12/52 = 3/13

Pr(Getting Exactly two face cards) = BINOMDIST(2; 5 ; 3/13; False) = 0.2424

(B) Pr(Getting at least two face cards) = 1 - Pr(less than 2 face cards) = 1 - BINOMDIST(1 ; 5; 3/13 ; true) = 1 - 0.4040 = 0.5960

Note : I have used excel function here exactly and i provide the binomial parameter also. If any difficulty please pt in comment.