In Excel 2010, the COVAR() function was replaced with the COVARIANCE.P() and COVARIANCE.S() functions to increase the accuracy of the results. To ensure the backward compatibility of COVARIANCE.P() and COVARIANCE.S(), the COVAR() function is still available.

Syntax. COVAR(array1,array2)

Definition. This function returns the covariance of two value pairs. Use the covariance to determine the relationship between two data sets. For example, you can examine whether the increase in online orders is related to the number of website visits. To calculate the covariance, the deviations of all value pairs between the actual value and the mean is multiplied and the mean is formed.


  • array1 (required). The first cell range of integers

  • array2 ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.