In this tutorial, you will learn how to find correlation coefficient in google sheets.
The Correlation Coefficient is a statistical tool used to assess the strength of the correlation between two datasets. You can use the correlation coefficient to shed light on whether the relationship between the datasets is strong enough to be predictive, however be aware that a strong correlation coefficient doesn’t necessarily imply causation.
When reading a correlation coefficient, keep in mind they range from -1 to 1, with greater absolute value implying stronger correlation and numbers close to zero implying weak or no correlation. Positive numbers indicate a positive correlation, meaning that a higher measurement in one data set will lead to a higher measurement in the other, while negative numbers indicate the opposite.
The math for calculating the correlation coefficient is a little complex, but fortunately Google Sheets makes it easy to calculate with a single function so you don’t need to do the calculations yourself. Read on to Learn how.
Finding the Correlation Coefficient
Here’s how to find the correlation between two data sets in Google Sheets:
Ensure your data is entered in two column, one for each dataset
The function that finds the correlation coefficient is CORRELL(). It requires two ranges as inputs: One for each of the two datasets to find the correlation between. So if the two datasets are in the ranges A2:A21 and B2:B21 respectively, the formula will be: “=CORREL(A2:A21, B2:B21)”. Type this formula into a cell and hit enter.
The correlation coefficient will be calculated in the cell
If you want to display fewer decimal places, use the Decrease Decimal Place button in the toolbar to reduce the displayed decimal places as needed
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to find correlation coefficient in google sheets. Want more? Check out all the Google Sheets Tutorials.