How to Calculate Correlation in Excel

For you to make appropriate correlation calculation, it is important to have two different columns. It makes it easier to know if there is any correlation between them. We are going to use unit price and quantity of sold units to determine if there is any correlation between them.

The data

Layout the columns, we have chosen unit price and sold units for this calculation.

Correlation data

The formula

Click on an empty column on the unit sold (1), and type in =CORREL(columns that are relevant to the columns ex. A1:A4, B1:B3), which is number 2 in the picture below.

=CORREL(A4:A14,B4:B14)

Correlation Excel formula

Now you can create correlation chart based on above correlation data..

You can download free Correlation Calculator template here

Further reading:
How to calculate covariance?
How to insert Correlation chart?