Question 251780
I assumed your first column was X information and your second column was Y information. To solve this, we need several pieces of information: n, Xbar, Y bar, SUM(XY), SUM(X^2), SUM(Y^2).

n = 9
{{{average(X)}}} = 51
{{{average(Y)}}} = 136.3333
{{{SUM(XY)}}} = 63544
{{{SUMX^2)}}} = 24059
{{{SUM(Y^2)}}} = 168843

r^2 = [SUM(XY) - nXbarYbar)^2] / [(SUM(X^2) - nXbar^2)(SUM(Y^2) - nYbar^2)]

If all numbers are put in correctly and then a square root is taken, you should end up with

r ~ .95968627 ~ .96.