Skip to Content

CORREL

Returns the correlation coefficient between two data sets

Syntax

CORREL(array1, array2)

Parameters

  • array1: Required. A range of values
  • array2: Required. A second range of values

Example

=CORREL(A1:A10, B1:B10)
Returns: NumberSince: Excel 2003