UNISTAT - the ultimate Excel statistics add-in

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

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

Further documentation is available at section 6.3.3 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.0000	0.0500	0.0000
2	0.1000	0.0377	0.0623	0.0123
3	0.1500	0.0943	0.0557	0.0057
4	0.2000	0.1132	0.0868	0.0368
5	0.2500	0.1509	0.0991	0.0491
6	0.3000	0.2075	0.0925	0.0425
7	0.3500	0.2264	0.1236	0.0736
8	0.4000	0.2453	0.1547	0.1047
9	0.4500	0.3019	0.1481	0.0981
10	0.5000	0.3396	0.1604	0.1104
11	0.5500	0.3585	0.1915	0.1415
12	0.6000	0.4340	0.1660	0.1160
13	0.6500	0.4717	0.1783	0.1283
14	0.7000	0.5283	0.1717	0.1217
(Maximum) 15	0.7500	0.5283	0.2217	0.1717
16	0.8000	0.6226	0.1774	0.1274
17	0.8500	0.7170	0.1330	0.0830
18	0.9000	0.8113	0.0887	0.0387
19	0.9500	0.8679	0.0821	0.0321
20	1.0000	1.0000	0.0000	-0.0500

	Cases	Mean	Standard Deviation	Standard Error
Distance	20	2.7350	1.5246	0.3409