One Sample Kolmogorov-Smirnov in Excel

**gerardoissa** · 07-24-2012, 10:06 PM

Hi again, everybody!
Some of you have asked for an "open" KS worksheet.
Here it goes. Minor improvements have been made to the first one.
Hope it helps.

Georg GARTZ
ggartz@gmail.com

**znf** · 10-16-2012, 04:53 PM

Hi,

I'd like to use your open spreadsheet for Kolgomorov-Smirnov but I have nearly 6000 data points. Is there any way to use it for more than 1000? I tried to simply copy the formulae down the page but there were some errors.

Many thanks,
ZNF

**ronymusic6** · 01-18-2013, 09:12 AM

Originally Posted by gerardoissa

Hi again, everybody!
Some of you have asked for an "open" KS worksheet.
Here it goes. Minor improvements have been made to the first one.
Hope it helps.

Georg GARTZ
ggartz@gmail.com

Thanks for sharing your knowledge!!

**Larry Murphy** · 02-14-2013, 06:38 PM

Hi

Where did you get the table of critical values and are more extensive tables available online?

Thanks

**ggartz** · 02-15-2013, 03:54 AM

Originally Posted by Larry Murphy

Hi

Where did you get the table of critical values and are more extensive tables available online?

Hi Larry!

After much searching, I found a reasonable table on the web at that time.
Now, trying to answer your question, I located...
http://www.aug.edu/~sbajmg/quan6610/...t%20method.pdf

Caution, though: there is discussion about improvements to the underlying formula.
You might want to take a look at...
http://www.itl.nist.gov/div898/handb...on3/eda35g.htm

Hope it helps.

ggartz