Returns the square of the Pearson correlation coefficient based on the given values.
DataY is an array or range of data points.
DataX is an array or range of data points.
RSQ (also called determination coefficient) is a measure for the accuracy of an adjustment and can be used to produce a regression analysis.
=RSQ(A1:A20;B1:B20) calculates the determination coefficient for both data sets in columns A and B.