Documentation/Calc Functions/COVAR

Function name:
COVAR

Category:
Statistical Analysis

Summary:
Returns the covariance of the product of paired deviations.

Syntax:
COVAR(Data1; Data2)

Returns:
Returns a real number which is the covariance (the average of the products of deviations) for each data point pair in two data sets, Data1 and Data2.

Arguments:
Data1 is a reference to a range of cells that is considered the first data set.

Data2 is a reference to a range of cells that is considered the second data set.


 * If a cell contains text, or empty cells, then the function ignores these values.
 * If Data1 and Data2 have different numbers of data points then the function returns an error value.
 * If the standard deviation of Data1 and Data2 is 0 then the function returns an error value.
 * If any of the arguments is empty, or if the standard deviation of their values equals zero, COVAR returns an error value.

Additional details:

 * The formula for COVAR is:

where x̄ and ӯ are mean values.
 * COVAR and COVARIANCE.P perform the same function.
 * For more details on covariance, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/COVARIANCE.P COVARIANCE.P]

[[Special:MyLanguage/Documentation/Calc_Functions/COVARIANCE.S COVARIANCE.S]

ODF standard:
Section 6.18.18, part 2

Equivalent Excel functions:
COVAR