Procedure: Quantiles
UNISTAT statistical package extends Excel with Quantiles support.
Sample output
Here we provide annotated example report output from the UNISTAT Excel add-in for data analysis.
Quantiles
Quantile Method: Simple Average
| Haemoglobin | Platelets | log Leucocytes | Systolic BP |
|---|
| Quantile 1: 10% | -2.3500 | -1.8000 | -2.6500 | -4.0000 |
|---|
| Quantile 2: 20% | -1.9000 | -1.2000 | -1.8500 | -2.0000 |
|---|
| Quantile 3: 30% | -1.3500 | -0.5000 | -1.4500 | -1.0000 |
|---|
| Quantile 4: 40% | -1.1000 | 0.0500 | -1.1500 | 1.0000 |
|---|
| Quantile 5: 50% | -0.6000 | 0.1000 | -0.6500 | 2.0000 |
|---|
| Quantile 6: 60% | -0.1000 | 0.2500 | -0.2500 | 3.5000 |
|---|
| Quantile 7: 70% | 0.0000 | 0.5000 | 0.3500 | 6.5000 |
|---|
| Quantile 8: 80% | 0.5000 | 0.9000 | 1.0500 | 9.0000 |
|---|
| Quantile 9: 90% | 1.6500 | 1.5500 | 1.4500 | 12.0000 |
|---|
Quantile Method: Weighted Average (N+1)
| Haemoglobin | Platelets | log Leucocytes | Systolic BP |
|---|
| Quantile 1: 10% | -2.3900 | -2.1200 | -3.0900 | -5.6000 |
|---|
| Quantile 2: 20% | -2.1400 | -1.3200 | -2.0000 | -2.0000 |
|---|
| Quantile 3: 30% | -1.4100 | -0.7000 | -1.5100 | -1.4000 |
|---|
| Quantile 4: 40% | -1.1200 | 0.0400 | -1.1800 | 0.8000 |
|---|
| Quantile 5: 50% | -0.6000 | 0.1000 | -0.6500 | 2.0000 |
|---|
| Quantile 6: 60% | -0.0800 | 0.2800 | -0.2400 | 3.8000 |
|---|
| Quantile 7: 70% | 0.0000 | 0.5400 | 0.5700 | 7.1000 |
|---|
| Quantile 8: 80% | 0.8000 | 1.0800 | 1.1400 | 9.6000 |
|---|
| Quantile 9: 90% | 2.1700 | 1.8300 | 1.6500 | 13.6000 |
|---|
Quantile Method: Lagged Weighted Average (N-1)
| Haemoglobin | Platelets | log Leucocytes | Systolic BP |
|---|
| Quantile 1: 10% | -2.3100 | -1.4800 | -2.2100 | -2.4000 |
|---|
| Quantile 2: 20% | -1.6600 | -1.0800 | -1.7000 | -2.0000 |
|---|
| Quantile 3: 30% | -1.2900 | -0.3000 | -1.3900 | -0.6000 |
|---|
| Quantile 4: 40% | -1.0800 | 0.0600 | -1.1200 | 1.2000 |
|---|
| Quantile 5: 50% | -0.6000 | 0.1000 | -0.6500 | 2.0000 |
|---|
| Quantile 6: 60% | -0.1200 | 0.2200 | -0.2600 | 3.2000 |
|---|
| Quantile 7: 70% | 0.0000 | 0.4600 | 0.1300 | 5.9000 |
|---|
| Quantile 8: 80% | 0.2000 | 0.7200 | 0.9600 | 8.4000 |
|---|
| Quantile 9: 90% | 1.1300 | 1.2700 | 1.2500 | 10.4000 |
|---|
Quantile Method: Simple Weighted Average (N)
| Haemoglobin | Platelets | log Leucocytes | Systolic BP |
|---|
| Quantile 1: 10% | -2.4000 | -2.2000 | -3.2000 | -6.0000 |
|---|
| Quantile 2: 20% | -2.3000 | -1.4000 | -2.1000 | -2.0000 |
|---|
| Quantile 3: 30% | -1.5000 | -1.0000 | -1.6000 | -2.0000 |
|---|
| Quantile 4: 40% | -1.2000 | 0.0000 | -1.3000 | 0.0000 |
|---|
| Quantile 5: 50% | -1.0000 | 0.1000 | -1.0000 | 2.0000 |
|---|
| Quantile 6: 60% | -0.2000 | 0.1000 | -0.3000 | 2.0000 |
|---|
| Quantile 7: 70% | 0.0000 | 0.4000 | -0.2000 | 5.0000 |
|---|
| Quantile 8: 80% | 0.0000 | 0.6000 | 0.9000 | 8.0000 |
|---|
| Quantile 9: 90% | 1.0000 | 1.2000 | 1.2000 | 10.0000 |
|---|
Quantile Method: Nearest Case (Rounding off)
| Haemoglobin | Platelets | log Leucocytes | Systolic BP |
|---|
| Quantile 1: 10% | -2.4000 | -2.2000 | -3.2000 | -6.0000 |
|---|
| Quantile 2: 20% | -2.3000 | -1.4000 | -2.1000 | -2.0000 |
|---|
| Quantile 3: 30% | -1.5000 | -1.0000 | -1.6000 | -2.0000 |
|---|
| Quantile 4: 40% | -1.2000 | 0.0000 | -1.3000 | 0.0000 |
|---|
| Quantile 5: 50% | -1.0000 | 0.1000 | -1.0000 | 2.0000 |
|---|
| Quantile 6: 60% | -0.2000 | 0.1000 | -0.3000 | 2.0000 |
|---|
| Quantile 7: 70% | 0.0000 | 0.4000 | -0.2000 | 5.0000 |
|---|
| Quantile 8: 80% | 0.0000 | 0.6000 | 0.9000 | 8.0000 |
|---|
| Quantile 9: 90% | 1.0000 | 1.2000 | 1.2000 | 10.0000 |
|---|
Quantile Method: Next Case (Rounding up)
| Haemoglobin | Platelets | log Leucocytes | Systolic BP |
|---|
| Quantile 1: 10% | -2.4000 | -2.2000 | -3.2000 | -6.0000 |
|---|
| Quantile 2: 20% | -2.3000 | -1.4000 | -2.1000 | -2.0000 |
|---|
| Quantile 3: 30% | -1.5000 | -1.0000 | -1.6000 | -2.0000 |
|---|
| Quantile 4: 40% | -1.2000 | 0.0000 | -1.3000 | 0.0000 |
|---|
| Quantile 5: 50% | -1.0000 | 0.1000 | -1.0000 | 2.0000 |
|---|
| Quantile 6: 60% | -0.2000 | 0.1000 | -0.3000 | 2.0000 |
|---|
| Quantile 7: 70% | 0.0000 | 0.4000 | -0.2000 | 5.0000 |
|---|
| Quantile 8: 80% | 0.0000 | 0.6000 | 0.9000 | 8.0000 |
|---|
| Quantile 9: 90% | 1.0000 | 1.2000 | 1.2000 | 10.0000 |
|---|