Conditional Probabilities Calculation

Having read and analyzed the concept of probability, consider the case given below.

Hyperlipidemia in children has been hypothesized to be related to high cholesterol in their parents. The following data were collected on parents and children.

Child

Both parents hyperlipidemic

One parent hyperlipidemic

Neither parent hyperlipidemic

Not hyperlipidemic

13

34

83

Hyperlipidemic

45

42

6

Considering these data, answer the questions:

1. What is the probability that one or both parents are hyperlipidemic?
2. What is the probability that the child and both parents are hyperlipidemic?
3. What is the probability that a child is hyperlipidemic if neither of his/her parents are hyperlipidemic?
4. What is the probability that a child is hyperlipidemic if both of his/her parents are hyperlipidemic?
5. Based on your calculation, what conclusion can you infer?

Present the calculations and answers in Excel spreadsheet format or in Word format. Write the interpretation of results in a Word document.