One Sample Kolmogorov-Smirnov in Excel

Very interesting - will definitely take a look at this. Think I may already have a statistical toolset that can do this (and I know Matlab would cover this but I don't have Matlab) but I'm always keen to learn how to do new things. I'd been looking to get a better understanding of this (someone on here explained to me how to do a Chi Squared test the other week which was helpful).

----

After taking a look at this something does seem to be slightly missing. Re: one of the posts above the formula doesn't stack up as you ultimately don't get the following:

D max+
D max-
D max abs
Z - which is very significant
P - which is very significant

and as the sheet is locked you can't edit things (which I was most interested in - e.g. I was keen to see the process behind the test, not having a strong mathematical background but a reasonable understanding of excel). Hope this helps. Don't know what caught my eye about this post (but just thought I should have a look).

--------

one further clarification on this and it was possibly my mistake or lack of clarification from the OP I expect that this sheet really only works with 2007 or newer as it has a xlfn.IFERROR(MAX(OFFSET($AJ$9,0,0,$J$10,1)-OFFSET($AK$9,0,0,$J$10,1)),"") - which as most of us 2003 users know won't work in 2003 (as IFERROR doesn't exist) without a substantial workaround. This sheet may be fine for 2007 onwards.

------

Final edit for all of the pre 2007 users out there you can re-work the IFERROR formula to (in the case of the above) something like this:=IF(ISERROR(MAX(OFFSET($AJ$9,0,0,$J$10,1)-OFFSET($AK$9,0,0,$J$10,1))),"",MAX(OFFSET($AJ$9,0,0,$J$10,1)-OFFSET($AK$9,0,0,$J$10,1))) - further details in the thread: http://www.excelforum.com/excel-gene...in-2003-a.html
and thanks to Martin for his time and the pointers. I've re-worked the sheet and it looks about right but where I only know roughly what I'm doing mathematically I can't say that it's 100%. Hope this helps someone.