I need help with this question, here is the question and the data chart:

Q 3 spreadsheets_linear_regression (1) AutoSave OFF View Tell me Update Apple ID Settings Home Insert Draw Page Layout Formulas Data Review Some account services will not be View Z Ir available until you sign in again. Calibri (Body) v 12 AA ap Wrap Text v General x Delete Find & = $ ~ % " Conditional Format Cell Sort & Analyze Sensitivity Merge & Center v Format v Filter Select Data Paste BIUV DV Av E Formatting as Table Styles A1 X V fx Sepal length P R S T U D F G H I J K L M N Q A B Sepal length Sepal width Petal length Petal width Species 5.1 3.5 1.4 0.2 Iris-setosa 4. 3 1.4 0.2 Iris-setosa 3.2 1.3 0.2 Iris-setosa 4.6 3.1 1.5 0.2 Iris-setosa 5 3.6 1.4 0.2 Iris-setosa 5.4 3.9 1.7 0.4 Iris-setosa 4.6 3.4 1.4 0.3 Iris-setosa 5 3.4 1.5 0.2 Iris-setosa 4.4 2.9 1.4 0.2 Iris-setosa 4.9 3.1 1.5 0.1 Iris-setosa 5.4 3.7 1.5 0.2 Iris-setosa 4.8 3.4 1.6 0.2 Iris-setosa 4.8 1.4 0.1 Iris-setosa 4.3 1.1 0.1 Iris-setosa 5.8 1.2 0.2 Iris-setosa 5.7 4.4 1.5 0.4 Iris-setosa 5.4 3.9 1.3 0.4 Iris-setosa 5 .1 3.5 1.4 0.3 Iris-setosa 5.7 3.8 1.7 0.3 Iris-setosa 5.1 3.8 1.5 0.3 Iris-setosa 5.4 3.4 1.7 0.2 Iris-setosa 5 .1 3.7 1.5 0.4 Iris-setosa 4.6 3.6 0.2 Iris-setosa 5.1 3.3 1.7 0.5 Iris-setosa 4.8 3.4 1.9 0.2 Iris-setosa 3 1.6 0.2 Iris-setosa 5 3.4 1.6 0.4 Iris-setosa 5.2 3.5 1.5 0.2 Iris-setosa 5.2 3.4 1.4 0.2 Iris-setosa 3.2 1.6 0.2 Iris-setosa 4.8 3.1 1.6 0.2 Iris-setosa 5.4 3.4 1.5 0.4 Iris-setosa 5.2 4.1 1.5 0.1 Iris-setosa 5.5 4.2 1.4 0.2 Iris-setosa 49 3.1 1.5 0.1 Iris-setosa 5 3.2 1.2 0.2 Iris-setosa 5.5 3.5 1.3 0.2 Iris-setosa 4.9 3.1 1.5 0.1 Iris-setosa 4.4 3 1.3 0.2 Iris-setosa 51 3.4 1.5 0.2 Iris-setosa Iris Cricket chirps vs temperature Systolic blood pressure + + 100% ReadyQ 3 spreadsheets_linear_regression (1) AutoSave OFF View Tell me Update Apple ID Settings Home Insert Draw Page Layout Formulas Data Review Some account services will not be View Z Ir available until you sign in again. General Calibri (Body) v 12 AA ap Wrap Text v x Delete Cell Sort & Find & Analyze Sensitivity Conditional Format Data Paste BIUV DV Av E = Merge & Center v $ ~ % " Formatting as Table Styles Format v Filter Select A1 X V fx Sepal length K L M N P Q R S T U G H I J A B D F 40 4.4 3 0.2 Iris-setosa 41 5.1 3.4 1.5 0.2 Iris-setosa 42 5 3.5 1.3 0.3 Iris-setosa 43 4.5 2.3 1.3 0.3 Iris-setosa 44 4.4 3.2 1.3 0.2 Iris-setosa 5 3.5 1.6 0.6 Iris-setosa 5.1 3.8 1.9 0.4 Iris-setosa 4.8 3 1.4 0.3 Iris-setosa 5.1 3.8 1.6 0.2 Iris-setosa 4. 3.2 1.4 0.2 Iris-setosa 5.3 3.7 1.5 0.2 Iris-setosa 3.3 1.4 0.2 Iris-setosa 3.2 4.7 1.4 Iris-versicolor 6.4 3.2 4.5 1.5 Iris-versicolor 6.9 3.1 4.9 1.5 Iris-versicolor 5.5 2.3 4 1.3 Iris-versicolor 6 .5 2.8 4.6 1.5 Iris-versicolor 5.7 2.8 4.5 1.3 Iris-versicolor 6 .3 3.3 4.7 1.6 Iris-versicolor 4.9 2.4 3.3 1 Iris-versicolor 6.6 2.9 4.6 1.3 Iris-versicolor 5.2 2.7 3.9 1.4 Iris-versicolor 5 2 3.5 1 Iris-versicolor 59 4.2 1.5 Iris-versicolor 6 2.2 4 1 Iris-versicolor 6.1 2.9 4.7 1.4 Iris-versicolor 5. 2.9 3.6 1.3 Iris-versicolor 6.7 3.1 4.4 1.4 Iris-versicolor 5.6 3 4.5 1.5 Iris-versicolor 5.8 2.7 4.1 1 Iris-versicolor 6.2 2.2 4.5 1.5 Iris-versicolor 5.6 2.5 3.9 1.1 Iris-versicolor 5.9 3.2 4.8 1.8 Iris-versicolor 2.8 4 1.3 Iris-versicolor 6.3 2.5 4.9 1.5 Iris-versicolor 6.1 2.8 4.7 1.2 Iris-versicolor 76 6.4 4.3 1.3 Iris-versicolor 6.6 3 4.4 1.4 Iris-versicolor 78 6.8 2.8 4.8 1.4 Iris-versicolor 79 5.7 3 5 1.7 Iris-versicolor 80 1.5 Iris-versicolor Cricket chirps vs temperature + Iris Systolic blood pressure - + 100% ReadyQ 3 spreadsheets_linear_regression (1) AutoSave OFF Update Apple ID Settings Home Insert Draw Page Layout Formulas Data Review View Tell me Some account services will not be View Z Ir available until you sign in again. Calibri (Body) v 12 AA ap Wrap Text General x Delete Conditional Format Cell Sort & Find & Analyze Sensitivity Paste BIUV DV Av E = Merge & Center v $ ~ % " Format v Filter Select Data Formatting as Table Styles A1 X V fx Sepal length T U L M N 0 P Q R S A B E F G H I J K CO 84 2.7 3.9 1.2 Iris-versicolor 85 6 27 5.1 1.6 Iris-versicolor 86 5.4 3 4.5 1.5 Iris-versicolor 87 6 3.4 4.5 1.6 Iris-versicolor 6.7 3.1 4.7 1.5 Iris-versicolor 6.3 2.3 4.4 1.3 Iris-versicolor 5.6 3 4.1 1.3 Iris-versicolor 5.5 2.5 4 1.3 Iris-versicolor 5.5 2.6 4.4 1.2 Iris-versicolor 6.1 3 4.6 1.4 Iris-versicolor 58 2.6 4 1.2 Iris-versicolor 5 2.3 3.3 1 Iris-versicolor 5.6 2.7 4.2 1.3 Iris-versicolor 5.7 3 4.2 1.2 Iris-versicolor 5.7 2.9 4.2 1.3 Iris-versicolor 6.2 2.9 4.3 1.3 Iris-versicolor 100 5.1 2.5 3 1.1 Iris-versicolor 101 2.8 4.1 1.3 Iris-versicolor 102 6.3 3.3 6 2.5 Iris-virginica 103 5 .8 2.7 5.1 1.9 Iris-virginica 104 7.1 3 5.9 2.1 Iris-virginica 105 6.3 2.9 5.6 1.8 Iris-virginica 106 6.5 5.8 2.2 Iris-virginica 107 7.6 3 6.6 2.1 Iris-virginica 108 4.9 2.5 4.5 1.7 Iris-virginica 109 7.3 2.9 6.3 1.8 Iris-virginica 110 6.7 2.5 5.8 1.8 Iris-virginica 111 7.2 3.6 6.1 2.5 Iris-virginica 112 6.5 3.2 5.1 2 Iris-virginica 113 2.7 5.3 1.9 Iris-virginica 114 6.8 3 5.5 2.1 Iris-virginica 115 5.7 2.5 5 2 Iris-virginica 116 5 .8 2.8 5.1 2.4 Iris-virginica 117 6.4 3.2 5.3 2.3 Iris-virginica 118 6.5 3 5.5 1.8 Iris-virginica 119 7.7 3.8 6.7 2.2 Iris-virginica 120 7.7 2.6 6.9 2.3 Iris-virginica 121 6 2.2 5 1.5 Iris-virginica 122 6.9 3.2 5.7 2.3 Iris-virginica 123 5 6 28 4.9 2 Iris-virginica 124 iroinica Iris Cricket chirps vs temperature Systolic blood pressure + + 100% ReadyQ 3 spreadsheets_linear_regression (1) AutoSave OFF Update Apple ID Settings Review View Tell me View Home Insert Draw Page Layout Formulas Data Some account services will not be Z Ir available until you sign in again. Calibri (Body) v 12 AA = ap Wrap Text General x Delete Sort & Find & Analyze Sensitivity Conditional Format Cell $ ~ % " Format v Filter Select Data Paste BIUV DV Av E = Merge & Center v Formatting as Table Styles A1 X V fx Sepal length R S T U E F G H I J K L M N 0 P Q A B D 7.7 R'S 6.7 2.2 Iris-virginica 119 120 7.7 2.6 6.9 2.3 Iris-virginica 121 6 2.2 5 1.5 Iris-virginica 122 6.9 3.2 5.7 2.3 Iris-virginica 123 5.6 2.8 4.9 2 Iris-virginica 124 7.7 2.8 6.7 2 Iris-virginica 125 6.3 2.7 4.9 1.8 Iris-virginica 126 6.7 3.3 5.7 2.1 Iris-virginica 127 7.2 3.2 6 1.8 Iris-virginica 128 6.2 2.8 4.8 1.8 Iris-virginica 129 3 4.9 1.8 Iris-virginica 130 6.4 2.8 5.6 2.1 Iris-virginica 131 7.2 3 5.8 1.6 Iris-virginica 132 7.4 2.8 6.1 1.9 Iris-virginica 133 7.9 3.8 6.4 2 Iris-virginica 134 6.4 2.8 5.6 2.2 Iris-virginica 135 6.3 2.8 5.1 1.5 Iris-virginica 136 2.6 5.6 1.4 Iris-virginica 137 7.7 3 6.1 2.3 Iris-virginica 138 6.3 3.4 5.6 2.4 Iris-virginica 139 6.4 3.1 5.5 1.8 Iris-virginica 140 6 3 4.8 1.8 Iris-virginica 141 6.9 3.1 5.4 2.1 Iris-virginica 142 6.7 3.1 5.6 2.4 Iris-virginica 143 6.9 3.1 5.1 2.3 Iris-virginica 144 5.8 2.7 5.1 1.9 Iris-virginica 145 6.8 3.2 5.9 2.3 Iris-virginica 146 3.3 5.7 2.5 Iris-virginica 147 6.7 3 5.2 2.3 Iris-virginica 148 6.3 2.5 5 1.9 Iris-virginica 149 6.5 3 5.2 2 Iris-virginica 150 6.2 3.4 5.4 2.3 Iris-virginica 151 5.9 3 5.1 1.8 Iris-virginica 152 153 154 155 156 157 158 159 + Iris Cricket chirps vs temperature Systolic blood pressure - + 100% Ready(5) Fred & Rosemary West And X Course Hero B 2-1 discussion - SCI-215-H568 X zy Section 2.3 - MAT 240: Applied X + a learn.zybooks.com/zybook/SNHUMAT240Master1/chapter/2/section/3 Update Apple ID Settings Some account services will not be View available until you sign in again. =zyBooks My library > MAT 240: Applied Statistics home > 2.3: Least squares method zyBooks catalog CHALLENGE Search zyBook ACTIVITY 2.3.3: Excel: Residuals. About this Material Click this link to download the spreadsheet for use in this activity. 1) Module 1 - Descriptive V Statistics Jump to level 1 2) Module 2 - Linear Regression 2.1 Scatter plots The systolic blood pressure dataset (in the third sheet of the spreadsheet linked above) contail 2.2 Introduction to linear regression pressure and age of 30 randomly selected patients in a medical facility. 2.3 Least squares method What is the equation for the least square regression line where the independent or predictor va Print chapter dependent or response variable is systolic blood pressure? 3) Module 3 - More on y = Ex: 1.234 * + Ex: 1.234 Linear Regression Patient 1 is 39 years old and has a systolic blood pressure of 144 mm Hg. What is the residua 4) Module 4 - Normal Distribution Ex: 1.234 mm Hg 5) Module 5 - Hypothesis Is the actual value above, below, or on the line? v Pick Testing Above What is the interpretation of the residual? Below 6) Module 6 - Confidence V Pick On Intervals 7) Module 7 - Hypothesis V Testing with Population Proportions 1 8) Module 8 - Hypothesis V Testing with Two Check Try again Population 9 ) Appendix A: Distribution V Tables Feedback?(5) Fred & Rosemary West And X Course Hero B 2-1 discussion - SCI-215-H568 X zy Section 2.3 - MAT 240: Applied X + a learn.zybooks.com/zybook/SNHUMAT240Master1/chapter/2/section/3 Update Apple ID Settings Some account services will not be View available until you sign in again. =zyBooks My library > MAT 240: Applied Statistics home > 2.3: Least squares method zyBooks catalog CHALLENGE Search zyBook ACTIVITY 2.3.3: Excel: Residuals. About this Material Click this link to download the spreadsheet for use in this activity. 1) Module 1 - Descriptive V Statistics Jump to level 1 2) Module 2 - Linear Regression 2.1 Scatter plots The systolic blood pressure dataset (in the third sheet of the spreadsheet linked above) contail 2.2 Introduction to linear regression pressure and age of 30 randomly selected patients in a medical facility. 2.3 Least squares method What is the equation for the least square regression line where the independent or predictor va Print chapter dependent or response variable is systolic blood pressure? 3) Module 3 - More on y = Ex: 1.234 ac + EX: 1.234 Linear Regression Patient 1 is 39 years old and has a systolic blood pressure of 144 mm Hg. What is the residua 4) Module 4 - Normal Distribution Ex: 1.234 mm Hg 5) Module 5 - Hypothesis Is the actual value above, below, or on the line? Pick Testing What is the interpretation of the residual? 6) Module 6 - Confidence V Pick Intervals Difference in actual and predicted blood pressures for a given age 7) Module 7 - Hypothesis V Difference in age between random people in the sample Testing with Population The amount systolic blood pressure changes as age increases Proportions 8) Module 8 - Hypothesis V Testing with Two Check Try again Population 9 ) Appendix A: Distribution V Tables Feedback