Description Computes the covariance for pairwise numbers in two arrays.
Syntax COVAR (arrayX, arrayY)
| Argument | Description |
|---|---|
| arrayX and arrayY | Two range references or array constants containing numeric values. ArrayX and arrayY must contain the same potential number of values. Text, logical values, and blank cells are ignored, along with the number they are paired up with. That is, when a number from arrayX is paired up with text from arrayY, the entire pair is ignored. |
Remarks This function pairs up the numbers in the two ranges by moving left-to-right through each sequential row.
Equation
Please note that different statistics methods divide by n or by n - 1. We chose to divide by n in order to be consistent with Microsoft Excel.
Examples This function returns 4:
See Also CORREL
