Documentation/Calc Functions/COVARIANCE.P

Function name:
COVARIANCE.P

Category:
Statistical Analysis

Summary:
Returns the covariance of the product of paired deviations, for the entire population.

Syntax:
COVARIANCE.P(Data1; Data2)

Returns:
Returns a real number which is population 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 which 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 number 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 COVARIANCE.P 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/COVAR COVAR]

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

ODF standard:
None

Equivalent Excel functions:
COVARIANCE.P