COVAR
Returns covariance, the average of the products of paired deviations.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Calculates population covariance (Legacy).
Syntax
COVAR(array1, array2)
Arguments
array1(range) — First data set.array2(range) — Second data set.
Examples
Legacy Covariance
Calculate covariance.
FORMULA
=COVAR(A2:A4, B2:B4)
RESULT
50
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 10 |
| 3 | 2 | 20 |
| 4 | 3 | 40 |