A visual basic spreadsheet macro for geochemical background analysis

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.