Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

. For the data below, complete the following Age 34 43 49 51 65 Bone Density 946

ID: 3206256 • Letter: #

Question

. For the data below, complete the following

Age

34

43

49

51

65

Bone Density

946

875

804

723

691

a. Draw a scatter plot

b. Estimate the correlation in words (positive, negative, or none)

c. Explain your estimation

d. Calculate the correlation coefficient

e. Explain what the correlation coefficient tells about the data

f. Calculate the coefficient of determination

g. Explain what the coefficient of determination tells about the data

h. Calculate the least-squares regression line

i. Predict the bone density at age 56

Age

34

43

49

51

65

Bone Density

946

875

804

723

691

Explanation / Answer

a) Scatter Plot

b) from above scatter plot we conclude that there is negative correltion between x and y

c) Since ngative correlation between Age and Bone density, if we increase the age the bone density will be decreased.

d)Correltaion coefficient

From Excel

Correlation coefficient = -0.94

Age Bone Density Age 1 Bone Density -0.93962 1