PEARSON()
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.
Arguments
array1 (required). A set of independent values
array2 (required). A set of dependent values
Note
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
