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 support@earthsoft.com 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 |
|||||
|---|---|---|---|---|---|---|---|
|
|
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
•Max - max of REPORT_RESULT_LIMIT
•Min - min of REPORT_RESULT_LIMIT
•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 support@earthsoft.com 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:
EarthSoft.Reports.Library._14425.AnalyticalStatisticsByLocation