Analytical Statistics

<< Click to Display Table of Contents >>

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

Analytical Statistics

Report Name: Analytical Statistics

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

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English, Spanish

Output Type: Excel1

 

Description: This report allows for the comparison of results to historical data from the specified statistical date range. It includes the option to highlight exceedances and results that fall outside the range of the historical values as well as display the information in graphical form.

 

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

 

Overview:

 

Note: When one action_level_code has two lines, it means a range of action levels (action_level and action_level_min are populated in DT_ACTION_LEVEL_PARAMETER) for an analyte exist.

 

Source Tables DT_FIELD_SAMPLE, DT_STATIC_PROPS, DT_TEST, DT_RESULT, RT_ANALYTE, RT_MTH_ANL_GROUP, RT_ANALYTE_VAR, VW_LOCATION, DT_TASK, DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_LOCATION, RT_MTH_ANL_GROUP_MEMBER

 

Report Parameters

Location


Individual(s)

Parameter for selecting individual locations.

Group(s)

Parameter for selecting location groups.

Sample


Type(s)

Select one or more sample types

Date Range

Section to select the sample start date, and end date.

Matrix(es)

Select one or more sample matrix

Task(s)

Select one or more tasks

Delivery Group(s)

Select one or more delivery group

Test


Method(s)

Select one or more test method

Fraction(s)

Select one or more fraction

Result


Analyte

Section for selecting analyte groups

Unit

Selection for report result units

Non-Detect Multiplier

Enter the desired non-detect multiplier value.

Reportable

Select one or more options for reportable result.

Reporting Limit

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

Statistics


Date Range

Select a statistical date range start and end date.

Include Non-Detects?

Check box to include non-detects. Default: True.

Maximum Percentile

Enter the percentile you would like to use for the max comparisons between 0.0 and 1.0.

Action level 1 (Red Font)

Select an action level. Display will be red font.

Action level 2 (Bold)

Select an action level. Display will be bold.

Action Level 3 (Underlined)

Select an action level. Display will be underlined.

Action Level 4 (Italics)

Select an action level. Display will be italics.

Action Level 5 (Orange Background)

Select an action level. Display will be an orange background.

Mark action level exceedances

Check box to mark exceedances. Default: True.

Mark outlier data?

Check box to mark outlier data. Default: True.

Generate graphs?

Select options ofr graph generation: no, Yes all, Yes only exceedances.

Generate graphs?


Plot maximum?

Check to plot maximum. Default: True

Secondary axis

Select an analyte for the second axis.

Do you want to separate results by analytic methods?

Check box to separate results by analytic methods. Default: Yes

Cell A4

Choose the fill for box A4: sys_loc_code, loc_name, loc_desc

Show Matirx code?

Check box to show matrix code. Default: False

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

 

Note: The Generate Graphs? \ Secondary Axis parameter will display all CAS_RN and CHEMICAL_NAME values from the RT_MTH_ANL_GROUP_MEMBER table by design. Selecting one or more values for the Result \ Analyte \ Group(s) parameter will filter the available Secondary Axis values based on the selected Analyte Group(s).

 

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