Question

Eighteen percent of people in the US eligible to donate blood actually do. You randomly select...

Eighteen percent of people in the US eligible to donate blood actually do. You randomly select 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 probabilities using Excel functions

b. Find the mean of the probability distribution by creating a third column multiplying the x value and its probability and then adding up that third column

Please show in excel!

Homework Answers

Answer #1

Use Excel commend: "=BINOM.DIST(B3,15,0.18,FALSE)"

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Eighteen percent of people in the US eligible to donate blood actually do. You randomly select...
Eighteen percent of people in the US eligible to donate blood actually do. You randomly select 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 probabilities using Excel functions b. Find the mean of the probability distribution by creating a third column multiplying the x value and its probability and then adding up that third column Please show in excel!!!!
Eighteen percent of people in the US eligible to donate blood actually do. You randomly select...
Eighteen percent of people in the US eligible to donate blood actually do. You randomly select 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 probabilities using Excel functions b. Find the mean of the probability distribution by creating a third column multiplying the x value and its probability and then adding up that third column Please show in excel!!!!
3737​% of women consider themselves fans of professional baseball. You randomly select six women and ask...
3737​% of women consider themselves fans of professional baseball. You randomly select six women and ask each if she considers herself a fan of professional baseball. Complete parts​ (a) through​ (c) below.​(a) Construct a binomial distribution using n equals 6n=6 and p equals 0.37p=0.37. x ​P(x) 0 0.0630.063 1 0.2200.220 2 0.3230.323 3 0.2530.253 4 0.1120.112 5 0.0260.026 6 0.0030.003 ​(Round to the nearest thousandth as​ needed.) ​(b) Graph the binomial distribution using a histogram and describe its shape. Choose...