Excel Function : COVARIANCE.P

Download now!

Excel Function : COVARIANCE.P

Category

Statistical

Description

Returns covariance, the average of the products of paired deviations

Microsoft Excel Reference Page

https://support.office.com/en-us/article/COVARIANCEP-function-6f0e1e6d-956d-4e4b-9943-cfef0bf9edfc

Syntax and Description of the COVARIANCE.P Excel Function

COVARIANCE.P is an Excel function that calculates the covariance of two data sets. The function takes two arguments, the first is the data set to be used for the calculation and the second is the data set to be used for the comparison. The function returns the covariance of the two data sets.

About COVARIANCE.P Excel Function

The COVARIANCE.P function returns the covariance, the average of the products of deviations for two data sets. The COVARIANCE.P function syntax has the following arguments: Data_1, Data_2.