COVAR(array1,array2) returns covariance, the average of the products of paired deviations : COVAR « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. COVAR
Input the formula: =COVAR(B2:B6, C2:C6). Press Enter to get the result.
Input the formula: =COVAR(B2:B6, C2:C6)

Referenced from Excel Help

21.16.COVAR
21.16.1.COVAR(array1,array2) returns covariance, the average of the products of paired deviationsCOVAR(array1,array2) returns covariance, the average of the products of paired deviations