COVARIANCE.S function
Summary
Returns the sample covariance, the average of the products deviations for each data point pair in two data sets
Syntax
COVARIANCE.S(array1,array2)
The COVARIANCE.S function syntax has the following arguments:
• Array1 Required. The first cell range of integers.
• Array2 Required. The second cell range of integers.
• Array1 Required. The first cell range of integers.
• Array2 Required. The second cell range of integers.
Example
=COVARIANCE.S({2,4,8},{5,11,12})
=COVARIANCE.S(A3:A5,B3:B5)
=COVARIANCE.S(A3:A5,B3:B5)