摘要
尽管目前地球化学异常下限的计算方法较多,但不同程度上存在计算过程复杂、应用范围较窄、相关专业软件普及程度低等问题。针对这些问题,笔者提出将EDA技术与经典统计概率法相结合的方法,并应用Excel下的程序开发工具进行VBA编程,在Excel中实现异常下限的快速计算。该方法具有计算简便、异常下限稳健以及应用范围广等优点。依据方法原理,该方法仅适用于来自单一母体的数据样本,来源母体可通过分形图给出初步判定方法。
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.
出处
《物探与化探》
CAS
CSCD
2013年第5期926-933,共8页
Geophysical and Geochemical Exploration
关键词
EXCEL
VBA
箱图剔除法
异常下限
分形图
单一母体
Excel VBA
boxplot elimination
threshold of geochemical anomaly
fractal picture
single parent body
