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.
Suppose you have two sets of data and you are asked to find their correlation.
|Name of Student||Math Score(%)||Language Score(%)|
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.