Documentation/Calc Functions/PEARSON

Function name:
PEARSON

Category:
Statistical Analysis

Summary:
Calculates the sample Pearson correlation coefficient (r) of two data sets.

Syntax:
PEARSON(Data1; Data2)

Returns:
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].

Arguments:
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.

Additional details:
r  =
 * 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.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/CORREL CORREL]

[[Special:MyLanguage/Documentation/Calc_Functions/RSQ RSQ]

ODF standard:
Section 6.18.56, part 2

Equivalent Excel functions:
PEARSON