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