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. Simply open the template on QI Macros menu.
  2. Input your data into the yellow shaded areas.
  3. QI Macros template performs the calculations for you.

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

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?

    affordable

    Affordable

    • Only $249 USD - less with quantity discounts
    • No annual fees
    • Free Technical Support

    easy to use

    Easy to Use

    • Works Right in Excel
    • Interprets Results for You
    • Accurate Results Without Worry

    proven and trusted

    Proven and Trusted

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