Returns the correlation coefficient between two data sets.
Cú pháp
CORREL(array1, array2)Đối số
array1bắt buộc
The first range of cell values.
array2bắt buộc
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.