Returns covariance, the average of the products of deviations for each data point pair. Use covariance to determine the relationship between two data sets. For example, you can examine whether greater income accompanies greater levels of education.
Syntax
COVAR(array1,array2)
Array1 is the first cell range of integers.
Array2 is the second cell range of integers.
Remarks
where x and y are the sample means AVERAGE(array1) and AVERAGE(array2), and n is the sample size.
Example
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|