RSQ(array1,array2)
array1: first component values
array2: second component values
Strings and empty cells are simply ignored.
This function is Excel compatible.
CORREL, COVAR, INTERCEPT, LINEST, LOGEST, PEARSON, SLOPE, STEYX, TREND.