Returns the correlation coefficient between two data sets.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 1
Calculates the correlation for two identical or perfectly linear datasets.
A result of 1 indicates a perfect positive linear correlation.