# How to Calculate the Correlation Coefficient Using the CORREL Function on Excel

Save

Microsoft Excel's CORREL function finds the mathematical correlation between two sets of data. A high coefficient, close to "1", suggests a strong correlation. A coefficient close to "0" suggests little or no correlation. A coefficient close to "-1" suggests a correlation that's strong but negative because an increase in one variable leads to a decrease in the other. Using the CORREL function saves you from having to type out a long and complex statistical formula relating the two data sets.

• Paste the following formula "=CORREL(A2:A6,B2:B6)" into a blank cell in your spreadsheet.

• Replace "A2" with the address of the cell that contains your first data set's first item.

• Replace "A6" with the address of the cell that contains your first data set's last item.

• Replace "B2" with the address of the cell that contains your second data set's first item.

• Replace "B6" with the address of the cell that contains your second data set's last item.

• Press the "Enter" key. The cell's value will change to the correlation coefficient that relates the two arrays of data.

## References

Promoted By Zergnet

## Resources

### You May Also Like

• How to Calculate Correlation

The correlation coefficient, or r, always falls between -1 and 1 and assesses the linear relationship between two sets of data points...

• How to Calculate Time Cards in Excel

Microsoft Excel can be used to track work hours. Time-card templates are available on the Microsoft Office website. The templates contain formulas...

## Related Searches

Check It Out

### Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.