Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

RSQ(y,x) returns the square of the Pearson product moment correlation coefficient

Input the formula: =RSQ(B2:B8,C2:C8). Press Enter to get the result.