Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

COVAR(array1,array2) returns covariance, the average of the products of paired deviations

Input the formula: =COVAR(B2:B6, C2:C6). Press Enter to get the result. Referenced from Excel Help