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

PEARSON(array1, array2)

 
 Returns the Pearson product moment correlation coefficient.

 array1The first array of independent values.
 array2The second array of dependent values.

 REMARKS
 
  		• The arguments must be either numbers or names, array constants, 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" are empty, then #N/A is returned.
     
  		• If "array1" and "array2" have a different number of data points, then #N/A is returned.
     
  		• Returns the Pearson product moment correlation coefficient, r, a dimensionless index that ranges from -1.0 to 1.0 inclusive and reflects the extent of a linear relationship between two data sets.
     
  		• The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828129).

     EXAMPLES
     
     A
    1=PEARSON({1,2,3,4},{5,6,7,8}) = 1
    2=PEARSON({1,2,3,4},{10,20,30,40}) = 1
    3=PEARSON({10,20,30,40},{5,6,7,8}) = 1
    4=PEARSON({1,2,3,4},{2,20,30,5}) = 0.187
    5=PEARSON({2,20,30,5},{1,2,3,4}) = 0.187
    6=PEARSON({"some text",2,3,4},{5,6,7,8}) = 1
    7=PEARSON({1,2,3,4},{""}) = #N/A
    8=PEARSON({10,20,30,40},{5,6,7,8,9,10}) = #N/A
    9=PEARSON({1,2,3,4},) = #VALUE!
    10=PEARSON("some text",{5,6,7,8}) = #VALUE!
    		 
     Functions - P | Index - P | Office Online 

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