Tutor HuntQuestions

Tutor Hunt Questions

Is the y intercept equation on a scatter graph produced on excel meant to be the same as the correlation coefficient in a spearmans test from spss. or is the y intercept a different thing?
7 years ago

General Science Question asked by Lavinia

Know the Answer?

Please enter your response to the question below. The student will get a notification as soon your response has been approved by our moderation team.

Submit Answer

1 Answer

What Excel reports is the parametric Pearson`s r-squared. It might well be different from the Spearman`s rho vlaue if the data are significantly non-normally distributed. Although Excel doesn`t seem to state which it is, the help file for the Correl function gives the Pearson equation.
Hope this helps!
Answered by David | 7 years ago
    Rate Up  Rate Down