Kendall Rank Correlation in Excel with Unistat
The Unistat statistics add-in extends Excel with Kendall Rank Correlation capabilities.
Further documentation is available at section 6.2.3 of the manual, Correlation Coefficients.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Kendall Rank Correlation
For Introversion and Attitude
| Correction for Ties |
|---|
| Introversion | 0.0000 |
|---|
| Attitude | 2.0000 |
|---|
| Kendall Rank Correlation | 0.6286 |
|---|
| |
| 95% Confidence Interval | -0.0017 <> 0.9014 |
|---|
| |
| Z-Statistic | 2.4545 |
|---|
| 1-Tail Probability | 0.0071 |
|---|
For Introversion and Score
| Correction for Ties |
|---|
| Introversion | 0.0000 |
|---|
| Score | 0.5000 |
|---|
| Kendall Rank Correlation | 0.0449 |
|---|
| |
| 95% Confidence Interval | -0.6017 <> 0.6560 |
|---|
| |
| Z-Statistic | 0.1796 |
|---|
| 1-Tail Probability | 0.4287 |
|---|
For Attitude and Score
| Correction for Ties |
|---|
| Attitude | 2.0000 |
|---|
| Score | 0.5000 |
|---|
| Kendall Rank Correlation | 0.1413 |
|---|
| |
| 95% Confidence Interval | -0.5360 <> 0.7079 |
|---|
| |
| Z-Statistic | 0.5475 |
|---|
| 1-Tail Probability | 0.2920 |
|---|