WorksheetFunction.Covar Method
Returns covariance, the average of the products of deviations for each data point pair.
Syntax
expression.Covar(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Variant | The first cell range of integers. |
| Arg2 | Required | Variant | The second cell range of integers. |
Return Value
Double
Remarks
Use covariance to determine the relationship between two data sets. For example, you can examine whether greater income accompanies greater levels of education.
- The arguments must either be numbers or be names, arrays, or references that contain numbers.
- If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
- If and have different numbers of data points, COVAR generates an error.If either or is empty, Covar generates an error.The covariance is:
where x and y are the sample means AVERAGE(array1) and AVERAGE(array2), and n is the sample size.
See also:
Arg1 Arg2 Arg1 Arg2