- 2 For This Question Use The Following Set Of Data Points Use Excel S Correl Function To Find The Value Of The Correlat 1 (205.82 KiB) Viewed 23 times
2. For this question use the following set of data points. Use Excel's CORREL function to find the value of the correlat
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
2. For this question use the following set of data points. Use Excel's CORREL function to find the value of the correlat
2. For this question use the following set of data points. Use Excel's CORREL function to find the value of the correlation coefficient. 2 3 2 1 1 1 2 2 y 1 2 3 1 2 3 3 2 3 10 10 3 1 (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?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!