Related Experiment Video
Updated: Jul 12, 2026

Two-Dimensional Visualization and Quantification of Labile, Inorganic Plant Nutrients and Contaminants in Soil
Published on: September 1, 2020
A visual basic spreadsheet macro for geochemical background analysis
Zoran Nakić1, Kristijan Posavec, Andrea Bacani
1Faculty of Mining, Geology and Peteroleum Engineering, Department of Geology and Geological Engineering, University of Zagreb, Pierottijeva 6, Zagreb, 10000, Croatia. znakic@rgn.hr
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.
Related Concept Videos
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Overview of Microsoft Excel as a Data Analysis Tool
Microsoft Excel: Regression Analysis
To perform regression...
Microsoft Excel: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data Analysis...

