Earth Consultants

Applying Lean Six Sigma to the Environment

Minitab Tutorial and Excel Data Tables for Utilizing the EPA’s Statistical Analysis at RCRA Facilities document

2 min read

In March 2009, the EPA published the document called “STATISTICAL ANALYSIS OF GROUNDWATER MONITORING DATA AT RCRA FACILITIES”

OFFICE OF RESOURCE CONSERVATION AND RECOVERY

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.

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:

  1. 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.
  2. 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 document, and 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.

Download the Excel data tables and Minitab Tutorial file >>>

1 thought on “Minitab Tutorial and Excel Data Tables for Utilizing the EPA’s Statistical Analysis at RCRA Facilities document

  1. Pingback: My Homepage

Comments are closed.

Copyright © BPI. All rights reserved. | Newsphere by AF themes.