Description
Excel Exercise Module/Week 5
Refer to the Scatterplot and Regressions 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 of weights for Wt_Grp_3?_______1 pt.
True/False. The slope of the regression line is 114.283 and the y-intercept is 0.1128 ______1 pt
If you plugged the value x = 300 into the regression equation shown on the scatterplot, what would be the numeric result?______2 pt.
True/False. According to the trend line where x represents weight and y represents diastolic pressure, a 300lb participant would have diastolic pressure of less than 150. ______1pt.
Based on the appearance of the scatterplot would you say weight is a good predictor of blood pressure for this sample? _____ 2 pts.
Looking at the Regression Tab, what cell (E.g. E12) in this sheet tells you that weight group 3 does not have a linear relation in terms of weight vs diastolic pressure? _____2 pts
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Refer to the Scatterplot and Regressions tabs to answer the following questions.
Looking at the scatterplot what is the maximum value for systolic blood pressure?__150___1 pt.
Looking at the sc...