IN EXCEL. 1. Suppose the probability of a coin toss resulting in \"heads\" is 0.
ID: 3051774 • Letter: I
Question
IN EXCEL.
1. Suppose the probability of a coin toss resulting in "heads" is 0.3. What formula should be typed to compute the probability of having exactly 20 heads in 30 coin tosses?
A.
=BINOM.DIST(20,30,0.7,TRUE)
2. Assuming cell A1 contains the probability that an event A is to take place, what formula should be typed in cell A2 order to find the probability that the complement of A is to take place?
=1/A1
3.
Suppose the probability of selecting RED is 0.8. What formula could be used to find the probability of selecting 5 or fewer REDs out of 12 trials?
a. =BINOM.DIST(5,12,0.2,FALSE)
b. =BINOM.DIST(5,12,0.8,FALSE)
c. =BINOM.DIST(5,12,0.8,TRUE)
d. =BINOM.DIST(12,5,0.2,TRUE)
=BINOM.DIST(30,20,0.7, TRUE)Explanation / Answer
1) BINOM.DIST(20,30,0.3,FALSE). Option B is Correct
2) A1-1. Option A is Correct
3) BINOM.DIST(5,12,0.8,TRUE). Option C is Correct