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