Expansion of the EZSTATSG1 Microsoft Excel Tool for ANSI/ASB Standard 036 Method Validation by the Addition of Weighted Quadratic External Calibration Models Utilizing Five-, Six- or Seven-Point Curves

Abstract

Abstract The first generation of this Microsoft (MS) Excel (Redmond, WA, USA) tool for method validation, EZSTATSG1, was designed for methods utilizing only linear calibration curves requiring seven calibration levels, and quadratic calibration models were not supported. This significantly improved version, EZSTATSG2, includes all of the features of the original template such as weighted linear calibration models, bias and precision data, dilution integrity and ion suppression. New features in this version include flexible five-, six- or seven-point calibration curves; six weighted quadratic calibration models; standardized residuals by use of frequency plots overlaid with the normal distribution function along with five-number summary data and processed sample stability. The implementation of Visual Basic for Applications in Excel UserForms prevents accidental alteration of existing formulas and also ensures that pertinent cells are relocked every time a file is reopened. The quadratic models feature the 95% confidence intervals for checking the significance of the second-order term and are fully characterized by providing the equations for the axis of symmetry, directrix and coordinates for vertex and focus. Example data of α-hydroxymidazolam demonstrate that the quadratic calibration curves fit the data more adequately than the linear models for this method. This second-generation tool summarizes all of the validation parameters of a method for both linear and quadratic calibration models. Models with the lower average sum of relative errors and higher R2 values are color-coded green, indicating the likelihood of a better fitting model. Like the EZSTATSG1, the redesigned EZSTATSG2.xltm MS Excel self-actuating validation tool and a completed PDF example are available to the scientific community for download as supplementary data. Updates to the template can be found at www.EZSTATS4validation.com.