Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > COVAR
 

COVAR(array1, array2)

 
 Returns the average of the products of deviations for each data point pair.

 array1The first array of integers.
 array2The second array of integers.

 REMARKS
 
  		• The arguments must be either numbers, named ranges, arrays, or cell 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 "array1" and "array2" have different numbers of data points, then #N/A is returned.
     
  		• The average of the products of deviations for each data point pair is known as covariance. Use covariance to determine the relationship between two data sets.
     
  		• For example, you can examine whether greater income accompanies greater levels of education.

     EXAMPLES
     
     A
    1=COVAR({10,20,30},{40,50,60}) = 66.67
    2=COVAR({3,2,4,5,6},{9,7,12,15,17}) = 5.2
    3=COVAR({3,2,4,5,6},{9,"some text",12,15,17}) = 3.4
    4=COVAR({3,2,4,5,6},{1,2}) = #N/A
    5=COVAR({3,2,4,5,6},) = #VALUE!
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top