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.
=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.
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