by The PEARSON function returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
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: Let’s look at some Excel PEARSON function examples and explore how to use the PEARSON function as a worksheet function in Microsoft Excel:
Consider an example of calculating the Pearson correlation between two data arrays using the PEARSON function in MS EXCEL. The first array represents the temperature values, the second pressure in a certain summer period. An example of a filled table is shown in the figure:
Syntax: =PEARSON(C2:C21,B2:B21)
Result: -0.148330774
This indicator -0.148 by Pearson, who returned the function, indicates an unfavorable dependence of temperature and pressure at an early time of day.
Note:
- #N/A! error – Occurs if the given array arguments are of different lengths.
- #DIV/0! error – Occurs when either of the given array arguments is empty or when the standard deviation of their values is equal to zero.
- The PEARSON function performs the same calculation as the CORREL function. However, in MS Excel 2003 and earlier versions, PEARSON may exhibit some rounding errors.
- If an array or reference argument contains text, logical values, or empty cells, the values are ignored. However, cells with the value zero are included by this function.
- The formula for the Pearson product moment correlation coefficient, r, is:
where x and y are the sample means AVERAGE(array1) and AVERAGE(array2).
