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 ...