Skip to Content

COVAR

Returns covariance, the average of the products of paired deviations. Replaced by COVARIANCE.P.

Syntax

COVAR(array1, array2)

Parameters

  • array1: Required. The first cell range of integers
  • array2: Required. The second cell range of integers

Example

=COVAR(A1:A10, B1:B10)
Returns: NumberSince: Excel 2003