The CORREL formula in Excel is used to find out the correlation coefficient between two variables. It is used to find correlation between two variables and gives correlation coefficient having value between 1 and -1. Use the correlation coefficient to determine the relationship between two properties.
This Tutorial demonstrates how to use the Excel CORREL Function in Excel to calculate the correlation.
The simplest is to get two data sets side-by-side and use the built-in correlation formula. The CORREL function returns the correlation coefficient of two cell ranges. For example considering a variable X value increases with the value of a variable and the value of variable X decreases with the value of variable Y decreases as shown in the below table. For example you can examine the relationship between a locations average temperature and the use of air conditioners.