Documentation/Calc Functions/COVARIANCE.P

From The Document Foundation Wiki
Jump to navigation Jump to search


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:
Covare.png

where x̄ and ӯ are mean values.

  • COVAR and COVARIANCE.P perform the same function.
  • For more details on covariance, 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
=COVARIANCE.P(A1:A6;B1:B6) The function calculates covariance (the average of the products of deviations) for each data point pair in two data sets, Data1 and Data2. 165.166666666667

Related LibreOffice functions:

COVAR

COVARIANCE.S

ODF standard:

None

Equivalent Excel functions:

COVARIANCE.P