The COVARIANCE.P function calculates the covariance meaning the average of the products of deviations for each pair in two different datasets. The covariance is positive if greater values in the first data set correspond to greater values in the second data set. The covariance is negative if greater values in the first data set correspond to smaller values in the second data set.
Formula in cell C18:
Excel Function Syntax
Required. The first data set.
Required. The second data set.
Text, logical or empty values are ignored, however, 0 (zeros) are included.
The COVARIANCE.P function returns
#N/A error value if the number of data points in array1 and array2 is not equal.
#DIV/0! error value if either array1 or array2 is empty.
The equation for COVARIANCE.P is:
x ̅ is the sample means AVERAGE(array1) and y ̅ is the sample means AVERAGE(array2).
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Statistical'
The COVARIANCE.P function function is one of many functions in the 'Statistical' category.