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

Sample Usage



The COVARIANCE.S function syntax has the following arguments:

  • Array1     Required. The first cell range of integers.

  • Array2     Required. The second cell range of integers.


  • The arguments must either be numbers or be names, arrays, or references that contain numbers.

  • If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

  • If array1 and array2 have different numbers of data points, COVARIANCE.S returns the #N/A error value.

  • If either array1 or array2 is empty or contains only 1 data point each, COVARIANCE.S returns the #DIV/0! error value.

In order to use the COVARIANCE.S formula, start with your edited Excellentable:

Then type in the COVARIANCE.S formula in the area you would like to display the outcome:

By adding the values you would like to calculate the COVARIANCE.S formula for, Excellentable will generate the outcome:


User does not have sufficient privileges to access this Content
Learn More