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