conditional probabilities calculation

Having known 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.