# Documentation/Calc Functions/COVAR

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.

## Examples:

Data1 | Data2 | |
---|---|---|

1 | 195 | 200 |

2 | 151 | 180 |

3 | 148 | 178 |

4 | 189 | 165 |

5 | 183 | 192 |

6 | 154 | 144 |

Formula | Description | Returns |
---|---|---|

=COVAR(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:

## Equivalent Excel functions:

COVAR