Correlation is a statistical measure that expresses the extent to which two variables change together at a constant rate.
Correlation tells us if the two variables have a linear relationship, and the strength of that relationship.
Formula to calculate correlation in excel.
We can find correlation in excel by using the CORREL Function.
Example:
Suppose you have two sets of data and you are asked to find their correlation.
| Name of Student | Math Score(%) | Language Score(%) |
| Mike | 84 | 70 |
| Esther | 90 | 80 |
| Alice | 78 | 90 |
| Queen | 64 | 78 |
| Prince | 89 | 82 |
We begin by transferring our data onto an excel worksheet.
On the More Functions option and the statistical function find the CORREL Function, when you click on it, you should get a table like this
Fill in the function argument and get your answer.
