UNISTAT - the ultimate
Excel statistics add-in
Shapiro-Wilk Normality Test in Excel with Unistat
The Unistat statistics add-in extends Excel with Shapiro-Wilk Normality Test capabilities.
Further documentation is available at section 6.3.6 of the manual, Goodness of Fit > Normality Tests.
Sample output
Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.
Shapiro-Wilk Normality Test
Smaller probabilities indicate non-normality.
| Cases | Mean | Standard Deviation | Shapiro-Wilk Statistic | |
|---|---|---|---|---|
| Weights of Men | 11 | 172.0000 | 24.9520 | 0.7888 |
| Random Nos | 10 | 449.5000 | 82.0762 | 0.9427 |
| Shapiro-Wilk Significance | Royston Significance | Kolmogorov-Smirnov Significance | Lilliefors Significance | |
| Weights of Men | 0.0100 | 0.0067 | 0.4507 | 0.0374 |
| Random Nos | 0.5593 | 0.5831 | 0.6312 | 0.1163 |
| Overall Test of Normality: | |
|---|---|
| Z-Statistic | -1.5606 |
| 1-Tail Probability | 0.0593 |