RSQ


Returns the square of the Pearson correlation coefficient of two sets of data.

Syntax:

RSQ(x, y)

where x and y are ranges or arrays containing the two sets of data.
Any text or empty entries are ignored.
RSQ calculates the square of the Pearson correlation coefficient (which is conventionally given the letter r, hence "r squared").
RSQ indicates how much of the variance in y is attributable to the variance in x.

Example:

RSQ(A1:A30, B1:B30)
returns the square of the Pearson correlation coefficient for the two sets of data in A1:A30 and B1:B30.







 
Created with Zapof