4.) Construct a binomial distribution (table) using Excel functions for the foll

ID: 3324411 • Letter: 4

Question

4.) Construct a binomial distribution (table) using Excel functions for the following: Eight percent of people in the US eligible to donate blood actually do. You randomly section 12 eligible blood donors and ask them if they donate blood. Create a histogram of this probability distribution. Describe the histogram.

5.) Use the instructions for Exponential distribution (=EXPONDIST(x, , true or false)) on Excel to find the probability of the following (NOTE: Excel uses the notation for m). State which probabilities are unusual. a. P(x = 1.75) when m = .2 b. P(x < 2.4) when m = .25 c. P(x > 5) when m = .35

6.) Use Excel functions to find the following probability of Zdistribution a.) P(z < 1.74) b.) P(z > -.58) c.) P(-1.4 < z < 2.1) d.) P(z < -1.6 or z > 1.6)

7.) Use Excel functions to find the following Z-score(s) given the probability a.) Middle 40% b.) P79 c.) Separates top 10%

8.) Use Excel functions to find the following probability of Normal distribution a.) P (X > 78) when X ~ N (65, 10) b.) Separates top 10% P(20 < X < 40) when X ~ N (42, 12)

9.) Use Excel functions to find the X value(s) given the probability when X ~ N(45, 5) a.) P78 b.) Q1

Explanation / Answer

(All questions are solved by using excel and outputs are given in the answer part.)

Question 4

We are given

p = 0.08

n = 12

We have to find probabilities for each x and then we have to draw histogram for these probabilities.

Probabilities by using excel are given as below:

P(X)

0.367666

0.383652

0.183486

0.053184

0.010406

0.001448

0.000147

1.09E-05

5.95E-07

2.3E-08

6E-10

9.48E-12

6.87E-14

Total

Question 5

Part a

P(X=1.75) = 0.140938

…by using excel command =EXPONDIST(1.75,0.2,0)

Part b

P(X<2.4) = 0.451188

…by using excel command =EXPONDIST(2.4,0.25,1)

Part c

P(X>5) = 0.173774

…by using excel command =1-EXPONDIST(5,0.35,1)

Question 6

a) P(z < 1.74) = 0.95907

…by using excel command =NORMSDIST(1.74)

b.) P(z > -.58) = 0.719043

…by using excel command =1-NORMSDIST(-0.58)

c.) P(-1.4 < z < 2.1) = 0.901379

…by using excel command =NORMSDIST(2.1) - NORMSDIST(-1.4)

d.) P(z < -1.6 or z > 1.6) = 0.109599

…by using excel command =NORMSDIST(-1.6) + (1 - NORMSDIST(1.6))