PEARSON(independent, dependent) returns the Pearson product moment correlation coefficient : PEARSON « Statistical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =PEARSON(B2:B6,C2:C6). Press Enter to get the result.
Input the formula: =PEARSON(B2:B6,C2:C6)
21.55.PEARSON
21.55.1.PEARSON(independent, dependent) returns the Pearson product moment correlation coefficientPEARSON(independent, dependent) returns the Pearson product moment correlation coefficient