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
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
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
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.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021