CORREL Function Explained
The CORREL function in Microsoft Excel calculates the correlation coefficient between two supplied sets of values. It returns a number between -1 and 1, where -1 indicates a perfect negative correlation, 0 indicates no correlation, and 1 indicates a perfect positive correlation. The correlation coefficient can be used to determine the strength of a linear relationship between two variables.
CORREL Function Syntax
CORREL(array1, array2)
- array1: The first array or range of data to consider.
- array2: The second array or range of data to consider.