ChemStat Report (27490)

<< Click to Display Table of Contents >>

ChemStat Report (27490)

Report Name: ChemStat Report (27490)


Report Type: Standard


Description: The Chemstat Report generates a table that presents a statistical analysis for the selected analytes. The report summarizes the entire dataset into a single table with the rows representing each analyte in the dataset, and the columns representing the summary statistics. It allows you to focus in on those analytes and use the spatial and temporal querying tools provided to understand what is going on. It does not show the report by location or by sample, but allows you to easily identify what analytes exceed the Limit Of Detect (LOD) and Action Levels, and the statistics associated with these exceedances. It uses the Analytical Results Report to get source data.


The statistics are only calculated if the criteria below are met.




5th Percentile

95% of the results are above LOD*


50% of results are above LOD


15% of results are above LOD

Standard Deviation

15% of results are above LOD

95th Percentile

5% of results are above LOD

*Limit Of Detect which can be selected as reporting_detection_limit, quantitation_limit, method_detection_limit or mag_reporting_detect_limit over the "Result>Reporting Limit" parameter.


1.In finding the minimum and maximum values, non-detects are treated as if they are at the detection limit. If it turns out that one of the non-detects is the minimum or maximum value, then a less-than sign < is inserted before the number.

2.The other statistics are calculated using the standard EQuIS procedure in which the detection limits are multiplied by the Non-Detect Multiplier in the event the measurement turns out to be a non-detect. Calculating the number of action level exceedances - in the event of non-detects, the detection limit is multiplied by the Non-Detect Multiplier and compared to the action level. This means that non-detects may be considered as exceedances if the product of the detection limit and the non-detect multiplier, are greater-than the action level.

3.The Chemstat Report has an input parameter called "Check the box to process all data for RV2". Check this box to include all REPORT_RESULT_VALUEs. Uncheck this box to include only detects (aka REPORT_RESULT_VALUE > REPORT_RESULT_LIMIT). Note that the RV2 column of the output is used to calculate the 5th and 95th percentile values.

4.Abnormal or no results in the output for an analyte can be:

a.n.d.: presents Not Determined when the number of detects for an analyte cannot be determined.

b.-: not applicable or no results

c.Select the 'Check the box to process all data for RV2': suggest to select or check the "Check the box to process all data for RV2" parameter so that the report will use all detects and non-detects values to calculate the 5th and 95th percentile values. Note that if the parameter is not checked, only the results greater than report_result_limit are used to calculate the 5th and 95th percentiles.



The Chemstat Report was modified to include the options below.

oTo report the location of the maximum report concentration

oTo report the location(s) of all the exceedances of the selected action level

A bug in the calculation of the minimum concentration was also fixed. (76757)


Report Dependencies: Analytical Results Report


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


Contact for a direct link.


Language: English


Input Parameters: A selection made to customize the output of a report.


A reporting_limit parameter has been added to the ChemStat Report (27490).


Input Parameters

Input Parameter Screenshot

Output Columns


Select Location(s)

Location Group


Location Type

Date Range




Analyte Groups





Sample Type

Sample Method


Start Depth

End Depth

Reportable Result Flags


Action Levels



Task Code

Non-Detect Multiplier



Process Multiple Non-Detect Limits of an Analyte at a Location





for more information.




Database Type: EQuIS Version 5.5+


Database Schema: Standard (no custom or add-on schemas required)


Database Version: EQuIS Version 5+


Data Requirements: The report will not export results where DT_SAMPLE.SYS_LOC_CODE or DT_TEST. ANALYSIS_LOCATION are null.


Report Requirements: Excel


Output Type: Excel


Example Output:




Revision History:


In EQuIS 7


1.When there is more than one analyte and the last analyte has one result, the last result or analyte of the Raw Data is missed in the Statistics worksheet. In addition, most of the statistic calculations of the analyte prior to the last, are not correct.

2.Another issue is when the last analyte has more than one result, the last row of the results is not used in calculating max or min. The two issues are fixed (139135). In addition, the Result/Unit parameter is marked as required (139072).

3.The report breaks with the error message "...incorrect..." if the value of the min_start_depth or max_end_depth parameter is not provided. The report is modified so that the results of the report are not filtered by dt_sample.start_depth or dt_sample.end_depth if the value of the min_start_depth or max_end_depth parameter is not provided. The issue is fixed (139074).

4.The message "Input string is not in the correct format." for 5th or 95th Percentile is replaced with "Select the 'Check the box to process all data for RV2' parameter to consider non-detects" (case 143095).

5.The number 4 above no longer exists because Syncfusion has corrected the bug in calculating percentile of the data with missing values that leads to number 4. With the Syncfusion bug fixed, if there are missing data in calculating percentile, the report simply provides '-'.