物探与化探
物探與化探
물탐여화탐
GEOPHYSICAL AND GEOCHEMICAL EXPLORATION
2013年
5期
926-933
,共8页
龚晶晶%李方林%杨刚刚%欧智德%张爽
龔晶晶%李方林%楊剛剛%歐智德%張爽
공정정%리방림%양강강%구지덕%장상
Excel VBA%箱图剔除法%异常下限%分形图%单一母体
Excel VBA%箱圖剔除法%異常下限%分形圖%單一母體
Excel VBA%상도척제법%이상하한%분형도%단일모체
ExcellVBA%boxplot elimination%threshold of geochemical anomaly%fractal picture%single parent body
尽管目前地球化学异常下限的计算方法较多,但不同程度上存在计算过程复杂、应用范围较窄、相关专业软件普及程度低等问题。针对这些问题,笔者提出将EDA技术与经典统计概率法相结合的方法,并应用Excel下的程序开发工具进行VBA编程,在Excel中实现异常下限的快速计算。该方法具有计算简便、异常下限稳健以及应用范围广等优点。依据方法原理,该方法仅适用于来自单一母体的数据样本,来源母体可通过分形图给出初步判定方法。
儘管目前地毬化學異常下限的計算方法較多,但不同程度上存在計算過程複雜、應用範圍較窄、相關專業軟件普及程度低等問題。針對這些問題,筆者提齣將EDA技術與經典統計概率法相結閤的方法,併應用Excel下的程序開髮工具進行VBA編程,在Excel中實現異常下限的快速計算。該方法具有計算簡便、異常下限穩健以及應用範圍廣等優點。依據方法原理,該方法僅適用于來自單一母體的數據樣本,來源母體可通過分形圖給齣初步判定方法。
진관목전지구화학이상하한적계산방법교다,단불동정도상존재계산과정복잡、응용범위교착、상관전업연건보급정도저등문제。침대저사문제,필자제출장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 Excellto 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.