Returns the correlation coefficient between two data sets.
Syntaxis
CORREL(array1, array2)Argumenten
array1vereist
The first range of cell values.
array2vereist
The second range of cell values.
The CORREL function is used to determine the relationship between two properties. It returns the Pearson product-moment correlation coefficient, which measures the strength and direction of a linear relationship between two variables.
=CORREL(A1:A3, B1:B3)→1Calculates the correlation for two identical or perfectly linear datasets.
Select the cell
Click on the cell where you want to display the correlation result.
Enter the formula
Type =CORREL( and select your first range, then a comma, then your second range, and close the parenthesis.
A result of 1 indicates a perfect positive linear correlation.