Name
COVAR
Synopsis
Use COVAR to compare the values in two arrays and determine the covariance, the average of the products of the deviations between all possible pairs of elements of the arrays.
To Calculate
=COVAR(Array1,Array2)
Both arguments must be specified for this function.
Example
Figure 15-9 illustrates how COVAR provides the ability to quickly compare two arrays of values and determine the covariance value.
Figure 15-9. Use COVAR to compare two arrays and find the covariance of the arrays
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
