Excel Function : COVAR
Category
Compatibility
Description
Returns covariance, the average of the products of paired deviations
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COVAR-function-50479552-2c03-4daf-bd71-a5ab88b2db03
Syntax and Description of the COVAR Excel Function
COVAR(array1,array2)
About COVAR Excel Function
COVAR(array1,array2) The COVAR function returns the covariance, the average of the products of deviations for each data point pair in two data sets. The covariance is a measure of how two data sets change together.