Excel Exercise Week 5Refer to the Scatterplot Regressio

Excel Exercise Week 5Refer to the Scatterplot Regressions and Correlations tabs to answer the following questions.Looking at the scatterplot what is the maximum value for systolic blood pressure?___1 pt.Looking at the scatterplot what is the range for Wt_Grp_3?_____1 pt.Looking at the scatterplot what does the 0.1128 value in the equation refer to in the Regressions tab?____1 ptLooking at the scatterplot what does the 114.283 value in the equation refer to in the Regressions tab?____1 pt.Plug the value 164 into the regression equation shown on the scatterplot. What is the result____1 pt.The value for correlation in the Correlations tab corrsponds to what measure shown in the Regressions tab? ______ 1pt.Based on the appearance of the scatterplot would you say weight is a good predictor of blood pressure for this sample? ___ 2 pts.Why or why not? _____________________________________________ 2 ptsHLTH 501Page 1 of 1
Attachments: