Biostatistics

Assignment 2: Conditional Probabilities CalculationHaving 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.ChildBoth parents hyperlipidemicOne parent hyperlipidemicNeither parent hyperlipidemicNot hyperlipidemic133483Hyperlipidemic45426Considering these data, answer the questions:What is the probability that one or both parents are hyperlipidemic?What is the probability that the child and both parents are hyperlipidemic?What is the probability that a child is hyperlipidemic if neither of his/her parents are hyperlipidemic?What is the probability that a child is hyperlipidemic if both of his/her parents are hyperlipidemic?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 format.Assignment 2 Grading CriteriaProficientMaximum PointsCompute the following:What is the probability that one or both parents are hyperlipidemic?What is the probability that the child and both parents are hyperlipidemic?What is the probability that a child is hyperlipidemic if neither of his/her parents are hyperlipidemic?What is the probability that a child is hyperlipidemic if both of his/her parents are hyperlipidemic?Correctly calculated all the specified values.40Based on your calculation, summarize what conclusion you can infer.All conclusions summarized are appropriate and based on the calculations.40Academic WritingWrite in a clear, concise, and organized manner; demonstrate ethical scholarship in accurate representation and attribution of sources (i.e., APA); and display accurate spelling, grammar, and punctuation.Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in appropriate and accurate representation and attribution of sources; and displayed accurate spelling, grammar, and punctuation. Use of scholarly sources aligns with specified assignment requirements.20Total:100