Simplified Analysis of Measurement Data from A Rapid E. coli qPCR Method (EPA Draft Method C) Using A Standardized Excel Workbook

Abstract

Draft method C is a standardized method for quantifying E. coli densities in recreational waters using quantitative polymerase chain reaction (qPCR). The method includes a Microsoft Excel workbook that automatically screens for poor-quality data using a set of previously proposed acceptance criteria, generates weighted linear regression (WLR) composite standard curves, and calculates E. coli target gene copies in test samples. We compared standard curve parameter values and test sample results calculated with the WLR model to those from a Bayesian master standard curve (MSC) model using data from a previous multi-lab study. The two models’ mean intercept and slope estimates from twenty labs’ standard curves were within each other’s 95% credible or confidence intervals for all labs. E. coli gene copy estimates of six water samples analyzed by eight labs were highly overlapping among labs when quantified with the WLR and MSC models. Finally, we compared multiple labs’ 2016–2018 composite curves, comprised of data from individual curves where acceptance criteria were not used, to their corresponding composite curves with passing acceptance criteria. Composite curves developed from passing individual curves had intercept and slope 95% confidence intervals that were often narrower than without screening and an analysis of covariance test was passed more often. The Excel workbook WLR calculation and acceptance criteria will help laboratories implement draft method C for recreational water analysis in an efficient, cost-effective, and reliable manner.