How do I find the correlation coefficient

While I'm sure it's too late for the guy who asked the question, here is the answer for future folks:

R^2 is the Coefficient of Determination, and is related, but not the same thing as the Linear Correlation Coefficient (usually represented as 'r').

The LCC is found in Numbers with the "=CORELL()" function.

You select the chart, then add a trendline. Use the settings similar to what I show here:

I believe you are asking about the R^2 value

Thanks, Matthew, for that clarification!

Here's a demonstration using the sample data for CORREL at Help > Formulas and Functions Help.

My statistics knowledge gets a little hazy from disuse (misuse!), but one thing that R shows that R^2 doesn't seems to be direction (i.e. it's negative here).

SG

Yeah, absolutely. The r value represents suggestion of a linear relationship in the data. 1 or -1 would represent a perfect positive or negative linear relationship (which is ideal and basically impossible in real life). In rough terms R^2 represents the strength of your linear model as a percentage.

Maybe this thread will help.

Also this tutorial.

SG

How do you move the data to an open area of the chart? I was able to highlight it, but I couldn't move it.

Thanks! But does anyone know how to easily obtain the corresponding p-value? Is there a formula for that as well?