Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

How do you find the linear correlation coefficient on Excel?

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

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)

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question