Regression for excel mac

broken image
broken image

A coefficient of 1 is a perfect positive correlation: as one variable increases, the other also increases proportionally.Īny number between those represents a scale. This is what you should get when you have two sets of random numbers.Ī coefficient of -1 means you have a perfect negative correlation: as one variable increases, the other decreases proportionally. A correlation coefficient of 0 means that there's absolutely no correlation between two variables. The correlation coefficient tells you how related two variables are.

broken image

(Note that it can be the other way around, too if one goes up and the other goes down, that's a negative correlation.) In general, as one variable rises, so does the other.