Buzz
This article introduces you to the PEARSON function - one of the functions in the statistical group widely used in Excel.
Description: The function returns the Pearson correlation coefficient, r, with a scalar index in the range from -1 to 1. It reflects the linear relationship extension between two datasets.
Syntax: PEARSON(array1, array2)
Regarding:
- array1: The set of independent values, which is a required parameter.
- array2: The set of dependent values, which is a required parameter.
Note:
- The arguments must be numbers, names, or arrays containing numbers.
- If the argument is a reference or an array containing logical or text values -> these values are ignored, however, the value 0 is still considered.
- If array1, array2 contain different data points -> the function returns the error value #N/A.
- The formula for the Pearson correlation coefficient, r, is:
The formula for calculating the Pearson correlation coefficient, r, is:
Where:
x and y are the samples of AVERAGE(array1) and AVERAGE(array2)
Example:
Find the Pearson correlation coefficient r of 2 datasets in the data table below:
- Enter the formula in the cell where you want to calculate: =PEARSON(C6:C10,D6:D10)
- Press Enter -> the Pearson correlation coefficient r of 2 datasets is:
- In case the number of data points in 2 datasets is different, for example, the independent dataset has 5 elements but the dependent dataset only has 3 elements -> the function returns an error value #N/A.
Here is a guide and some specific examples of using the PEARSON function in Excel.
Wishing you all success!
