Related Function:

The COVARIANCE.S function returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.

Syntax

=COVARIANCE.S(array1,array2)

Arguments

Argument Description
array1 The first array of numeric values
array2 The second array of numeric values

Examples

  A B C D E F
1 Array1 Array2   Formula Result Notes
2 3 16   =COVARIANCE.S(A2:A6,B2:B6) 2.65 Sample covariance for the data points
3 4 12        
4 10 17        
5 5 11        
6 7 12        

Common Function Error(s)

Problem What went wrong
#N/A Occurs if the two supplied arrays have different lengths
#DIV/0! Occurs if one or both of the supplied arrays are empty