How To Calculate

Learn how to calculate anything
Menu
  • bmi
Home
statistics
How to Calculate Correlation in Excel.
statistics

How to Calculate Correlation in Excel.

Rosemary Njeri

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 StudentMath Score(%)Language Score(%)
Mike8470
Esther9080
Alice7890
Queen6478
Prince8982

We begin by transferring our data onto an excel worksheet.

 Calculate Correlation in Excel.

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

Calculate Correlation in Excel.

Fill in the function argument and get your answer.

 Calculate Correlation in Excel.

Share
Tweet
Reddit
Pinterest
Email
Prev Article
Next Article

Related Articles

How to Calculate Median in Excel.
In this article, we will define and discuss how to …

How to Calculate Median in Excel.

How to Calculate RSD.
Rsd is short for relative standard deviation. Rsd is a …

How to Calculate RSD.

Popular Posts

    Categories

    learntocalculate.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.com.

    How To Calculate

    Learn how to calculate anything

    Pages

    • About Us
    • Contact Us
    • Privacy Policy
    Copyright © 2025 How To Calculate

    Ad Blocker Detected

    Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

    Refresh