Abstract:Although there are many methods to determine thresholds of geochemical anomaly, they all to some extent have such problems as complex calculation process, narrow application scope, and low popularity degree of professional software. Aimed at solving these problems, the authors put forward a method formed by the combination of EDA technique and classical statistical probability method. And a VBA program for this method is developed by using the Application Development Tools in Excel to realize the quick calculation of geochemical anomaly thresholds. This method and VBA program are characterized by simple and convenient calculation, robust anomaly thresholds and wide application range. Nevertheless, according to the principle of this method, it can only be applied to the data from a single parent body which can be recognized by fractal pictures.
龚晶晶, 李方林, 杨刚刚, 欧智德, 张爽. 基于Excel VBA实现箱图剔除法确定化探异常下限[J]. 物探与化探, 2013, 37(5): 926-933.
GONG Jing-jing, LI Fang-lin, YANG Gang-gang, OU Zhi-de, ZHANG Shuang. THE APPLICATION OF BOX-PLOT METHOD TO DETERMINING GEOCHEMICAL ANOMALY THRESHOLDS BASED ON VBA PROCEDURE IN EXCEL. Geophysical and Geochemical Exploration, 2013, 37(5): 926-933.