COVARIANCE.P

COVARIANCE.P(array1, array2)

Returns the covariance based on an entire population.

array1The first array of integers.
array2The second array of integers.

REMARKS
* This function was added in Excel 2010 to replace the COVAR function.
* The covariance is the average of the products of deviations for each data point pair.
* You can use the COVARIANCE.S function to return the covariance based on a sample.
* You can use the VAR.P function to return the variance based on an entire population.
* You can use the VARPA function to return the variance based on an entire population (including logical values and text).
* For the Microsoft documentation refer to support.microsoft.com

 A
1=COVARIANCE.P({10, 20, 30}, {40, 50, 60}) = 66.67
2=COVARIANCE.P({3, 2, 4, 5, 6}, {9, 7, 12, 15, 17}) = 5.2
3=COVARIANCE.P({3, 2, 4, 5, 6}, {9, "some text", 12, 15, 17}) = 3.4
4=COVARIANCE.P({3, 2, 4, 5, 6}, {1, 2}) = #N/A
5=COVARIANCE.P({3, 2, 4, 5, 6}, ) = #VALUE!


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top