SOLUTION: Based on the data shown below, calculate the correlation coefficient (to three decimal places) independent dependent 4 17.22 5 20.8 6 20.48 7 25.96 8 27.44 9 27.62 10 29 1

Algebra ->  Probability-and-statistics -> SOLUTION: Based on the data shown below, calculate the correlation coefficient (to three decimal places) independent dependent 4 17.22 5 20.8 6 20.48 7 25.96 8 27.44 9 27.62 10 29 1      Log On


   



Question 1196761: Based on the data shown below, calculate the correlation coefficient (to three decimal places)
independent dependent
4 17.22
5 20.8
6 20.48
7 25.96
8 27.44
9 27.62
10 29
11 34.28
12 33.96
13 35.44
14 39.92

Answer by ewatrrr(24785) About Me  (Show Source):
You can put this solution on YOUR website!

Hi
Using Excel Spreadsheet, entering Data is 2 Columns and using the CORREL function:
=CORREL(x's, y's)
5	20.8
6	20.48
7	25..96
8	27.44
9	27.62
10	29
11	34.28
12	33.96
13	35.44
14	39.9
	
r = 0.986183776  0r r = .986 	(to three decimal places)

Wish You the Best in your Studies.