Functions
COVARIANCE.P
Population covariance
Try it
When to use it
When should I use COVARIANCE.P?
Use COVARIANCE.P to compute population covariance when your data represents the entire population, not a sample — it divides by n rather than n-1.
Used in
Syntax
COVARIANCE.P(array1,array2)Examples
=COVARIANCE.P({2,5,7,1,8},{4,3,6,1,5}) // => 3.72