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.

Related Searches

References

Promoted By Zergnet

Comments

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.
Submit Your Work!