# COVAR

COVAR(array1, array2)

Returns the covariance based on an entire population.

 array1 The first array of integers. array2 The second array of integers.

 REMARKS
 * COVARIANCE.P was added in Excel 2010 to replace this function.* The covariance is the average of the products of deviations for each data point pair.* The arguments must be either numbers, named ranges, arrays, or cell references that contain numbers.* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.* If "array1" and "array2" have different numbers of data points, then #N/A is returned.* The average of the products of deviations for each data point pair is known as covariance. Use covariance to determine the relationship between two data sets.* For example, you can examine whether greater income accompanies greater levels of education.* You can use the COVARIANCE.S function to return the covariance based on a sample.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A 1 =COVAR({10, 20, 30}, {40, 50, 60}) = 66.67 2 =COVAR({3, 2, 4, 5, 6}, {9, 7, 12, 15, 17}) = 5.2 3 =COVAR({3, 2, 4, 5, 6}, {9, "some text", 12, 15, 17}) = 3.4 4 =COVAR({3, 2, 4, 5, 6}, {1, 2}) = #N/A 5 =COVAR({3, 2, 4, 5, 6}, ) = #VALUE!