Analytical Results – Statistics

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports > Statistics >

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

 

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