Related Experiment Video
Updated: Jan 30, 2026

Continuous Hydrologic and Water Quality Monitoring of Vernal Ponds
Published on: November 13, 2017
Combining Spatial Analysis and a Drinking Water Quality Index to Evaluate Monitoring Data
Hongxing Li1, Charlotte D Smith2, Li Wang3
1National Center for Rural Water Supply Technical Guidance, Chinese Center for Disease Control and Prevention, Beijing 102200, China. lihx@ncrwstg.chinacdc.cn.
Abstract:
Drinking water monitoring is essential for identifying health-related risks, as well as for building foundations for management of safe drinking water supplies. However, statistical analyses of drinking water quality monitoring data are challenging because of non-normal (skewed distributions) and missing values. Therefore, a new method combining a water quality index (WQI) with spatial analysis is introduced in this paper to fill the gap between data collection and data analysis. Water constituent concentrations in different seasons and from different water sources were compared based on WQIs. To generate a WQI map covering all of the study areas, predicted WQI values were created for locations in the study area based on spatial interpolation from nearby observed values. The accuracy value of predicted and measured values of our method was 0.99, indicating good predication performance. Overall, the results of this study indicate that this method will help fill the gap between the collection of large amounts of drinking water data and data analysis for drinking water monitoring and process control.
More Related Videos
09:10Multimodal Analysis of Microplastics in Drinking Water using a Silicon Nanomembrane Analysis Pipeline
Published on: June 13, 2025
11:19Preparation and Testing of Impedance-based Fluidic Biochips with RTgill-W1 Cells for Rapid Evaluation of Drinking Water Samples for Toxicity
Published on: March 7, 2016
Related Concept Videos
Quality of Water
Testing Water Quality
Analysis of Population Pharmacokinetic Data
Overview of Microsoft Excel as a Data Analysis Tool
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...
Statistical Software for Data Analysis and Clinical Trials