CORREL

Definition: CORREL is a function that returns the correlation coefficient between two sets of data.

Syntax: =CORREL(array1, array2)

Situation: This formula is suitable when you need to find the correlation between two sets of data.

Example: If you have two sets of data in arrays A1:A10 and B1:B10, the correlation can be found using the formula =CORREL(A1:A10, B1:B10), which returns a value between -1 and 1.