Returns the Pearson product-moment correlation coefficient of two data sets.
Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.
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})Wynik: 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.