Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
For U.S. live births, P(Boy) and P(Girl) are approximately 0.51 and 0.49
respectively. According to a newspaper article, a medical process could alter the probabilities that a boy or a girl will be born. Researchers using the process claim that coupleswho wanted a boy were successful 85% of the time, while couples who wanted a girl were successful 77% of the time. Assuming the medical process does not have an effect on the sex of the child: a. Without medical intervention, what is the probability of having a boy? ANS: =BINOMDIST(0,1,0.85,FALSE) b. With medical intervention, what is the conditional probability that a couple who wants a boy will have a boy? ANS: =BINOMDIST(0.51,1,0.85,FALSE) c. With medical intervention, what is the conditional probability that a couple who wants a girl will have a girl? ANS: =BINOMDIST(B11,1,0.77,FALSE) Please advise me if i am on the right track or if my answer is correct or wrong? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200902/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Advanced Probability. | Excel Worksheet Functions | |||
probability | Excel Discussion (Misc queries) | |||
probability | Excel Worksheet Functions | |||
Probability | Excel Discussion (Misc queries) | |||
Probability calculation | Excel Worksheet Functions |