COVARIANCE.S
Description
Returns the sample covariance: the average of the products of deviations for each data point pair in two data sets.
Syntax
COVARIANCE.S(
array1
,
array2
)
- array1: The first cell range of integers.
- array2: The second cell range of integers.
Example
Formula | Result |
|---|---|
COVARIANCE.S({2,4,8}, {5,11,12}) | 9.666666667 |
Notes
- This function does the same action as COVARIANCES().