the Statistics Add-In for Microsoft® Excel

Spearman Rank Correlation

Sample Results as an Excel Table:

       

Spearman Rank Correlation

     
       
       
       
 

Income

Price

Horsepower

Income

     

Correlation coefficient

1

0.35745064

0.466279096

valid cases

72

72

72

one-sided significance

0

0.001026297

1.82891E-05

       

Price

     

Correlation coefficient

0.35745064

1

0.645695147

valid cases

72

72

72

one-sided significance

0.001026297

0

4.56182E-10

       

Horsepower

     

Correlation coefficient

0.466279096

0.645695147

1

valid cases

72

72

72

one-sided significance

1.82891E-05

4.56182E-10

0