Skip to main content
Article thumbnail
Location of Repository

Within site and between site nested analysis of variance (ANOVA) for Geochemical Surveys using MS EXCEL

By C.C. Johnson


This report describes a method of nested analysis of variance (ANOVA) using a visual basic macro in Microsoft EXCEL 2000. Nested ANOVA analysis is used in geochemical surveys to test the suitability of the sampling and analytical methodology and quantifies the within site and between site variability. If the between site variability is greater than the within site variability then the survey methodology is satisfactory. BGS uses this quality control procedure for its national and international geochemical surveys. However, the restricted availability of specialist\ud statistical software to do nested ANOVA has often resulted in a variety of software packages being used for different projects. This report describes a method of nested ANOVA that can be done using the widely available Microsoft EXCEL. Data input format and result reporting is similar to that used on the Geochemical Baseline Survey of the Environment (G-BASE) Project

Topics: Data and Information, Earth Sciences
Publisher: British Geological Survey
Year: 2002
OAI identifier:

Suggested articles

To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.