CORREL(array1,array2) returns the correlation coefficient between two data sets : CORREL « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. CORREL
Input the formula: =CORREL(B2:B6,C2:C6). Press Enter to get the result.
Input the formula: =CORREL(B2:B6,C2:C6)
21.10.CORREL
21.10.1.CORREL(array1,array2) returns the correlation coefficient between two data setsCORREL(array1,array2) returns the correlation coefficient between two data sets