COVARIANCEP
Description
Returns the population covariance: the average of the products of deviations for each data point pair in two data sets.
Syntax
COVARIANCEP(
array1
,
array2
)
- array1: The first cell range of integers.
- array2: The second cell range of integers.
Example
Formula | Result |
|---|---|
=COVARIANCEP({3;2;4;5;6}, {9;7;12;15;17}) | 5.2 |
Notes
- This function does the same action as COVARIANCE.P().