Analytical Results - Statistics (25190)
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019
Report Name: Analytical Results (Statistics) (25190)
Report Type: Standard
Description: The Analytical Results (Statistics) Report is a new report based on the standard Analytical Results (Aggregate) Report. It computes various statistical functions not found in the aggregate report, namely: minimum, maximum, mean, median, sum, standard deviation, variance, skewness, Mann-Kendall S, Sen slope, confidence (90%, 95%, 99%, and 95%) and 95% Student's-t UCL (UCL = mean + student_t *sd/n). As of EQuIS Version 6.5, 80% and 85% confidence level calculations are also included. The confidence and percentile values are calculated using the Syncfusion confidence and percentile equations, which rely on Excel built-in equations.
Report Dependencies: v54.analytical_results; v54.analytical_result_aggregate
File Name: EarthSoft.Reports.Library.25190.dll
Input Parameters: A selection made to customize the output of a report.
Input Parameter Screenshot
95% STUDENT'S-T UCL REPORT_RESULT_UNIT
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: Excel
Output Type: Excel
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 was fixed (Case 139612).
Example Output: View the following example or download the attachment.