Normality Tests in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with Normality Tests capabilities.

For further information visit UNISTAT User's Guide section 6.3.3. Normality Tests.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

Normality Tests

Subsample selected by: Gender = Male
Smaller probabilities indicate non-normality.
* Lilliefors probability = 0.2 means 0.2 or greater.

	Valid Cases	Mean	Standard Deviation	Shapiro-Wilk Test	Probability	Kolmogorov-Smirnov Test	* Probability	Cramer-von Mises Test	Probability	Anderson-Darling Test	Probability
BUN	29	34.2414	31.2737	0.6843	0.0000	0.2191	0.0010	0.4002	0.0000	2.4551	0.0000
CA	29	10.2759	1.5094	0.8631	0.0014	0.2622	0.0000	0.2751	0.0006	1.5007	0.0006
HB	29	10.9621	2.6540	0.9464	0.1473	0.1198	0.2000	0.0631	0.3331	0.4575	0.2462
PC	29	43.0345	30.4648	0.8928	0.0066	0.1829	0.0143	0.1527	0.0203	1.0156	0.0096

Subsample selected by: Gender = Female
Smaller probabilities indicate non-normality.
* Lilliefors probability = 0.2 means 0.2 or greater.

	Valid Cases	Mean	Standard Deviation	Shapiro-Wilk Test	Probability	Kolmogorov-Smirnov Test	* Probability	Cramer-von Mises Test	Probability	Anderson-Darling Test	Probability
BUN	19	33.4211	42.9500	0.5572	0.0000	0.3923	0.0000	0.6917	0.0000	3.5721	0.0000
CA	19	9.4211	1.2164	0.8448	0.0055	0.2143	0.0217	0.1700	0.0114	1.0174	0.0086
HB	19	9.1684	2.7045	0.9409	0.2732	0.1423	0.2000	0.0787	0.2024	0.4883	0.1965
PC	19	42.7895	30.1544	0.9121	0.0810	0.1553	0.2000	0.0997	0.1044	0.6139	0.0941