Returns the Pearson product-moment correlation coefficient of 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ố.
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})Kết quả: 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.