Thread: Probability
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
roystonteo via OfficeKB.com roystonteo via OfficeKB.com is offline
external usenet poster
 
Posts: 8
Default Probability

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