![]() |
More on 2.5 StdDevs
John, Tom, gimme, Gys, still there? The problem is to
programmatically provide upper and lower limits for the "reasonable" data and provide the quartile thresholds for the remaining distribution. No user interaction can be required. It's all programmatic. Built-in Excel functions should be used where possible to speed calculations. But accuracy and meaningful numbers trump that. Would be great if any of you would give this a try and post your code! James 36,910 34,872 33,701 30,168 27,791 26,076 16,850 15,687 12,761 12,398 11,932 11,767 10,348 10,270 10,027 9,108 8,817 8,817 8,131 8,077 5,883 5,135 5,126 5,048 4,565 985 2.5 |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com