PEARSON Function Explained
The PEARSON function in Microsoft Excel calculates the Pearson product-moment correlation coefficient, which is a measure of the linear correlation between two sets of values. It takes two sets of values as arguments and returns a number between -1 and 1, where -1 indicates a perfect negative correlation, 0 indicates no correlation, and 1 indicates a perfect positive correlation.
PEARSON Function Syntax
PEARSON(array1, array2)
- array1: The first array or range of data.
- array2: The second array or range of data.