Spearman Rank Correlation Coefficient Test in Excel

One of Many Tests in QI Macros Statistical Add-in for Excel

When to Use the Spearman Rank Correlation Coefficient

A Spearman correlation correlates the ranks of two sets of data rather than the data itself as Excel's correlation function does.

Spearman Test Example Using QI Macros Template

  1. To open the template, click on the QI Macros menu and select Stat Templates > Spearman
  2. Input your data into the yellow shaded areas in columns A:M.
  3. QI Macros template performs the calculations for you in columns N:AM.

Comparing the number cigarettes smoked by 10 smokers (column A) and their diastolic blood pressure (Column B) gives these results.

Note: In the example, below we have hidden the unused columns. Never delete rows or columns in QI Macros templates as you may accidentally break formulas.

Spearman Test output

Hypothesis Test: Since the correlation (0.367) isn't 0.80 or greater, we cannot conclude there is a correlation between smoking and hypertension in these ten smokers.

Learn More...

  • Mann Whitney Test
  • Other Non Parametric Tests

    Why Choose QI Macros Statistical Software for Excel?

    easy to use

    Easy to Use

    • Works Right in Excel
    • Interprets p-values for You
    • Accurate No-Worry Results
    • Free Training Anytime

    proven and trusted

    Proven and Trusted

    • 100,000 Users in 80 Countries
    • Celebrating 20th Anniversary
    • Five Star CNET Rating - Virus Free



    • Only $349 USD
      Quantity Discounts Available
    • No annual fees
    • Free Technical Support