This question must be answered in microsoft Excel and applying excel functions w

Question

This question must be answered in microsoft Excel and applying excel functions when appropriate

The Genetics and IVF Institute in Fairfax, Virginia developed a technique called MicroSort which supposedly increases the chance of a couple having a baby girl. In a preliminary test, 13 girls were born to 15 couples who used MicroSort. Answer the questions below:

a) What is the probability of success (a female birth)?

b) Create a binomial probability distribution, P(x), and a cumulative binomial probability distribution, Pcum(X), of the probability of 15 female births. Use the columns below for your distribution.

c) Create a bar chart of the P(x) probability distribution in the space below.

cum

Explanation / Answer

x= number of female birth in n trials

x=0,1,2,3,.........15

Here we have n=15 and p= 1/2 (Probability of success ie female birth)

a) Probability of success ie female birth is 0.5

by using command BINOM.DIST in Excel we get the binomial probability distribution

b)

c)

d) we know mean=n*p and var=n*p*q

x p(X) pcum(X) 0 3.05176E-05 3.05176E-05 1 7.29576E-12 3.05176E-05 2 3.31958E-10 3.05179E-05 3 9.35018E-09 3.05273E-05 4 1.82329E-07 3.07096E-05 5 2.60731E-06 3.33169E-05 6 2.8246E-05 6.15629E-05 7 0.000236056 0.000297619 8 0.00153437 0.001831989 9 0.007757117 0.009589106 10 0.030252843 0.039841949 11 0.089383657 0.129225606 12 0.193665148 0.322890754 13 0.29049856 0.613389314 14 0.269749441 0.883138756 15 0.116891762 1.000030518 Total 1.000030518

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.