Spearman Rank Correlation in Excel with Unistat
The Unistat statistics add-in extends Excel with Spearman Rank Correlation capabilities.
Further documentation is available at section 6.2.2 of the manual, Correlation Coefficients.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Spearman Rank Correlation
For Introversion and Attitude
| Correction for Ties |
| Introversion | 0.0000 |
| Attitude | 2.0000 |
| Spearman Rank Correlation | 0.7976 |
| |
| 95% Confidence Interval | 0.3374 <> 0.9501 |
| |
| t-Statistic | 3.7401 |
| Degrees of Freedom | 8.0000 |
| 1-Tail Probability | 0.0029 |
For Introversion and Score
| Correction for Ties |
| Introversion | 0.0000 |
| Score | 0.5000 |
| Spearman Rank Correlation | 0.0851 |
| |
| 95% Confidence Interval | -0.5754 <> 0.6784 |
| |
| t-Statistic | 0.2416 |
| Degrees of Freedom | 8.0000 |
| 1-Tail Probability | 0.4076 |
For Attitude and Score
| Correction for Ties |
| Attitude | 2.0000 |
| Score | 0.5000 |
| Spearman Rank Correlation | 0.2031 |
| |
| 95% Confidence Interval | -0.4891 <> 0.7383 |
| |
| t-Statistic | 0.5866 |
| Degrees of Freedom | 8.0000 |
| 1-Tail Probability | 0.2868 |