PEARSON function

Category: Statistical
Introduced: Excel 2003

Summary

Returns the Pearson product moment correlation coefficient

Syntax

PEARSON(array1, array2) The PEARSON function syntax has the following arguments:
• Array1 Required. A set of independent values.
• Array2 Required. A set of dependent values.

Example

=PEARSON(A3:A7,B3:B7)

Microsoft Support Page

https://support.microsoft.com/en-us/office/pearson-function-0c3e30fc-e5af-49c4-808a-3ef66e034c18

Back to Functions