Sign Up
Tutor Hunt on twitter Tutor Hunt on facebook

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?
10 months 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

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!
Answered by David | 10 months ago
    Rate Up  Rate Down     
Ask an Academic Question
Popular Links
© 2005-2017 Tutor Hunt - All Rights Reserved

Privacy | Copyright | Terms of Service
loaded in 0.047 seconds
twitter    facebook