Returns the correlation coefficient between two data sets.
تعمل هذه الدالة في Google Sheets كما تعمل في 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.