UNISTAT - the ultimate Excel statistics add-in

One Sample Kolmogorov-Smirnov Test: Normal in Excel with Unistat

The Unistat statistics add-in extends Excel with One Sample Kolmogorov-Smirnov Test: Normal capabilities.

Further documentation is available at section 6.3.4 of the manual, Goodness of Fit > Kolmogorov-Smirnov Tests.

Sample output

Here we provide annotated example report output from the Unistat Excel statistics add-in for data analysis.

Case	Expected (Distance)	Theoretical	Difference	Lag Difference
1	0.0500	0.0807	-0.0307	-0.0807
2	0.1000	0.1022	-0.0022	-0.0522
3	0.1500	0.1418	0.0082	-0.0418
4	0.2000	0.1570	0.0430	-0.0070
5	0.2500	0.1906	0.0594	0.0094
6	0.3000	0.2486	0.0514	0.0014
7	0.3500	0.2699	0.0801	0.0301
8	0.4000	0.2920	0.1080	0.0580
9	0.4500	0.3628	0.0872	0.0372
10	0.5000	0.4130	0.0870	0.0370
(Maximum) 11	0.5500	0.4388	0.1112	0.0612
12	0.6000	0.5431	0.0569	0.0069
13	0.6500	0.5946	0.0554	0.0054
14	0.7000	0.6686	0.0314	-0.0186
15	0.7500	0.6686	0.0814	0.0314
16	0.8000	0.7776	0.0224	-0.0276
17	0.8500	0.8626	-0.0126	-0.0626
18	0.9000	0.9222	-0.0222	-0.0722
19	0.9500	0.9470	0.0030	-0.0470
20	1.0000	0.9810	0.0190	-0.0310

	Cases	Mean	Standard Deviation	Standard Error
Distance	20	2.7350	1.5246	0.3409