COVARIANCE.S Function in Excel

COVARIANCE.S Function in Excel calculates the sample covariance of two supplied sets of values.

Covariance is the measure of correlation between two sets of variables. Sample Covariance is calculated using formulaCOVARIANCE.S Function in Excel 1

Where,

  • X̄ and ȳ are the sample means of two sets of values
  • n is the number of values.

 

Syntax of COVARIANCE.S Function in Excel:

COVARIANCE.S(array1,array2)

Where the array arguments are numeric values for which you want to calculate the sample covariance.

 

Example of COVARIANCE.S Function in Excel

COVARIANCE.S Function in Excel 2

The Above example calculates the sample covariance of two arrays with formula

= COVARIANCE.S (A2:A13,B2:B13)

Which results in value 41.69697

NOTE:

#N/A Error occurs if the two supplied arrays have different lengths.

previous COVARIANCE.S Function in Excel                                                                                                                next COVARIANCE.S Function in Excel