COVARIANCE.S Function Explained
The COVARIANCE.S Function in Microsoft Excel calculates the sample covariance of two supplied sets of values. It takes two arguments, array1 and array2, which are the two sets of values to be compared. The function returns the sample covariance, which is a measure of how much two sets of values vary together.
COVARIANCE.S Function Syntax
COVARIANCE.S(array1, array2)
- array1: The first range or array of values.
- array2: The second range or array of values.