COVARIANCE.P function
Summary
Returns covariance, the average of the products of paired deviations
Syntax
COVARIANCE.P(array1,array2)
The COVARIANCE.P function syntax has the following arguments:
• Array1 Required. The first cell range of integers.
• Array2 Required. The second cell range of integers.
• Array1 Required. The first cell range of integers.
• Array2 Required. The second cell range of integers.
Example
=COVARIANCE.P(A2:A6, B2:B6)