(a) Obtain a scatter plot of the 10 data points. (b) Find the value of the correlation coefficient for the 10 data points. (c) Use Excel with a = 0.05 to determine if there is a linear correlation.

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter4: Equations Of Linear Functions
Section4.5: Correlation And Causation
Problem 24PFA
icon
Related questions
Question
2. For this question use the following set of data points. Use Excel's CORREL function to
find the value of the correlation coefficient.
1
1
2 2 3 3 3 10
1
2
3
1
3
1
2
3
10
(a) Obtain a scatter plot of the 10 data points.
(b) Find the value of the correlation coefficient for the 10 data points.
(c) Use Excel with a = 0.05 to determine if there is a linear correlation.
Now remove the point with coordinates (10, 10) so there are 9 pairs of points.
(d) Obtain a scatter plot of the 9 data points.
(e) Find the value of the correlation coefficient for the 9 data points.
(f) Use Excel with a =
0.05 to determine if there is a linear correlation.
(g) What conclusion do you make about the possible effect of a single pair of values?
Transcribed Image Text:2. For this question use the following set of data points. Use Excel's CORREL function to find the value of the correlation coefficient. 1 1 2 2 3 3 3 10 1 2 3 1 3 1 2 3 10 (a) Obtain a scatter plot of the 10 data points. (b) Find the value of the correlation coefficient for the 10 data points. (c) Use Excel with a = 0.05 to determine if there is a linear correlation. Now remove the point with coordinates (10, 10) so there are 9 pairs of points. (d) Obtain a scatter plot of the 9 data points. (e) Find the value of the correlation coefficient for the 9 data points. (f) Use Excel with a = 0.05 to determine if there is a linear correlation. (g) What conclusion do you make about the possible effect of a single pair of values?
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill