How to use PEARSON Function in Excel

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

PEARSON Function in Excel 1 - How to use PEARSON Function in Excel

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:

  1. #N/A! error – Occurs if the given array arguments are of different lengths.
  2. #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.
  3. 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.
  4. 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.
  5. The formula for the Pearson product moment correlation coefficient, r, is:
    PEARSON Function in Excel - How to use PEARSON Function in Excel
    where x and y are the sample means AVERAGE(array1) and AVERAGE(array2).
READ:  How to use STDEVPA Function in Excel

 

Add a Comment

Your email address will not be published. Required fields are marked *