Outlier Tests in Excel with UNISTAT
The UNISTAT statistics add-in extends Excel with Outlier Tests capabilities.
For further information visit UNISTAT User's Guide section 6.3.4. Outlier Tests.
Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.
Outlier Tests
Dixon’s Outlier Test
Alpha = 0.05
One-tailed tests
| Dixon’s Q | Table Q | Pass/Fail | |
|---|---|---|---|
| X-bar2 Q(Min) | 0.2000 | 0.5240 | Pass |
| Q(Max) | 0.1250 | 0.5240 | Pass |
| Failure time Q(Min) | 0.1173 | 0.5540 | Pass |
| Q(Max) | 0.2582 | 0.5540 | Pass |
N = 15, Q(Min)=(X(3)-X(1))/(X(N-2)-X(1)), Q(Max)=(X(N)-X(N-2))/(X(N)-X(3))
N = 8, Q(Min)=(X(2)-X(1))/(X(N-1)-X(1)), Q(Max)=(X(N)-X(N-1))/(X(N)-X(2))
Grubbs’ Outlier Test
Alpha = 0.05
One-tailed tests
| Grubbs’ G | Table G | Pass/Fail | |
|---|---|---|---|
| X-bar2 G(Min) | 1.5822 | 2.4090 | Pass |
| G(Max) | 1.5343 | 2.4090 | Pass |
| Failure time G(Min) | 1.2318 | 2.0317 | Pass |
| G(Max) | 1.7095 | 2.0317 | Pass |
G = Maximum deviation from mean / Standard Deviation
ESD Outlier Test
Alpha = 0.05
Two-tailed test
Number of outliers to test (ESD) = 2
| ESD Ri | Table Ri | Pass/Fail | |
|---|---|---|---|
| X-bar2 (Min) 1 | 1.5822 | 2.5483 | Pass |
| X-bar2 (Max) 2 | 1.5232 | 2.5073 | Pass |
| Failure time (Max) 1 | 1.7095 | 2.1266 | Pass |
| Failure time (Max) 2 | 1.6162 | 2.0200 | Pass |
Ri = Generalised Extreme Studentised Deviate