This function examines two sets of data to determine the degree of relationship between the two sets.The result will be a decimal between 0 and 1.The larger the result, the greater the correlation.
Syntax:
=CORREL(Range1,Range2)
Example:
the Monthly temperature is compared against the Sales of Refridgerator units.
The correlation shows that there is an 0.8076 relationship between the data
Here is the video tutorial of the same for clear understanding.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at dptutorials15@gmail.com