用于地球化学背景分析的Visual Basic电子表格宏。

A visual basic spreadsheet macro for geochemical background analysis.

作者信息

Nakić Zoran, Posavec Kristijan, Bacani Andrea

机构信息

Faculty of Mining, Geology and Peteroleum Engineering, Department of Geology and Geological Engineering, University of Zagreb, Pierottijeva 6, Zagreb, 10000, Croatia.

出版信息

Ground Water. 2007 Sep-Oct;45(5):642-7. doi: 10.1111/j.1745-6584.2007.00325.x.

DOI:10.1111/j.1745-6584.2007.00325.x

PMID:17760589

Abstract

A Visual Basic macro entitled BACKGROUND calculates geochemical background values of chemical parameters and estimates threshold values separating background data from anomalies. The macro uses two statistical methods, the iterative 2-sigma technique and the calculated distribution function, and integrates these model-based objective methods into a widely accessible platform (i.e., MS Excel). The macro offers the possibility for automated processing of geochemical data and enables an automated generation of background range and threshold values for chemical parameters.

摘要

一个名为“BACKGROUND”的Visual Basic宏可计算化学参数的地球化学背景值，并估计将背景数据与异常区分开的阈值。该宏使用两种统计方法，即迭代双标准差技术和计算分布函数，并将这些基于模型的客观方法集成到一个广泛使用的平台（即MS Excel）中。该宏提供了对地球化学数据进行自动化处理的可能性，并能够自动生成化学参数的背景范围和阈值。