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.
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!