Question

You will be finding probabilities using excel. Use the Excel instructions for Binomial Distribution (=BINOMDIST(x, n, p, true or false)) False is equivalent to binompdf. True is equivalent to binomedf. State which probabilities are unusual. a.) P(x <6), n = 20, p= .8 b.) P(x < 16), n = 20, p=.15 c.) P(x> 14), n = 30, p = .35 3.) Twelve percent of people in the US eligible to donate blood actually do. You randomly section 15 eligible blood donors and ask them if they donate blood. a. Construct a binomial distribution (table) i. First column x values ii. Second column boundaries iii. Third column probabilities using Excel functions b. Create a histogram of this probability distribution. c. Describe the histogram. d. Find the mean of the probability distribution by creating a fourth column multiplying the x value and its probability and then adding up that fourth column

Answer 1

Dear student, we can provide you with the solution of one type of question at a time.

$a)P(x \leq 6)=\sum_{x=0}^{6}_{x}^{20}\textrm{C}(0.8)^x(1-0.8)^{20-x}\approx 0$ ( using excel =formula BINOM.DIST(6,20,0.8,TRUE) )

b) $a)P(x < 16)=P(X\leq15)=\sum_{x=0}^{15}_{x}^{20}\textrm{C}(0.15)^x(1-0.15)^{20-x}\approx 1$ ( using excel formula =BINOM.DIST(15,20,0.15,TRUE))

c) $P(X \geq 14)=1-P(X \leq 13)$

( using excel formula =BINOM.DIST(13,30,0.35,TRUE))

13 30-T P(X < 13) - -Σ22 20c(0.35)*(1 – 0.35) 30 - 0.8737 T=0

$P(X \geq 14)=1-0.8737=0.1263$