The Microsoft Excel COVAR function returns the covariance, the average of the products of deviations for two data sets. The COVAR function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.

How do you use the covariance function in Excel?

The covariance of the values in columns B and C of the spreadsheet can be calculated using the COVAR function using the formula =COVAR(B2:B13, C2:C13). It gives the result -0.000563, which indicates a negative correlation between the two sets of stocks.

Is there a sample covariance function in Excel?

This article describes the formula syntax and usage of the COVARIANCE. S function in Microsoft Excel. Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.