Page 1 of 1
2. For this question use the following set of data points. Use Excel's CORREL function to find the value of the correlat
Posted: Mon Apr 11, 2022 6:22 am
by answerhappygod
- 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 19 times
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?