Returns the correlation coefficient between two data sets.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
CORREL(array1, array2)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)Kết quả: 1
Calculates the correlation for two identical or perfectly linear datasets.
A result of 1 indicates a perfect positive linear correlation.