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