How do you find the linear correlation coefficient on Excel?

1 Answer
Bill K.
Aug 6, 2015

Use =CORREL( , ) (actually, this works in Google Sheets as well)

Explanation:

If you have a list of #x#-values in say, cells A1 through A10, and a corresponding list of #y#-values in cells B1 through B10, then entering the following into another cell will give you the linear correlation coefficient:

=CORREL(A1:A10,B1:B10)

Related questions
See all questions in Linear Correlation and Modeling
Impact of this question
3306 views around the world
You can reuse this answer
Creative Commons License