<< Click to Display Table of Contents >> ChemStat Report (27490) 
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019 
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.
Statistic 
Criteria 

5th Percentile 
95% of the results are above LOD* 
Median 
50% of results are above LOD 
Mean 
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, nondetects are treated as if they are at the detection limit. If it turns out that one of the nondetects is the minimum or maximum value, then a lessthan 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 NonDetect Multiplier in the event the measurement turns out to be a nondetect. Calculating the number of action level exceedances  in the event of nondetects, the detection limit is multiplied by the NonDetect Multiplier and compared to the action level. This means that nondetects may be considered as exceedances if the product of the detection limit and the nondetect multiplier, are greaterthan 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 nondetects 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.
Notes: •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 support@earthsoft.com 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 



Contact for more information. 
Tables: DT_SAMPLE, DT_TEST, DT_RESULT, DT_LOCATION, RT_GROUP, RT_METH_ANL_GROUP, DT_ACTION_LEVEL, DT_ACTION_LEVEL_PARAMETER, RT_BASIN, DT_STATIC_PROPS
Database Type: EQuIS Version 5.5+
Database Schema: Standard (no custom or addon 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 nondetects" (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 ''.
EarthSoft.Reports.Library._27490.UserReport