Please solve the whole problem please. Please give me all the excel formulas that are needed to get the answer. I for sure need to show my work on work on excel example. ( for stdv, its =stdev(x1-x9) ) Let me know if you have any questions thank you so much.

BANAFinalFall Home Insert Draw Page Layout Formulas Data Review View Ruler Formula Bar Zoom 100% Normal Page Break Page Custom Gridlines Headings 100 Zoom to 100% Zoom to New Arrange Freeze Preview Layout Views Selection Window All Panes G94 X V fx b A B C D E F G H K put your name here Business Analytics Final Exam Question 2 - This question has 3 pages with 7 parts. 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, 11 girls were born to 15 couples who used MicroSort. Answer the questions below: 1) What is the probability of success (a female birth)? Hint: It is not 11/15. You are born either a boy or a girl. p(girl te 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 P P(x) Pcum (X) 3) Create a bar chart of the P(x) probability distribution in the space below.BANAFinalFall2020 Home Insert Draw Page Layout Formulas Data Review View Ruler Formula Bar Zoom 100% Normal Page Break Page Custom Gridlines Headings 100 Zoom to 100% Zoom to New Arrange Freeze Freeze Fr Preview Layout Views Selection Window All Panes Top Row G94 X V fx b A B C D E F G H 55 4) Compute the following probabilities. Put your answers in the yellow cells. 57 P(X=9 P(X10) P (X>=7) P(5