The CORREL function in Excel is used to find the relationship between two set of values. The result will be ranging from 0 to 1. Greater the result, greater the correlation.
Formula:
=CORREL(Array 1,Array 2) Whereas Array 1 is the first set of cells (which contains values) whose relationship has to be identified with the second set of values. Array 2 is the second set of cells (which contains values) whose relationship has to be identified with the first set of values.
Video Tutorial:
Let us learn how to find the correlation between two set of values using CORREL function with the help of the video tutorial given below