COVAR function

Category: Compatibility
Introduced: Excel 2003

Summary

Returns covariance, the average of the products of paired deviations

Syntax

COVAR(array1,array2) The COVAR function syntax has the following arguments:
• Array1 Required. The first cell range of integers.
• Array2 Required. The second cell range of integers.

Example

=COVAR(A2:A6, B2:B6)

Microsoft Support Page

https://support.microsoft.com/en-us/office/covar-function-50479552-2c03-4daf-bd71-a5ab88b2db03

Back to Functions