COVARIANCE.P

Formulas / COVARIANCE.P
Calculate the relationship between two data sets by determining the covariance of the deviations for the data points.
=COVARIANCE.P(array1,array2)
  • array1 - required, first cell range of integers
  • array2 - required, second cell range of integers

Examples

    =COVARIANCE.P(A2:A6, B2:B6) returns 5.2. This is because the covariance is the average of the products of deviations for each data point pair in the table.

    =COVARIANCE.P(A2:A6, B2:B6) returns the #DIV/0! error value if either array1 or array2 is empty. This means that the calculation cannot be completed because of missing data.

    =COVARIANCE.P(A2:A6, B2:B6) returns the #N/A error value if either array1 or array2 has a different number of data points. This means that the calculation cannot be completed because the data points are not the same length.


Summary

The Covariance.P function is a statistical tool used to measure the joint variability of two random variables. Introduced in MS Excel 2010, it has better accuracy than its predecessor, COVAR.

  • The COVARIANCE.P function was introduced in MS Excel 2010 and replaced COVAR, an older version of the same function.
  • COVARIANCE.P is an updated version of COVAR, which calculates the covariance of two sets of values.

Frequently Asked Questions

What is the COVARIANCE.P function?
The COVARIANCE.P function is a statistical function that calculates the joint variability of two random variables. It is used to measure how two sets of data are related and can be used to predict future outcomes. The COVARIANCE.P function was introduced in MS Excel 2010 to replace the COVAR function and is more accurate than COVAR.
How do I use the COVARIANCE.P function?
To use the COVARIANCE.P function, you will need two sets of data that you want to measure the covariance between. Once you have the two sets of data, open the MS Excel 2010 program and enter the COVARIANCE.P function into the formula bar. Input the two sets of data into the function and press enter. The result will be the covariance of the two sets of data.
What are some uses of the COVARIANCE.P function?
  • The COVARIANCE.P function can be used to measure the relationship between two sets of data.
  • It can be used to predict future outcomes.
  • The COVARIANCE.P function can be used to measure the volatility of a stock.
  • It can be used to measure the risk associated with an investment.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV