Documentation/Calc Functions/PEARSON

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

  • The formula for PEARSON is:

r =

Correl new.png

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.

Examples:

Data1 Data2
1 195 200
2 151 180
3 148 178
4 189 165
5 183 192
6 154 144
Formula Description Returns
=PEARSON(A1:A6;B1:B6) The function calculates the Pearson correlation coefficient of the two data sets, Data1 and Data2.

0.46706598573232

Related LibreOffice functions:

CORREL

RSQ

ODF standard:

Section 6.18.56, part 2

Equivalent Excel functions:

PEARSON