A visual basic spreadsheet macro for geochemical background analysis

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

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.

MeSH terms

  • Algorithms*
  • Computer Graphics
  • Geological Phenomena
  • Geology
  • Models, Statistical
  • Reference Values
  • Software*
  • Water Pollutants, Chemical / analysis*
  • Water Supply / analysis*

Substances

  • Water Pollutants, Chemical