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.




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


  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