How to Calculate Covariance in Excel 2007

1. Run Microsoft Excel 2007 and open the workbook that contains your data arrays.
2. Determine the cell addresses for your two arrays. For example, if your arrays are contained in the first 10 columns of rows A and B, then the cell addresses for those arrays are A1:A10 and B1:B10.
3. Click a blank cell that you would like to use to display the covariance between your data arrays.
4. Type the following in the cell:=COVAR(A1:A10,B1:B10)Substitute the cell addresses for your two data arrays in place of the sample addresses in the example.
5. Press 'Enter.' The cell displays the covariance between the two data arrays.