Skip to Content

COVARIANCE.S

Returns sample covariance, the average of the products of deviations for each data point pair in two data sets

Syntax

COVARIANCE.S(array1, array2)

Parameters

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

Example

=COVARIANCE.S(A1:A10, B1:B10)
Returns: NumberSince: Excel 2010