CHALLENGE 2.3.3: Excel: Residuals. File Home Insert Draw ACTIVITY 12 v B A v Click this link to download the spreadsheet for use in this activity. A1 * X V fx Individuz 427668.2838184.qx3zqy7 A B D Start Individual Age Systolic blood pressure 1 39 144 2 220 3 45 138 4 47 145 5 65 162 The systolic blood pressure dataset (in the third sheet of the spreadsheet linked above) contain 6 46 142 7 67 170 pressure and age of 30 randomly selected patients in a medical facility. 8 42 124 LD 67 158 11 56 154 What is the equation for the least square regression line where the independent or predictor var 10 12 64 162 dependent or response variable is systolic blood pressure? 13 56 150 14 13 140 15 14 34 110 y = Ex: 1.234 Ex+ Ex: 1.234 16 15 42 128 17 16 48 130 Patient 2 is 47 years old and has a systolic blood pressure of 220 mm Hg. What is the residual" 18 17 45 135 19 18 17 114 20 19 20 116 Ex: 1.234 mm Hg 21 20 19 124 22 21 36 136 Is the actual value above, below, or on the line? Pick v 23 22 50 142 24 23 39 120 25 24 21 120 What is the interpretation of the residual? 26 25 44 160 26 53 158 Pick 28 27 63 144 28 29 130 30 29 25 125 30 69 175