MS Excel: Covar Function
In Excel, the Covar function returns the covariance, the average of the products of deviations for two data sets.
The syntax for the Covar function is:
Covar( array1, array2 )
array1 and array are two ranges or arrays of integer values.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
=Covar({1,2;3,4}, {5,6;7,8})
The above example would return 1.25.
You could also reference ranges in Excel.
Based on the Excel spreadsheet above, you could enter the following formula:
=Covar(A1:B2, D1:E2)
This would also return the value 1.25.