Excel: calculate correlation - how it works
In Excel you can calculate the correlation between two variables and establish a connection. A simple formula will help you do this.
Calculate correlation coefficients
You can calculate the correlation in Excel using the formula "= CORREL (Area1; Area2)". Each area represents a variable.
- You can calculate the correlation coefficient between the values in A1 to A6 and the values in B1 to B6 with "= CORREL (A1: A6; B1: B6)".
- The result is between -1 (strongly negative connection) and +1 (strongly positive connection). A value around 0 means no connection.
- Note: You can also use this formula to calculate Pearsons R. You can also enter "= Pearson (Area1; Area2)" - however, the result remains the same.
The formula mentioned can be used in all versions of Excel. In another practical tip, we will show you how to round up to whole numbers in Excel.