Analytical Results - Statistics

Report Name: Analytical Results (Statistics) (example)

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

Dependencies: v54.analytical_results; v54.analytical_result_aggregate

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

Note: The v54 reports have been superseded by more comprehensive class reports (version ‘II’). The Analytical Results – Statistics report was replaced by Analytical Results II - Statistics. EarthSoft recommends using the Analytical Results II – Statistics report rather than Analytical Results – Statistics to take advantage of additional features, fixes, and performance optimization.

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:

•minimum, maximum, mean, median, sum

•standard deviation

•variance

•skewness

•Mann-Kendall S

•Sen slope

•confidence (80%, 85%, 90%, 95%, 99%, and 95%) and 95% Student's-t UCL (UCL = mean + student_t *sd/n).

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

Overview:

The confidence and percentile values are calculated using the Syncfusion confidence and percentile equations, which rely on Excel built-in equations.

Report Parameters

Saved Analytical Results Report	Select a saved Analytical Results user report.
Aggregate Results By	Select how to aggregate the results: elevation, location group or location
Aggregate Analytes By	Select how to aggregate the analytes: individual or group
Process multiple non-detect limits of an analyte at a location	Select how to process multiple non-detect limits: Max, Min, Average, First, Last**
Check the box to add the report_result_limit	Check box to enable the report_result_limit

* The "Additional Fields parameter" may be customized as explained in the help article How To Customize Additional Fields Parameter.

** If selections are cleared from the "Process multiple non-detect limits of an analyte at a location" parameter, calculations use the default Last option.

Report Output
SYS_LOC_CODE X_COORD Y_COORD LONGITUDE LATITUDE CAS_RN CHEMICAL_NAME NUMBER_OF_RESULTS MINIMUM MEAN	MEAN MAXIMUM SUM MEDIAN STANDARD_DEVIATION VARIANCE SKEWNESS MAN-KENDALL S	CONFIDENCE_80% CONFIDENCE_85% CONFIDENCE_90% CONFIDENCE_95% CONFIDENCE_99% SEN SLOPE 95% STUDENT'S-T UCL REPORT_RESULT_UNIT

Report Output

SYS_LOC_CODE

X_COORD

Y_COORD

LONGITUDE

LATITUDE

CAS_RN

CHEMICAL_NAME

NUMBER_OF_RESULTS

MINIMUM MEAN

MEAN

MAXIMUM

SUM

MEDIAN

STANDARD_DEVIATION

VARIANCE

SKEWNESS

MAN-KENDALL S

CONFIDENCE_80%

CONFIDENCE_85%

CONFIDENCE_90%

CONFIDENCE_95%

CONFIDENCE_99%

SEN SLOPE

95% STUDENT'S-T UCL REPORT_RESULT_UNIT

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