Construct a scatter plot using excel for the given data.Determine whether there
ID: 2955039 • Letter: C
Question
Construct a scatter plot using excel for the given data.Determine whether there is a positive linear correlation, negativelinear correlation, or no linear correlation. Complete the tableand find the correlation coefficient r. The data for x and y isshown 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 (3 points)
b: Type of correlation (positive linear correlation,negative linear correlation, or no linear correlation) (2points)
c: Complete the table and find the correlation coefficientr.
x
y
xy
x2
y2
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
=
x
11
-6
8
-3
-2
1
5
-5
6
7
y
-5
-3
4
1
-1
-2
0
2
3
-4
Explanation / Answer
x.P5="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 8px; padding-right: 0px; padding-bottom: 8px; padding-left: 0px; list-style-type: none; list-style-position: initial; list-style-image: initial; color: rgb(50, 60, 59); font-family: Georgia, Palatino, serif; font-size: 15px; line-height: 26px; border-collapse: collapse; ">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.