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 Now

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

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.