In this tutorial, you will learn how to find correlation in Google Sheets.
If you work with two data sets in Google Sheets, you might want to compare the two by finding the correlation between them. Correlation is a statistical relationship between two data sets that may or may not imply causation but can still be useful in understanding if there is a predictive relationship between the data sets.
The math behind calculating correlation is a little complex, but fortunately there’s a Google Sheets Function that makes it easy to quickly find correlation. Read on to learn how.
Here’s how to find the correlation between two data sets in Google Sheets:
Enter the two data sets in separate columns
The function for finding correlation is CORRELL(). It takes two input ranges for the two data sets to find correlation between. So if our data sets are stored in ranges A2:A and B2:B, the formula is “=CORREL(A2:A12,B2:B12)”. Type this into a cell and hit enter.
The correlation will appear in the cell, but will likely have a lot of decimal places displayed. Use the Decrease Decimal Places button in the toolbar to reduce the decimal places as needed
Once you’ve found correlation, it’s important to understand what it means. Here are some points to help understand what a correlation means:
- Correlations range from -1 to 1, with greater absolute value implying stronger correlation
- Positive correlations like in the example above indicate a positive correlation, meaning that a higher measurement in one data set will lead to a higher measurement in the other
- Negative correlations mean a higher measurement in one data set will mean a lower not higher measurement in the other
- Strong correlation values do not necessarily mean there is a causal link between the data sets. There may be a hidden variable at work that affects both data sets, or the correlation may be a statistical fluke that has no meaning in the physical world
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to find correlation in Google Sheets. Want more? Check out all the Google Sheets Tutorials.