Documentation/Calc Functions/CORREL

Function name:
CORREL

Category:
Statistical Analysis

Summary:
Returns the correlation coefficient between two data sets.

Syntax:
CORREL(Data1; Data2)

Returns:
Returns a real value which is the 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, logical values, or empty cells, then the function ignores these values.
 * If Data1 and Data2 have different number of data points then the function returns an error value.
 * If any of the arguments is empty, or if the standard deviation of their values equals zero, CORREL returns a division(#DIV/0!) error.

Additional details:
Correl(X,Y) =
 * The formula for CORREL is:

where x̄ and ӯ are mean values.
 * CORREL and PEARSON functions perform the same operation.

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

ODF standard:
Section 6.18.17, part 2

Equivalent Excel functions:
CORREL