Question

Solution 1 of 2 You were asked to calculate the correlation coefficient, r.

Completion Percentage 55.5 57 58 58.5 59 Interception Percentage 5 4 2.5 2 1.5

To find r, you can use the formula, a scientific calculator, or statistical software. To use the formula, we should first determine n, ∑xy, ∑x, ∑y, ∑x2, and ∑y2. Since we have 5 data points, n=5. In this case our x-values are "Completion Percentage" and our y-values are "Interception Percentage", so we calculate the following.

∑xy=277.5+228+145+117+88.5=856

∑x=55.5+57+58+58.5+59=288

∑y=5+4+2.5+2+1.5=15

∑x2=3080.25+3249+3364+3422.25+3481=16596.5

∑y2=25+16+6.25+4+2.25=53.5

Answer 1

USING EXCEL FORMULA =CORREL WE GET r =-0.989