Statistics and Chemometrics for Clinical Data Reporting, Part II: Using Excel for Computations - This column installment describes the statistical underpinnings related to computation and interpretati
FindAnalytichem Custom Search
About Search
 Home   Mass Spectrometry   ICP-MS   Infrared   FT-IR   UV-Vis   Raman   NMR   X-Ray   Fluorescence  
Make This Page Your Home Page!

Statistics and Chemometrics for Clinical Data Reporting, Part II: Using Excel for Computations
This column installment describes the statistical underpinnings related to computation and interpretation of chemometric methods and statistics for reporting clinical quantitative measurement methods. These chemometric and statistical methods describe the accuracy, precision, goodness of fit for linear regression, slope, bias, and percent coefficient of variation for a test method compared to a reference method for a single analyte determination. The Excel spreadsheet nomenclature is given for computation..


Spectroscopy


As described in the previous column (1), often there is confusion in multidisciplinary uses of statistical methods for analytical methods due to the variation in terminology, assumptions, and specific uses within different technical disciplines. Certain analytical methods of analysis are concerned only with overall error of analysis or correlation; others emphasize repeatability and reproducibility, and yet others report only bias and precision. Often, engineers look at total error analysis as tolerance stacking so that the sums of all errors in a specific dimension are less than the total maximum allowable tolerance.


Table I: Sample data
As noted in Part I of this column series, a unification of multiple disciplines into a reasonable set of statistical parameters remains useful for a broad presentation of clinical analytical data. A single set of statistical parameters is useful to a multidisciplinary team involved in looking at analytical method comparison.


Table II: Sample data in Excel format
This column describes the use of an Excel spreadsheet that computes and displays the statistical parameters described in Parts I and II of this series. For each parameter, the basic Excel computation nomenclature is described. The equations and terminology in this column are consistent with Clinical and Laboratory Standards Institute (CLSI) guidelines (2); please refer specifically to these guidelines referenced below for your own assessment. These statistical analyses evaluate the accuracy of a test method compared with a reference method measuring the same analyte.


Table III: Excel spreadsheet showing all calculations
Readers can refer to Part I of this column series for more detailed definitions of terms and to references 3–5 for additional descriptions and worked problems associated with the individual statistics demonstrated in this article. Note the data used for Parts I and II are shown in Tables I and II, and the entire Excel spreadsheet with computed results is shown in Table III. Also note the specific locations of data and calculations by rows and columns when referring to the Excel computation formulas.

Basic Definitions

A comparison of methods records differences between a test method and a comparative or reference method:

  • X: comparative or reference method
  • Y: test method
  • xi: observation i from comparative (reference) method
  • yi: observation i from test method
  • n: total number of observations i

For clarity, this column assumes the comparative (reference) method is a traceable reference method that has better precision than the test method, which can be achieved by averaging replicate reference measurements if necessary.

Measurement Error

The measurement error (ei) is the test method measurement minus the reference method

e = Test Measurement – Reference Method

or equivalently, using the CLSI definitions, the measurement error for the for the ith observation is

ei = yixi


Rate This Article
Your original vote has been tallied and is included in the ratings results.
View our top pages
Average rating for this page is: 4
Post a Comment
Your email address will NOT be published.
appears with your comment
read our privacy policy
Note: does not support HTML
All comments submitted are subject to review, and may be delayed before posting. We reserve the right not to post comments.
Headlines from LCGC North America and Chromatography Online
EdMass Top Down Sequencing of Intact Proteins and Monoclonal Antibodies - Bruker Apps Note
Direct Analysis of Complex Mixtures Using U-HPLC and High Resolution Mass Spectrometry
Fast and Effective Optimization of MRM Methods for LC/MS/MS Analysis of Peptides - LCGC Apps Note
Direct sales and service for Finland and Norway
Waters Accela Form - Fast and Effective Optimization of MRM Methods for LC/MS/MS Analysis of Peptides
Source: Spectroscopy,
Click here