# COVAR

## Content

This function returns the covariance, which is the average of the products of deviations for each data point pair in two sets of numbers.

## Syntax

`COVAR(array1, array2)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *Array1* | [Required] The first cell range of integers |
| *Array2* | [Required] The second cell range of integers |

## Remarks

Use this covariance function to determine the relationship between two sets of data. For example, you can examine whether greater income accompanies greater levels of education in a population.
The covariance is calculated as follows, where *n* is the size of the arrays and mu is the mean.
![](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/Func-COVAR.png)

## Examples

`COVAR(J2:J5,L2:L5)`
`COVAR(R2C12:R15C12,R2C14:R15C14)`
`COVAR({7,5,6},{7,4,4})` gives the result 1
`COVAR({5,10,15,20,25},{4,8,16,32,64})` gives the result 144