Syntax. PEARSON(array1,array2)

Definition. This function returns the Pearson correlation coefficient r. This coefficient is a dimensionless index that ranges from –1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.


  • array1 (required). A set of independent values

  • array2 (required). A set of dependent values


Arguments can be numbers, names, arrays, or references containing numbers.

If an array or a reference argument contains text, logical values, or empty cells, those values are ignored. However, cells with the value 0 are included.

If array1 and array2 are empty or have a different number of data points, the PEARSON() function returns the #N/A error value.

Background. The correlation coefficient ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.