(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?

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

questions d e f g 

2. For this question use the following set of data points. Use Excel's CORREL function to
find the value of the correlation coefficient.
x |1112 2 2 333 10
12312 3 123 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. x |1112 2 2 333 10 12312 3 123 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 1 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
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt