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.