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

CORREL(array1, array2)

 
 Returns the correlation coefficient between two dates.

 array1The first array.
 array2The second optional array.

 REMARKS
 
  		• The "array1" and "array2" must be numbers, or names, arrays, or 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 a different number of data points, then #N/A is returned.
     
  		• If either "array1" or "array2" is empty, or if the standard deviation of their values equals zero, then #DIV/0! is returned.

     EXAMPLES
     
     A
    1=CORREL({1,2,3,4,5},{1,3,5,7,0}) = 0.110
    2=CORREL({3,2,4,5,6},{9,7,12,15,17}) = 0.997
    3=CORREL({1,2},{1,2,3,4}) = #N/A
    		 
     Functions - C | Index - C | Office Online 

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