Which type of correlation should I use? I am beginner in statistics. I have excel table with few columns. I would like to find correlation between the variables. I have to make an essay to my boss and he wants concrete answers. I searchin on the internet, and i find this online tool:
Correlation coefficient calculator
I have nothing problem with that tool but it shows me 2 type of correlation coefficient. One of them is the Spearman and the other one is the Pearson.
Which one should I have to use? Which one is the better, more credible?Please Help.
Thank you in advance,
David
 A: Pearson's correlation measures the linear component of association.
It will be +1 if a plot of one variable against another has all points exactly on an upward-sloping line, and -1 if all points are exactly on a downward-sloping line. If there is little or no linear aspect of association then Pearson's correlation will be near 0.
Spearman's correlation is based on ranks, and may give misleading results if there are more than a few tied values in either variable. If y always increases when x increases, then the value will be +1 whether or not the progression is linear.
It would not be appropriate to suggest one method over the other without knowing more about your data, and your purpose for wanting
to look at the association between two variables.
In the following example, there is an exact linear relationship
between X and Y, and the relationship between X and Z is strong
but not linear. It may be a clearer example if you make
two plots: (a) x vs. y, and (b) x vs. Z.
 x:   1  2  3  4  5  6  7  8    9 10
 y:   5  7  9 11 13 15 17 19   21 23
 z:   1  2  3  5  7 10 20 50 100 300

 cor(x,y)  # Pearson
  ## 1
 cor(x,z)  # Pearson
  ## 0.7200748
 cor(x, z, method="spearman")
  ## 1

