Documentation/Calc Functions/COVARIANCE.P
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.
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:
ODF standard:
None
Equivalent Excel functions:
COVARIANCE.P