# 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

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

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

### Easy to Use

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

### Proven and Trusted

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

- Only