Returns the correlation coefficient between two data sets.
Эта функция в Google Таблицах работает так же, как в 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.