COVARIANCE.P Function in Excel calculates the population covariance of two supplied sets of values.
Covariance is the measure of correlation between two sets of variables. Population Covariance is calculated using formula
Where,
- x and y are the sample means of two sets of values
- N is the number of values.
Syntax of COVARIANCE.P Function in Excel:
Where the array arguments are numeric values for which you want to calculate the population covariance.
Example of COVARIANCE.P Function in Excel
The Above example calculates the population covariance of two arrays with formula
= COVARIANCE.P (A2:A13,B2:B13)
Which results in value 38.22222
NOTE:
#N/A Error occurs if the two supplied arrays have different lengths.