Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I had to create a scatter plot for my statistics class and it will not show me my correlation coefficient. I am new to numbers and do not have excel. Someone please help!!
iPhone 5s, iOS 8.2
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
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.
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.
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?
How do I find the correlation coefficient
