COVAR()
Note
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.
Arguments
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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
