Related Experiment Video
Updated: May 25, 2026
10:22
Split Point Analysis and Uncertainty Quantification of Thermal-Optical Organic/Elemental Carbon Measurements
Published on: September 7, 2019
A Monte Carlo approach for estimating measurement uncertainty using standard spreadsheet software
1NUS Graduate School for Integrative Sciences and Engineering, National University of Singapore (NUS), Singapore, Singapore.
Analytical and Bioanalytical Chemistry
|January 31, 2012
Summary
The Monte Carlo approach simplifies estimating measurement uncertainty in chemical analysis. This method, easily implemented in spreadsheet software, offers a practical alternative to complex derivative calculations for determining coverage intervals.
Area of Science:
- Analytical Chemistry
- Metrology
- Scientific Computing
Background:
- Accurate reporting of measurement uncertainty is crucial in chemical analysis but not universally adopted.
- Traditional methods like the partial derivative approach have limitations, including mathematical complexity and inability to accurately predict non-normal distributions.
- Understanding probability distributions is essential for determining coverage intervals, a key aspect of uncertainty quantification.
Purpose of the Study:
- To demonstrate a simplified implementation of the Monte Carlo approach for estimating measurement uncertainty.
- To provide the analytical community with an accessible tool for uncertainty estimation using readily available spreadsheet software.
- To enable students and researchers with basic skills to apply advanced uncertainty quantification methods.
Main Methods:
- Utilized the Monte Carlo approach, which involves random sampling from input quantity probability distributions.
- Implemented the method using standard spreadsheet software (e.g., Microsoft Excel) for ease of access and application.
- Avoided the need for complex derivative calculations inherent in the partial derivative approach.
Main Results:
- The Monte Carlo approach successfully estimates measurement uncertainty without requiring complex mathematical derivations.
- The method provides the probability density function of the output quantity, facilitating accurate coverage interval determination.
- Spreadsheet implementation proved to be a user-friendly and effective way to apply the Monte Carlo method.
Conclusions:
- The Monte Carlo approach offers a practical and accessible method for estimating measurement uncertainty in chemical analysis.
- Spreadsheet software provides a viable platform for implementing the Monte Carlo method, lowering the barrier to entry for users.
- This approach empowers a broader scientific community, including students, to confidently quantify and report measurement uncertainty.
Related Concept Videos
03:37Uncertainty in Measurement: Accuracy and Precision
Scientists typically make repeated measurements of a quantity to ensure the quality of their findings and to evaluate both the precision and the accuracy of their results. Measurements are said to be precise if they yield very similar results when repeated in the same manner. A measurement is considered accurate if it yields a result that is very close to the true or the accepted value. Precise values agree with each other; accurate values agree with a true value.
00:59Propagation of Uncertainty from Random Error
An experiment often consists of more than a single step. In this case, measurements at each step give rise to uncertainty. Because the measurements occur in successive steps, the uncertainty in one step necessarily contributes to that in the subsequent step. As we perform statistical analysis on these types of experiments, we must learn to account for the propagation of uncertainty from one step to the next. The propagation of uncertainty depends on the type of arithmetic operation performed on...
00:59Uncertainty: Overview
In analytical chemistry, we often perform repetitive measurements to detect and minimize inaccuracies caused by both determinate and indeterminate errors. Despite the cares we take, the presence of random errors means that repeated measurements almost never have exactly the same magnitude. The collective difference between these measurements - observed values - and the estimated or expected value is called uncertainty. Uncertainty is conventionally written after the estimated or expected value.
02:46Uncertainty in Measurement: Reading Instruments
Counting is the type of measurement that is free from uncertainty, provided the number of objects being counted does not change during the process. Such measurements result in exact numbers. By counting the eggs in a carton, for instance, one can determine exactly how many eggs are there in the carton. Similarly, the numbers of defined quantities are also exact. For example, 1 foot is exactly 12 inches, 1 inch is exactly 2.54 centimeters, and 1 gram is exactly 0.001 kilograms. Quantities...
01:22Estimating Population Mean with Unknown Standard Deviation
In practice, we rarely know the population standard deviation. In the past, when the sample size was large, this did not present a problem to statisticians. They used the sample standard deviation s as an estimate for σ and proceeded as before to calculate a confidence interval with close enough results. However, statisticians ran into problems when the sample size was small. A small sample size caused inaccuracies in the confidence interval.
William S. Gosset (1876–1937) of the Guinness...
William S. Gosset (1876–1937) of the Guinness...
01:16Estimating Population Mean with Known Standard Deviation
To construct a confidence interval for a single unknown population mean μ, where the population standard deviation is known, we need sample mean as an estimate for μ and we need the margin of error. Here, the margin of error (EBM) is called the error bound for a population mean (abbreviated EBM). The sample mean is the point estimate of the unknown population mean μ.
The confidence interval estimate will have the form as follows:
(point estimate - error bound, point estimate + error bound)
The...
The confidence interval estimate will have the form as follows:
(point estimate - error bound, point estimate + error bound)
The...