Functions
CORREL
Pearson correlation coefficient
Try it
When to use it
When should I use CORREL?
Use CORREL to compute the Pearson correlation coefficient between two data sets — a value between -1 and 1 indicating the strength and direction of a linear relationship, useful in regression preparation and data analysis.
Used in
Syntax
CORREL(array1,array2)Examples
=CORREL({3,2,4,5,6},{9,7,12,15,17}) // => 0.9970544855015816