View Single Post
Old 2013-09-30, 14:57   #10
gd_barnes
 
gd_barnes's Avatar
 
May 2007
Kansas; USA

52·421 Posts
Default

I agree that the spreadsheet needs some sort of integration (calculus) so that it is accurate over a wide n-range. I wouldn't begin to claim to now how that might be done, especially in Excel. The spreadsheet was originally designed for a large range of k with millions of candidates over a small range of n. For that it is highly accurate. Even with nmax/nmin = 2, it's not too far off.

The "calculation 1" and "calculation 2" formulas are the key. You may need to contact axn here to ask how he came up with them. There also might be a couple of people here at CRUS who might have insight into how they were derived.
gd_barnes is offline   Reply With Quote