nerc.ac.uk

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

Johnson, C.C.. 2002 Within site and between site nested analysis of variance (ANOVA) for Geochemical Surveys using MS EXCEL. Nottingham, UK, British Geological Survey, 25pp. (IR/02/043) (Unpublished)

Before downloading, please read NORA policies.
[img]
Preview
Text
IR02043.pdf

Download (131Kb)

Abstract/Summary

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 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.

Item Type: Publication - Report (UNSPECIFIED)
Programmes: BGS Programmes > Other
Funders/Sponsors: NERC
Additional Information. Not used in RCUK Gateway to Research.: This item has been internally reviewed but not externally peer-reviewed
Additional Keywords: Statistics, geochemistry, quality control, ANOVA
NORA Subject Terms: Data and Information
Earth Sciences
Date made live: 21 Oct 2009 10:20
URI: http://nora.nerc.ac.uk/id/eprint/8364

Actions (login required)

View Item View Item

Document Downloads

More statistics for this item...