Excel

COVARIANCE.P: Excel Formulae Explained

How do you use COVARIANCE.P in Excel?

COVARIANCE.P calculates the population covariance of two arrays of numbers. The formula for population covariance is:

The population covariance is a measure of the degree to which two arrays of numbers are linearly related. The population covariance is always positive, and is calculated by summing the products of the deviations of each number in one array from the mean of that array, and dividing by the number of items in the arrays.

The Excel function for population covariance is COVARIANCE.P. The function takes two arrays of numbers as input, and calculates the population covariance of those arrays.

What is the syntax of COVARIANCE.P in Excel?

The syntax of COVARIANCE.P in Excel is as follows:

=COVARIANCE.P(array1,array2)

This function calculates the population covariance between two arrays of numbers.

What is an example of how to use COVARIANCE.P in Excel?

The COVARIANCE.P function in Excel is used to calculate the population covariance of two sets of data. The function takes two arrays of data as inputs, and calculates the covariance between the arrays. The function can be used to calculate the covariance between two sets of data, or between two arrays of data within the same sheet. The function is used in Excel to calculate the correlation between two sets of data, which is used to measure the strength of the relationship between the two sets of data.

When should you not use COVARIANCE.P in Excel?

COVARIANCE.P should not be used when the population standard deviations (sigma) are not known. The function will return an error if the standard deviations are not supplied.

What are some similar formulae to COVARIANCE.P in Excel?

The Excel function COVARIANCE.P calculates the population covariance of two arrays of numbers. The function has the following syntax:

=COVARIANCE.P(array1,array2)

The function returns the population covariance of the two arrays, which is the average of the products of the deviations of the corresponding elements of the arrays from their means, divided by the product of the standard deviations of the arrays.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.