Please use this identifier to cite or link to this item:
Title: A Monte Carlo approach for estimating measurement uncertainty using standard spreadsheet software
Authors: Chew, G.
Walczyk, T. 
Keywords: Measurement uncertainty
Monte Carlo
Issue Date: Mar-2012
Citation: Chew, G., Walczyk, T. (2012-03). A Monte Carlo approach for estimating measurement uncertainty using standard spreadsheet software. Analytical and Bioanalytical Chemistry 402 (7) : 2463-2469. ScholarBank@NUS Repository.
Abstract: Despite the importance of stating the measurement uncertainty in chemical analysis, concepts are still not widely applied by the broader scientific community. The Guide to the expression of uncertainty in measurement approves the use of both the partial derivative approach and the Monte Carlo approach. There are two limitations to the partial derivative approach. Firstly, it involves the computation of first-order derivatives of each component of the output quantity. This requires some mathematical skills and can be tedious if the mathematical model is complex. Secondly, it is not able to predict the probability distribution of the output quantity accurately if the input quantities are not normally distributed. Knowledge of the probability distribution is essential to determine the coverage interval. The Monte Carlo approach performs random sampling from probability distributions of the input quantities; hence, there is no need to compute first-order derivatives. In addition, it gives the probability density function of the output quantity as the end result, from which the coverage interval can be determined. Here we demonstrate how the Monte Carlo approach can be easily implemented to estimate measurement uncertainty using a standard spreadsheet software program such as Microsoft Excel. It is our aim to provide the analytical community with a tool to estimate measurement uncertainty using software that is already widely available and that is so simple to apply that it can even be used by students with basic computer skills and minimal mathematical knowledge. © 2012 Springer-Verlag.
Source Title: Analytical and Bioanalytical Chemistry
ISSN: 16182642
DOI: 10.1007/s00216-011-5698-4
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.


checked on Dec 7, 2018


checked on Nov 21, 2018

Page view(s)

checked on Nov 2, 2018

Google ScholarTM



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.