The COVARIANCE.P function calculates the population covariance between two sets of values. It is commonly used in statistics and data analysis to measure the relationship or degree of interdependence between two variables.


=COVARIANCE.P(array1, array2)

array1 The first set of values or data points.
array2 The second set of values or data points.


When seeking to understand the degree of interdependence or correlation between two sets of data, the COVARIANCE.P function is a reliable asset in Excel's statistical toolkit. With its ability to assess the relationship between data points, it provides valuable insights into how changes in one variable relate to changes in another, essential for making informed decisions in data analysis and research contexts. Utilizing population covariance, this function considers the entire dataset as a representative of the population, providing a comprehensive measure of the linear relationship between the two variables. In essence, it quantifies the extent to which the variables move in relation to each other, facilitating a deeper understanding of their connection and behavior.


Suppose you have the following two datasets representing the performances of two stocks over a period of time. To calculate the population covariance between the two sets of stock returns, you can use the COVARIANCE.P function as follows: =COVARIANCE.P(B2:B11, C2:C11)

Consider a scenario where you have data on monthly advertising expenditure and monthly sales figures for a product. By applying COVARIANCE.P to the two datasets, you can quantitatively assess the degree to which advertising spending impacts product sales over time.


How does the COVARIANCE.P function differ from COVARIANCE.S?

The COVARIANCE.P function calculates the population covariance, considering the entire dataset as a representation of the entire population. On the other hand, COVARIANCE.S calculates the sample covariance, assuming that the provided dataset is a sample of the population rather than the entire population.

What does a positive population covariance value indicate?

A positive population covariance value suggests that the two variables tend to move in the same direction. An increase in one variable is associated with an increase in the other variable, while a decrease in one variable is associated with a decrease in the other variable.

How can the output of COVARIANCE.P be interpreted?

The output of COVARIANCE.P represents the measure of the linear relationship between the two variables, indicating the extent to which changes in one variable are associated with changes in the other variable. A higher covariance value suggests a stronger linear relationship between the variables, while a lower value indicates a weaker relationship.

Related functions