In March 2009, the EPA published the document called “STATISTICAL ANALYSIS OF GROUNDWATER MONITORING DATA AT RCRA FACILITIES.”
The document is meant to provide support to RCRA facilities on how to apply the correct statistical techniques. It is essentially a statistics reference guide focused on groundwater contamination data. However, it is a good statistical reference book in general, so it is highly recommended for anyone using statistics to analyze environmental and other non-normal data. If you would like to read more about the guide, and what concepts and techniques are covered, download a summary PDF of the 2009 release updates >>>
Starting on Chapter 9 of the document, there are exercises and data tables, with instructions on how to create the charts or complete the analysis. If you already are using Minitab statistical software, then you would probably like to know how Minitab does these tasks for you. What you need to do is copy the data into Minitab, and start clicking around.
There are two issues with this document:
- It is not written for use with any statistical software – Although that was the original intent, for those of you who have a statistical program you are familiar with, it takes some time to figure out how to recreate the same charts and analysis.
- The data files are not available for download from the EPA website related to this document. If you wanted to import the data into your statistical program, it takes some effort to copy/paste and re-format the data correctly, so it can be analyzed. We went through and did that for you, and provided it in Excel.
If you would like to download the data files in Excel, along with screen shots and tutorials for generating the charts and analysis in Minitab, click here to get access to the file for FREE >>>
If you are using another statistical program (JMP, R, SAS, etc), let us know, and we’ll create some tutorials for them. If you don’t want to wait, you can download the Excel data files, and try and figure it out yourself.