Returns the Pearson product-moment correlation coefficient of two data sets.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
PEARSON(array1, array2)The PEARSON function measures the linear relationship between two variables. It returns a value between -1 and 1, where 1 indicates a perfect positive correlation, -1 indicates a perfect negative correlation, and 0 indicates no linear correlation.
=PEARSON({1,2,3}, {4,5,6})결과: 1
The two sets have a perfect positive linear relationship.
In Excel, the PEARSON and CORREL functions are mathematically identical and return the same result.