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.