COVAR Function

Basic Description

The Excel COVAR function calculates the covariance of two supplied sets of values.

Syntax: COVAR( array1, array2 )

Where array1 and array2 are two arrays of numeric values. Note that the Covar function ignores text values and logical values that are supplied as part of an array.

A B
1 array1 array2
2 2 22.90
3 7 33.49
4 8 34.50
5 3 27.61
6 4 19.5
7 1 10.11
8 6 37.90
9 5 31.08

Covar Function Example

Columns A and B of the spreadsheet on the right contain two sets of values. The Covariance of the values in columns A and B of the spreadsheet can be calculated using the Excel Covar function, as follows:

=COVAR( A2:A9, B2:B9 )

This gives the result 16.633125, which indicates a positive correlation between the two sets of values.

 

Covar Function Common Errors

If you get an error from the Excel Covar Function, this is likely to be one of the following:

#N/A Occurs if the two supplied data arrays have different lengths
#VALUE! Occurs if one or both of the supplied data arrays are empty

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment