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.