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.
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:||Report (UNSPECIFIED)|
|Programmes:||BGS Programmes > Other|
|Additional Information:||This item has been internally reviewed but not externally peer-reviewed|
|Additional Keywords:||Statistics, geochemistry, quality control, ANOVA|
|NORA Subject Terms:||Data and Information
|Date made live:||21 Oct 2009 10:20|
Actions (login required)