The COVARIANCE.P function returns population covariance, the average of the products of deviations for each data point pair in two data sets.
- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The COVARIANCE.P function replaces the COVAR function included in earlier versions of Excel.
|array1||The first array of numeric values|
|array2||The second array of numeric values|
|2||3||16||=COVARIANCE.P(A2:A6,B2:B6)||2.12||Covariance, the average of the products of deviations for each data point pair|
Common Function Error(s)
|Problem||What went wrong|
|#N/A||Occurs if the two supplied arrays have different lengths|
|#DIV/0!||Occurs if one or both of the supplied arrays are empty|
The covariance is a statistical measurement of the strength of the correlation between two sets of variables. Covariance is calculated by the following equation:
where and are the sample means (averages) of the two sets of values and n is the sample size.
See Wikipedia for more information on covariance.