Statistics: Analytical Statistics (by Location)

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics Reports >

Statistics: Analytical Statistics (by Location)

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

File Name: EarthSoft.Reports.Library.14425.dll

Dependencies: saved Analytical Results report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1


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.


Installation Instructions: This report assembly is part of the EQuIS Professional installation. No additional installation steps are necessary.



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 this report includes user reports from Analytical Results and Analytical Results II.


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


Report Parameters

Saved Analytical Results Report

Select a saved Analytical Results user report.

Action Level(s)

Parameter for selecting action levels.

Method to process duplicate rows

Parameter to select how to process duplicate rows: Average, Maximum, Minimum, or Sum

Differ Statistics by Start_Depth

Check box to differ statistics by Start_Depth. Default: unchecked

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

Parameter to select the aggregation method for multiple non-detects of an analyte at a location: Max, Min, Average, First, or Last



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.


1Excel report output requires a valid license of Microsoft Excel to view the output.