Question

Bone mineral density and cola consumption has been recorded for a sample of patients. Let x represent the number of colas consumed per week and y the bone mineral density in grams per cubic centimeter. Based on the data shown below answer the questions rounding your final answers to four decimal places. (a) Create a scatter plot with linear regression line for the data. (2 points)

y = -.0028 x + .9264

(b) Interpret the slope of the regression equation in a complete sentence. (2 points)

(c) Use the linear correlation coefficient to determine if there is correlation. (5 points) r = .9010

Is there correlation at the 0.05 level of significance? (2 points) yes no

(d) According to the linear regression equation, the bone density of someone who drinks 22 colas per week is 0.8648

(2 points) Submit a file with your scatter plot below. (5 points)

x y

2 0.92568

3 0.91304

4 0.9144

5 0.90676

6 0.91012

7 0.90348

8 0.91584

9 0.8982

10 0.89756

11 0.89092

12 0.89928

13 0.89064

14 0.881

Answer 1

(a)

Y = 0.92639956043956 -0.00284879120879121 X

Regression run in excel is:

(b)

The slope of the regression line is given by -0.00284879120879121. It is the amount by which the bone density decrease for every additional unit of cola consumed in the week.

(c)

YES, there is correaltion

(d) Y = 0.92639956043956 -0.00284879120879121 *22 = 0.863726153846153

(e) Scatter diagram given above

Please let me know in comments in case anything is unclear. Will reply ASAP. Do upvote if satisfied!