Statistics: Samples, Statistics and Exceedances of Each Location

<< Click to Display Table of Contents >>

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

Statistics: Samples, Statistics and Exceedances of Each Location

Report Name: Statistics - Samples, Statistics and Exceedances of Each Location (example)

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

Dependencies: saved (Beta) Analytical Results or Analytical Results report

Software: EQuIS Professional and EQuIS Enterprise

Source: EQuIS Professional install

Language: English

Output Type: Excel1

 

Description: In past versions of EQuIS, this report was titled Statistics: Analyte by Sample Transpose. The report lists sample values and calculates the statistics, such as the Number of Samples, the Number of Detects, Maximum, Mean, 95% UCL, and Minimum and Standard Deviation based on a saved Analytical Results Report. The report can also report action level exceedances, if the Action Level input is selected.

 

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

 

Overview:

If a sample value or a statistical value (Max and Mean) is greater than an action level value, the value is colored. Each Excel worksheet holds the results of a location. A user selection of "Transpose results of each location" is provided to transpose the results.

 

The "Use non-detects" parameter is used to include or exclude non-detects in the output, and the list of the "Save Analytical Results Report" parameter includes pick reports from both Analytical Results and (Beta) Analytical Results.

 

Notes:

The saved Analytical Results Report used needs to meet the following requirements:

The output should contain only one matrix.

Method Analyte Groups (MAGs) must be used; do not select individual or no analytes.

The MAGs selected for the report must have the default_unit defined for all analytes.

 

Tables: All tables used by the Analytical Results or Analytical Results II reports in addition to DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, DT_ACTION_LEVEL_PARAMETER, DT_ALS, RT_ANALYTE, RT_MATRIX, RT_MATRIX, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, ST_REPORT, ST_USER_REPORT

 

Report Parameters

Saved Analytical Results Report

Select a saved Analytical Results user report.

Action Level(s)

Parameter for selecting action levels.

Transpose results of each location

Parameter for transposing results each location. Default: false

Use non-detects

Parameter to use non-detects. Default: true

 

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