Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

PEARSON(independent, dependent) returns the Pearson product moment correlation coefficient

Input the formula: =PEARSON(B2:B6,C2:C6). Press Enter to get the result.