CORREL Function

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

Learn MS Excel


Ask Questions

Ask Question