Kolmogorov and Smirnov D

[S_pera]

Hi

I find an inconsistency of results with two datasets. With the first dataset, the manually calculated answer is consistent with SAS output. But with the second dataset, it is not the case. Please see the attached Excel sheet. Please let me know where the error is. 

Thank you

S_pera

[Reeza]

Excel file isn't displaying for some reason. You also need to provide the SAS code you used. My first guess is ties - does your data have tied values in it?

[S_pera]

Hi Reeza

No there were no ties. I am attaching the Excel file again. Please try.

rgds

S_pera

[Rick_SAS · Accepted solution]

Your formula is incorrect. The KS statistic does not use the AbsDiff column.

Instead you need three columns:

1. LowSn = (cumFreq-1)/5

2. DPlus = F(X) - LowSn

3. DMinus = Sn - F(X)

Then KS = max(DPlus, DMinus)

For more information, see What is Kolmogorov's D Statistic and especially the section "Compute the statistic manually".

[S_pera]

Dear Rick_SAS

Sorted. Thank you very much.

S_pera