Spearman Rank Correlation Coefficient Test in Excel using the QI Macros

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.

Test Example

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.

Watch Non-parametric tests in Excel Video

The Spearman test is just one of the tests included in the QI Macros Statistical Process Control software. Other tests include:

• Overvew of all hypothesis tests in Excel
• Other Non parametric tests in Excel in the QI Macros

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma