COVAR Function in Excel – Calculate Covariance in Excel

COVAR Function in Excel calculates the covariance of two supplied sets of values.

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

Where,

  • x and y are the sample means of two sets of values
  • N is the number of values.

 

Syntax of COVAR Function in Excel:

COVAR(array1,array2)

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

 

Example of COVAR Function in Excel

COVAR Function in Excel 2

The Above example calculates the covariance of two arrays with formula

= COVAR (A2:A13,B2:B13)

Which results in value 38.22222222

NOTE:

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

previous COVAR Function in Excel                                                                                                                next COVAR Function in Excel