Analytical Results II - Statistics

<< Click to Display Table of Contents >>

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

Analytical Results II - Statistics

Report Name: Analytical Results II - Statistics (example)

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

Dependencies: Analytical Results II

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Report Grid1

 

Warning: Known Issues have been reported related to Mann-Kendall calculations within this report. Familiarize yourself with the Known Issues prior to using this report.

 

Description: The Analytical Results II - Statistics Report is similar to the Analytical Results - Statistics Report but uses Analytical Results II parameter selections, with more statistical calculations added. The report computes various statistical functions:

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 (10th, 25th, 50th, 75th, 90th, 95th and 99th)

the number of results/detects/non-detects

 

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

 

Overview:

 

Report Parameters

Aggregate


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

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Use DT_GEOGRAPHY for coordinate data

Toggle to use DT_GEOGRAPHY for coordinate data

Sample


Type(s)

Select one or more sample types

Date Range

Section to select the start date, end date, most recent sampling, and the option to use date range to select the most recent sampling events

Matrix(es)

Select one or more sample matrix

Task(s)

Select one or more tasks

Task_Code_2(s)


Field SDG(s)

Select one or more Field SDGs

Depth

Section for selecting the minimum and maximum start and end depths as well as depth unit

Minimum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) above that value will be included. Sample with null START_DEPTH will be excluded.

Maximum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) below that value will be included. Sample with null END_DEPTH will be excluded.

Maximum Start Depth

If a value is entered, only samples that start (DT_SAMPLE.START_DEPTH) below that value will be included. Sample with null START_DEPTH will be excluded.

Minimum End Depth

If a value is entered, only samples that end (DT_SAMPLE.END_DEPTH) above that value will be included. Sample with null END_DEPTH will be excluded.

Unit

Select the desired unit for sample depth min/max.

DQM Status

Select the DQM status.

Test


Method(s)

Select one or more test method

Fraction(s)

Select one or more fraction

Column Number(s)

Select one or more column number

Type(s)

Select one or more test type

Lab Matrix(es)

Select one or more lab matrixes

Prep Method(s)

Select one or more prep methods

Lab SDG(s)

Select one or more Lab SDGs

Result


Analyte

Section for selecting analytes and/or analyte groups

Unit

Selection for report result units

Type(s)

Select one or more result type

Detect Flag(s)

Select one or more options for detect flag.

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Non-Detect Symbol

Enter the desired non-detect symbol ("< ?", "ND", ...).  "?" will be replaced with reporting limit multiplied by non-detect multiplier.

Non-Detect Qualifier

Enter the desired non-detect qualifier (e.g., "U") to have that qualifier override the DETECT_FLAG column.

Reportable

Select one or more options for reportable result.

Validated

Selection for whether the result is validated or not

Reporting Limit

Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)

Format Results\Format Code:

Select one format code (e.g. 0.########, 0.0E-00 etc.) predefined or defined in rt_lookup.lookup_desc with lookup_type='ARII_FORMAT'.

* 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

MAXIMUM

SUM

MEDIAN

STANDARD DEVIATION

VARIANCE

SKEWNESS

MANN-KENDALL S

CONFIDENCE_90%

CONFIDENCE_95%

CONFIDENCE_99%

SEN SLOPE

95% STUDENT'S-T UCL

10TH_PERCENTILE

25TH_PERCENTILE

50TH_PERCENTILE

75TH_PERCENTILE

90TH_PERCENTILE

95TH_PERCENTILE

99TH_PERCENTILE

DETECTS

NON-DETECTS

PERCENT NON-DETECTS

REPORT_RESULT_UNIT

 

Computation Methods and Formulas: Download the methods, equations and the reference links used in the Analytical Results II - Statistics Report provided in this attachment.

 

Note: The report aggregates results based on the selected report parameters and does not automatically separate results based on method, fraction, matrix etc. Users should take care to select the appropriate report parameters so the data is filtered to comparable results. The Go (Append) button can be used to combine the results of multiple combinations of parameter selections into a single report output.

 

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.