ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   More on 2.5 StdDevs (https://www.excelbanter.com/excel-programming/393171-more-2-5-stddevs.html)

Zone[_3_]

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