What is COVARIANCE.S function in Excel? COVARIANCE.S function is one of Statistical functions in Microsoft Excel that returns the sample covariance, the average of the products of deviations for each data point pair in two data sets. Syntax of COVARIANCE.S function COVARIANCE.S(array1,array2) The COVARIANCE.S function syntax has the following arguments: Array1 Required. The first cell range of integers. Array2 Required. The…