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.
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowLooking 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