Pearson-Spearman-Kendall Correlations Matrix in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Pearson-Spearman-Kendall Correlations Matrix capabilities.
For further information visit UNISTAT User's Guide section 6.2.2. Pearson-Spearman-Kendall Correlations Matrix.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Pearson-Spearman-Kendall Matrix
| Haemoglobin | Platelets | log Leucocytes | ||||||
|---|---|---|---|---|---|---|---|---|
| Corr | No | 2-Tail P | Corr | No | 2-Tail P | Corr | No | |
| Haemoglobin Prsn | -0.0666 | 10 | 0.0000 | -0.3937 | 10 | |||
| Spmn | -0.0976 | 10 | 0.7886 | -0.4073 | 10 | |||
| Kndl | -0.0227 | 10 | 0.9282 | -0.2697 | 10 | |||
| Platelets Prsn | -0.0666 | 10 | 0.0000 | 0.4181 | 10 | |||
| Spmn | -0.0976 | 10 | 0.7886 | 0.4377 | 10 | |||
| Kndl | -0.0227 | 10 | 0.9282 | 0.3596 | 10 | |||
| log Leucocytes Prsn | -0.3937 | 10 | 0.0000 | 0.4181 | 10 | 0.0000 | ||
| Spmn | -0.4073 | 10 | 0.2427 | 0.4377 | 10 | 0.2058 | ||
| Kndl | -0.2697 | 10 | 0.2812 | 0.3596 | 10 | 0.1508 | ||
| Systolic BP Prsn | 0.3990 | 10 | 0.0000 | 0.2507 | 10 | 0.0000 | -0.4816 | 10 |
| Spmn | 0.3639 | 10 | 0.3012 | 0.2997 | 10 | 0.4002 | -0.3110 | 10 |
| Kndl | 0.2299 | 10 | 0.3654 | 0.1839 | 10 | 0.4690 | -0.2046 | 10 |
| Systolic BP | ||||||||
| 2-Tail P | Corr | No | 2-Tail P | |||||
| Haemoglobin Prsn | 0.0000 | 0.3990 | 10 | 0.0000 | ||||
| Spmn | 0.2427 | 0.3639 | 10 | 0.3012 | ||||
| Kndl | 0.2812 | 0.2299 | 10 | 0.3654 | ||||
| Platelets Prsn | 0.0000 | 0.2507 | 10 | 0.0000 | ||||
| Spmn | 0.2058 | 0.2997 | 10 | 0.4002 | ||||
| Kndl | 0.1508 | 0.1839 | 10 | 0.4690 | ||||
| log Leucocytes Prsn | -0.4816 | 10 | 0.0000 | |||||
| Spmn | -0.3110 | 10 | 0.3818 | |||||
| Kndl | -0.2046 | 10 | 0.4171 | |||||
| Systolic BP Prsn | 0.0000 | |||||||
| Spmn | 0.3818 | |||||||
| Kndl | 0.4171 |