Calculates the sample Pearson correlation coefficient (r) of two data sets.
Returns a real value which is the sample Pearson correlation coefficient of values in Data1 and Data2. It returns a value in range [-1,1].
Data1 is a reference to a range of cells which is considered the first data set.
Data2 is a reference to a range of cells which is considered the second data set.
- If a cell contains text, or empty cells, then the function ignores these values. However for logical values, TRUE is considerd as 1 and FALSE as 0.
- If Data1 and Data2 have different numbers of data points then the function returns an error value.
- The formula for PEARSON is:
where x̄ and ӯ are mean values.
- CORREL and PEARSON functions perform the same operation.
- For more details on the sample Pearson correlation coefficient, visit Wikipedia.
|=PEARSON(A1:A6;B1:B6)||The function calculates the Pearson correlation coefficient of the two data sets, Data1 and Data2.||
Related LibreOffice functions:
Equivalent Excel functions: