PEARSON

Definition: PEARSON is a function that returns the Pearson product-moment correlation coefficient between two sets of data.

Syntax: =PEARSON(array1, array2)

Situation: This formula is appropriate when you need to find the Pearson product-moment correlation coefficient between two sets of data.

Example: If you have two sets of data in arrays A1:A10 and B1:B10, the correlation coefficient can be found using the formula =PEARSON(A1:A10, B1:B10).