Returns the population covariance, the average of the products of deviations for each data point pair in two data sets.
Syntax
COVARIANCE.P(array1, array2)Arguments
array1required
The first range of integer cells.
array2required
The second range of integer cells.
COVARIANCE.P measures the directional relationship between two data sets. It calculates the covariance for the entire population, meaning it uses the total number of data points (n) as the divisor rather than (n-1).
=COVARIANCE.P({1,2,3}, {4,5,6})→0.666666667Calculates the population covariance for two sets of three numbers.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =COVARIANCE.P( and select your two data ranges, then press Enter.
COVARIANCE.P is used for the entire population (dividing by n), while COVARIANCE.S is used for a sample (dividing by n-1).