How do you find the linear correlation coefficient on Excel?

[ad_1]

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

If you enjoy a schedule of ##x##-values in say, cells A1 through A10, and a selfsame schedule of ##y##-values in cells B1 through B10, then entering the subjoined into another cell earn concede you the rectirectilinear mutuality coefficient:

=CORREL(A1:A10,B1:B10)

Show over

[ad_2]
Source incorporate