One of the simplest and most common statistical Excel calculations you might make is correlation. It’s a simple statistic, but it can be very informative when you want to see if two variables are related. If you know the right commands, find the correlation coefficient in Excel is extremely easy. We’ll take a look at what correlation is to give you an idea of the information that it gives you. Then we’ll move on to finding correlation coefficient in Excel using two methods and a good graph for looking at correlations. Finally, I’ll give you a very quick introduction to linear regression, another...
Read the full article: How to Find the Correlation Coefficient With Excel
from MakeUseOf http://ift.tt/2GN7Jfs
via IFTTT
No comments:
Post a Comment