COVARIANCE.P Function Explained
The COVARIANCE.P Function in Microsoft Excel calculates the population covariance of two supplied sets of values. It takes two arguments, array1 and array2, which are the two sets of values to be compared. The population covariance is a measure of how much two variables vary together, and is calculated by taking the sum of the products of the deviations of each value from its respective mean, divided by the number of values in the set.
COVARIANCE.P Function Syntax
COVARIANCE.P(array1, array2)
- array1: The first range or array of numeric values.
- array2: The second range or array of numeric values.