[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

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in