Statistics: Analytical Statistics (by Location) (14425)

<< Click to Display Table of Contents >>

Statistics: Analytical Statistics (by Location) (14425)

Report Name: Statistics: Analytical Statistics (by Location) (14425)


Report Type: Standard


Description: The report generates the statistics information of Mean, UCL, Median, Standard Deviation, Coefficient of Variation, Skewness, Minimum, Maximum, Count (n), Mann-Kendall S, Trend analysis (at 80% confidence, 90% confidence, 95% confidence, 99% confidence) and Sen Slope based on a saved Analytical Results Report.


If the Action Level input is selected, the report will indicate action level violations. If a statistical value (Mean, UCL, Median, Minimum or Maximum) is greater than an action level value, the value is highlighted. Up to four action levels can be used in the report. The statistics can be for each sampling depth of each location or for each location without differing sample depths. The "Differ Statistics By START_DEPTH" input parameter was added in EQuIS Professional Version 5.6.


The confidence level for results is calculated based on the Data Quality Assessment: Statistical Methods for Practitioners, EPA QA/G-9S. The details are:


When samples > 10, use Table A-1 of EPA QA/G-9S.

When samples <= 10, use Table A-12a of EPA QA/G-9S. Under this scenario, a note is recorded in the report from Table A-1 of Guidance on Natural Attenuation for Petroleum Releases Remediation and Redevelopment Program, Wisconsin DNR (different from EPA table for 10 percent confidence interval due to greater resolution in the Wisconsin table relative to that provided in Table A-12a of EPA QA/G-9S).


The Student T distribution is used to calculate the Upper Confidence Level as UCL = Mean + t *SD/N


The list of the Saved Analytical Results II or Analytical Results Report: parameter in the report of version 6.6 or later includes user (formerly "pick") reports from Analytical Results and Analytical Results II.


File Name: EarthSoft.Reports.Library.14425


Contact for a direct file link. 


Language: English


Input Parameters: A selection made to customize the output of a report.


Input Parameters

Input Parameter Screenshot

Output Columns

Saved Analytical Results Report

Action Level(s)

Method to process duplicated rows

Differ Statistics by START_DEPTH

Process multiple non-detect limits of an analyte at a location.



Excel Spreadsheet


The "Method to process duplicated rows" parameter defines how to calculate result value from result limit:


First - REPORT_RESULT_LIMIT from the earliest SAMPLE_DATE

Last - REPORT_RESULT_LIMIT from the most recent SAMPLE_DATE



Average - average of REPORT_RESULT_LIMIT


When calculating, data rows with the following are ignored:


null value for REPORT_RESULT_LIMIT

100000000' value

'99999999' value


The "Process multiple non-detect limits of an analyte at a location" parameter aggregates the multiple non-detect limits of an analyte per location and replaces REPORT_RESULT_VALUE with REPORT_RESULT_LIMIT.


Note that results that do not have an associated DETECT_FLAG='Y' or 'TR' are assumed as non-detects.


Data are populated using the Analytical Results, so REPORT_RESULT_VALUE=REPORT_RESULT_LIMIT*ND_MULTIPLIER and unit is converted.


Tables: All tables used by the Analytical Results Report and DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, ST_REPORT, ST_USER_REPORT


Database Type: SQL


Database Schema: Standard (no custom or add-on schemas required)


Database Version: EQuIS 5.4.3+


Data Requirements: N/A


Report Requirements: Contact for more information.


Output Type: Excel


Revision History:


In version 7, when the Max or Min of the "Process multiple non-detect limits of an analyte at a location:" parameter is selected and there are multiple non-detects per analyte/location (e.g. 11 and 2), the report may not correctly process the maximum or minimum non-detect (e.g. it picks 11 as minimum or 2 as maximum). This issue was fixed (case 139612).


Example Output: View the examples below.


The results with differing sampling START_DEPTHS:


The results without differing sampling START_DEPTHS: