A B C D E F G H K L 1 Treatment Change in LDL cholesterol (mg/dL) 2 Low-cholesterol diet This sheet contains data on the assigned treatment and 0.2 3 Low-cholesterol diet -11.0 the concentration of LDL cholesterol in a person's blood 4 Low-cholesterol diet -17.5 (sample size = 50 people per treatment group). 5 Low-cholesterol diet -15.3 6 Low-cholesterol diet 11.6 7 Low-cholesterol diet -25.2 These data will be used for assignment questions 9-13. 8 Low-cholesterol diet 38.5 9 Low-cholesterol diet -15.2 Use the Excel sheet (tab) labeled "Question 9" and 10 Low-cholesterol diet 12.1 11 Low-cholesterol diet 18.2 "Q10-13 LDL Cholesterol Change" for all calculations, 12 Low-cholesterol diet -1.8 modeling, and graphing. 13 Low-cholesterol diet -9.9 14 Low-cholesterol diet -5.8 15 Low-cholesterol diet 3.5 16 Low-cholesterol diet -22.5 17 Low-cholesterol diet 27.1 18 Low-cholesterol diet -23.9 19 Low-cholesterol diet 14.0 20 Low-cholesterol diet -24.7 21 Low-cholesterol diet 47.0 22 Low-cholesterol diet 11.1 23 Low-cholesterol diet 31.4 24 Low-cholesterol diet 32.1 25 Low-cholesterol diet -20.3 26 Low-cholesterol diet 13.4 27 Low-cholesterol diet 35.9 28 Low-cholesterol diet -17.4 29 Low-cholesterol diet -20.3 30 Low-cholesterol diet -6.3A B C D E F G H K L JU LOW-CHOTeSterOf uret 31 Low-cholesterol diet -11.7 32 Low-cholesterol diet -34.3 33 Low-cholesterol diet -5.2 34 Low-cholesterol diet -7.7 35 Low-cholesterol diet 13.4 36 Low-cholesterol diet 23.5 37 Low-cholesterol diet -24.7 38 Low-cholesterol diet 30.6 39 Low-cholesterol diet 11.3 40 Low-cholesterol diet -13.1 41 Low-cholesterol diet 5.5 42 Low-cholesterol diet -24.7 43 Low-cholesterol diet -3.7 44 Low-cholesterol diet 7.1 45 Low-cholesterol diet -4.7 46 Low-cholesterol diet -2.7 47 Low-cholesterol diet -32.0 48 Low-cholesterol diet 6.4 49 Low-cholesterol diet -48.5 50 Low-cholesterol diet 1.6 51 Low-cholesterol diet -34.4 52 Low-saturated-fat diet -38.4 53 Low-saturated-fat diet -35.3 54 Low-saturated-fat diet 16.0 55 Low-saturated-fat diet 16.2 56 Low-saturated-fat diet -38.2 57 Low-saturated-fat diet -18.1 58 Low-saturated-fat diet 0.7 59 Low-saturated-fat diet 2.5\fA B C D E F G H K L 87 Low-saturated-fat diet -52.8 88 Low-saturated-fat diet -17.7 89 Low-saturated-fat diet 2.9 90 Low-saturated-fat diet -52.4 91 Low-saturated-fat diet -14.0 92 Low-saturated-fat diet -28.3 93 Low-saturated-fat diet 23.9 94 Low-saturated-fat diet -25.7 95 Low-saturated-fat diet -19.0 96 Low-saturated-fat diet -3.6 97 Low-saturated-fat diet 10.3 98 Low-saturated-fat diet 4.0 99 Low-saturated-fat diet -5.9 100 Low-saturated-fat diet -35.4 101 Low-saturated-fat diet -5.7 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116These are for questions 18. Use the information provided in Figure 2 and legend to determine the amount of drug to provide to your patient. What drug dosage (mg/d) must be administered to reduce the concentration of LDL cholesterol in the blood by 60 mg/dL? m N o ;AN 10 11| Note: The drug has no effect on LDL cholesterol in the body at dosages of 4.0 mg/d or less, so be sure to add 4.0 12| mg/d to your final answer no matter what. 13 14] . : . ; - : ) ! o e Hint: This question requires multiple steps. First, you need to determine the change in enzyme activity needed to 15| reduce LDL cholesterol. Then, determine the change in cholesterol transport rate needed to achieve the change 17| in enzyme activity. 18 19 20 21 22 23 24 25 26 27 Desired Cholesterol Reduction in Blood Use this Excel sheet for calculations. Do not round intermediate results... However, round the final calculated drug dose to the nearest whole number. For example, if you calculate the value as 3.8, round to 4 Calculation 28 |Effect of Drug Dose on Rate of Cholesterol Import 29 30 Desired Rate of Transport Calculation 31 |Rate of Transport into Liver Cells 29 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Hint: This question requires multiple steps. First, you need to determine the change in enzyme activity needed to reduce LDL cholesterol. Then, determine the change in cholesterol transport rate needed to achieve the change in enzyme activity. Use this Excel sheet for calculations. Do not round intermediate results... However, round the final calculated drug dose to the nearest whole number. For example, if you calculate the value as 3.8, round to 4 Desired Cholesterol Reduction in Blood Calculation Effect of Drug Dose on Rate of Cholesterol Import Desired Rate of Transport Calculation Rate of Transport into Liver Cells Dose of Drug Total dose Qis