Helen C. answered • 01/23/21

Emphasis on Individual - Secondary Mathematics and Statistics Tutor

Easiest way to get this solution is to use Excel or a similar software. Will show both ways to illustrate how the correlation coefficient is derived. Using the following formula, with n = 8.

r = [ n(Σxy) - ΣxΣy ] / square root ( [nΣx^{2} - (Σx^{2})] [nΣy^{2} - (yx^{2})] )

With the summations in Excel, we have

results in r = .3909

Alternatively, you can use Excel CORREL function, select all x's for one array and all y's for second array, that is =CORREL(A2:A9,B2:B9) = .3909