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?
8 years ago
Science Question asked by Lavinia
Add a Comment
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.
1 Answer
Hi,
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!
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!