CLARKE_TONOYA_Ph_Act_3_Workbook11.xlsx

Q9 Treatment and LDL

Treatment Change in LDL cholesterol (mg/dL) Dummy Code
Low-cholesterol diet 0.2
Low-cholesterol diet -11.0
Low-cholesterol diet -17.5
Low-cholesterol diet -15.3 Low-Cholesterol Diet
Low-cholesterol diet 11.6 Low-Saturated-Fat Diet
Low-cholesterol diet -25.2 Standard Deviation
Low-cholesterol diet 38.5
Low-cholesterol diet -15.2
Low-cholesterol diet 12.1
Low-cholesterol diet 18.2
Low-cholesterol diet -1.8
Low-cholesterol diet -9.9
Low-cholesterol diet -5.8
Low-cholesterol diet 3.5
Low-cholesterol diet -22.5
Low-cholesterol diet 27.1
Low-cholesterol diet -23.9
Low-cholesterol diet 14.0
Low-cholesterol diet -24.7
Low-cholesterol diet 47.0
Low-cholesterol diet 11.1
Low-cholesterol diet 31.4
Low-cholesterol diet 32.1
Low-cholesterol diet -20.3
Low-cholesterol diet 13.4
Low-cholesterol diet 35.9
Low-cholesterol diet -17.4
Low-cholesterol diet -20.3
Low-cholesterol diet -6.3
Low-cholesterol diet -11.7
Low-cholesterol diet -34.3
Low-cholesterol diet -5.2
Low-cholesterol diet -7.7
Low-cholesterol diet 13.4
Low-cholesterol diet 23.5
Low-cholesterol diet -24.7
Low-cholesterol diet 30.6
Low-cholesterol diet 11.3
Low-cholesterol diet -13.1
Low-cholesterol diet 5.5
Low-cholesterol diet -24.7
Low-cholesterol diet -3.7
Low-cholesterol diet 7.1
Low-cholesterol diet -4.7
Low-cholesterol diet -2.7
Low-cholesterol diet -32.0
Low-cholesterol diet 6.4
Low-cholesterol diet -48.5
Low-cholesterol diet 1.6
Low-cholesterol diet -34.4
Low-saturated-fat diet -38.4
Low-saturated-fat diet -35.3
Low-saturated-fat diet 16.0
Low-saturated-fat diet 16.2
Low-saturated-fat diet -38.2
Low-saturated-fat diet -18.1
Low-saturated-fat diet 0.7
Low-saturated-fat diet 2.5
Low-saturated-fat diet -34.0
Low-saturated-fat diet -45.2
Low-saturated-fat diet -6.7
Low-saturated-fat diet 10.0
Low-saturated-fat diet -6.9
Low-saturated-fat diet -7.2
Low-saturated-fat diet -9.9
Low-saturated-fat diet -25.4
Low-saturated-fat diet -31.9
Low-saturated-fat diet -21.4
Low-saturated-fat diet 9.7
Low-saturated-fat diet 27.3
Low-saturated-fat diet -40.3
Low-saturated-fat diet 25.4
Low-saturated-fat diet -10.5
Low-saturated-fat diet -21.4
Low-saturated-fat diet -0.5
Low-saturated-fat diet -11.8
Low-saturated-fat diet 16.1
Low-saturated-fat diet -34.3
Low-saturated-fat diet 2.6
Low-saturated-fat diet -9.8
Low-saturated-fat diet -18.6
Low-saturated-fat diet 1.5
Low-saturated-fat diet -7.0
Low-saturated-fat diet -17.5
Low-saturated-fat diet -42.7
Low-saturated-fat diet -52.8
Low-saturated-fat diet -17.7
Low-saturated-fat diet -2.9
Low-saturated-fat diet -52.4
Low-saturated-fat diet -14.0
Low-saturated-fat diet -28.3
Low-saturated-fat diet 23.9
Low-saturated-fat diet -25.7
Low-saturated-fat diet -19.0
Low-saturated-fat diet -3.6
Low-saturated-fat diet 10.3
Low-saturated-fat diet 4.0
Low-saturated-fat diet -5.9
Low-saturated-fat diet -35.4
Low-saturated-fat diet -5.7

Use the raw data in this tab to estimate the mean change in the concentration of LDL cholesterol for 1) a person who followed the low cholesterol diet and 2) a person who followed the low saturated fat diet. Additionally, estimate the standard deviation of the linear relationship between the type of diet and the change in the concentration of LDL cholesterol. Create a single plot of a linear relationship between the type of diet (categorical variables: low cholesterol vs. low saturated fat) and the change in the concentration of LDL cholesterol (mg/dL). Refer to Acts 1 and 2 for formatting and rounding instructions. You will be graded on your ability to format figures and utilize formulas to calculate the standard deviation and means.

TA Sheet

TA Use Only
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A
ERROR:#N/A