| 基于ExcelVBA实现箱图剔除法确定化探异常下限 |
| |
| 引用本文： | 龚晶晶,李方林,杨刚刚,欧智德,张爽.基于ExcelVBA实现箱图剔除法确定化探异常下限[J].物探与化探,2013(5):926-933. |
| |
| 作者姓名： | 龚晶晶 李方林 杨刚刚 欧智德 张爽 |
| |
| 作者单位： | 中国地质大学 地球科学学院,湖北 武汉,430074 |
| |
| 摘 要： | 尽管目前地球化学异常下限的计算方法较多，但不同程度上存在计算过程复杂、应用范围较窄、相关专业软件普及程度低等问题。针对这些问题，笔者提出将EDA技术与经典统计概率法相结合的方法，并应用Excel下的程序开发工具进行VBA编程，在Excel中实现异常下限的快速计算。该方法具有计算简便、异常下限稳健以及应用范围广等优点。依据方法原理，该方法仅适用于来自单一母体的数据样本，来源母体可通过分形图给出初步判定方法。
|
| 关 键 词： | Excel VBA 箱图剔除法 异常下限 SY形图 单一母体 |
THE APPLICATION OF BOX-PLOT METHOD TO DETERMINING GEOCHEMICAL ANOMALY THRESHOLDS BASED ON VBA PROCEDURE IN EXCEL |
| |
| 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[J].Geophysical and Geochemical Exploration,2013(5):926-933. |
| |
| Authors: | GONG Jing-jing LI Fang-lin YANG Gang-gang OU Zhi-de ZHANG Shuang |
| |
| Institution: | ( Faculty of Earth Sciences, China University of Geosciences, Wuhan 430074, China) |
| |
| Abstract: | Although there are many methods to determine thresholds of geochemical anomaly, they all to some extent have such prob- lems 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 cal- culation of geochemical anomaly thresholds. This method and VBA program are characterized by simple and convenient calculation, ro- bust 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. |
| |
| Keywords: | ExcellVBA boxplot elimination threshold of geochemical anomaly fractal picture single parent body |
| 本文献已被 维普 万方数据 等数据库收录！ |
