Skip to Content

PEARSON

Returns the Pearson product moment correlation coefficient

Syntax

PEARSON(array1, array2)

Parameters

  • array1: Required. A set of independent values
  • array2: Required. A set of dependent values

Example

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