Question: Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.

The data for x and y is shown below.

a) Scatter plot (3 points)

b) Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation) (2 points)

c) Complete the table and find the correlation coefficient r rounded to 4 decimals.

(5 points)

Use the last row of the table to show the column totals.

n = 10

\[r=\frac{n\sum{xy-\left( \sum{x} \right)\left( \sum{y} \right)}}{\sqrt{n\sum{{{x}^{2}}-{{\left( \sum{x} \right)}^{2}}}}\sqrt{n\sum{{{y}^{2}}-{{\left( \sum{y} \right)}^{2}}}}}\] =