O AutoSave OFF ... Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 12 A A Paste BI U V v A = = A1 X V fx Individual C E F G H A B D Individual Age Systolic blood pressure 1 39 144 w 220 IN 47 3 45 138 4 47 145 5 65 162 6 46 142 00 7 67 170 8 42 124 10 9 67 158 11 10 56 154 11 64 162 13 12 56 150 14 13 59 140 15 14 34 110 16 15 42 128 17 16 48 130 18 17 45 135 19 18 17 114 20 19 20 116 21 20 19 124 22 21 36 136 23 22 50 142 24 23 39 120 25 24 21 120 26 25 44 160 27 26 53 158 28 27 63 144 29 28 29 130 30 29 25 125 31 30 69 175 32CHALLENGE ' ACTIVITY I 2.3.3: Excel: Resnduals. Click this link to download the spreadsheet for use in this activity. 402868.2594496.qx32qy7 The systolic blood pressure dataset (in the third sheet of the spreadsheet linked above) contains the systolic blood pressure and age of 30 randomly selected patients in a medical facility. What is the equation for the least square regression line where the independent or predictor variable is age and the dependent or response variable is systolic blood pressure? g: Ex:'l.234 3 32+ Ex:'l.234 3 Patient 9 is 67 years old and has a systolic blood pressure of 158 mm Hg. What is the residual? Ex:1.234 3 mm Hg Is the actual value above, below, or on the line? Pick 3 What is the interpretation of the residual? Pick