For this question use the following set of data points.

x 10 8 13 9 11 14 6 4 12 7 5

y 9.14 8.14 8.74 8.77 9.26 8.1 6.13 3.10 9.13 7.26 4.74

(a) Find the value of the linear correlation coefficient r.

(b) Use Table A-6 on page 778 and = 0.05 to determine if there is evidence to support the claim of a linear correlation between the two variables.

(c) Obtain a scatter plot and add a trend line. Display the equation of the line on the plot

(d) Which feature of the data would be missed if part (a) was completed without constructing a scatter plot?

Answer in full steps and attach Excel files