CORREL.COEF function

Category:Statistics

Name in English:CORREL

That makes?

Returns the correlation coefficient between two ranges of cells.

Syntax

CORREL.COEF (matrix1, matrix2)

  • array1 (required ): The first range of values.
  • array2 (required ): The second range of values.

Examples

CORREL COEF ({41,81,99}, {10,26,68}) = 0.892090067 CORREL
COEF (A1: A5, B1: B5) = Correlation coefficient of the values ​​in A1: A5 and B1: B5

Leave a Comment