[See Steps] Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation,
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.
| x | 11 | -6 | 8 | -3 | -2 | 1 | 5 | -5 | 6 | 7 |
| y | -5 | -3 | 4 | 1 | -1 | -2 | 0 | 2 | 3 | -4 |
a: Scatter plot
b: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation)
c: Complete the table and find the correlation coefficient r.
| x | y | xy | x 2 | y 2 |
| 11 | -5 | |||
| -6 | -3 | |||
| 8 | 4 | |||
| -3 | 1 | |||
| -2 | -1 | |||
| 1 | -2 | |||
| 5 | 0 | |||
| -5 | 2 | |||
| 6 | 3 | |||
| 7 | -4 | |||
Use the last row of the table to show the column totals.
n = 10
Deliverable: Word Document 