Analytical Results II - Statistics (80823)
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019
Report Name: Analytical Results II - Statistics (80823)
previously called (Beta) Analytical Results - Statistics
Report Type: Standard Report
Description: The Analytical Results II - Statistics Report is a report similar to the Analytical Results - Statistics Report. However, it has been adapted to use the Analytical Results Report to make parameter selections, with more statistical calculations added. The report is used to compute various statistical functions, namely: minimum, maximum, mean, median, sum, standard deviation, variance, skewness, Mann-Kendall S, Sen slope, confidence (90%, 95%, 99%, 95% and 99%) and 95% Student's-t UCL. (UCL = mean + student_t *sd/n), percentiles of 10th, 25th, 50th, 75th, 90th, 95th and 99th, and the number of results/detects/non-detects.
Report Dependencies: Analytical Results II
previously called (Beta) Analytical Results
File Name: EarthSoft.Reports.Library.80823.dll
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
In this report is is also possible to filter by additional fields. Learn how here.
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: N/A
Output Type: IGrid
Example Output: View part of the example output below or download the complete output of the example in this attachment.
Professional Build 191160
1.The five new columns of Detects, Non-detects, Percent Non-detects, 95th_Percentile and 99th_Percentile are added into the report result.
2.The new selection of “individual analyte + fraction” is added in the "Aggregate analytes by” parameter to distinguish fraction. If the new item is selected, the values of the chemical_name field include fraction info for the analytes with none N (or Normal) fraction, e.g. "Benzene, T".
1.In EQuIS 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 is fixed (Case 139612).
EQuIS Version 6.6
1.If the "Aggregate Results By" parameter is selected as loc_group and the "Location - Group(s)" is selected, Analytical Results II - Statistics of prior to v6.6 fails to generate results or displays the error message, "Object reference not set to an instance of an object error". The similar issue occurs to the situation where the "Aggregate Analytes By" parameter is selected as group and the "Result/Analyte/Group(s)" is not selected. The issues are fixed. In addition, the report will display an easily understandable message if the parameters are not selected appropriately (Case 131911).