Using electronic spreadsheets for different approaches of estimating uncertainty in electrometric pH measurements |
|---|
| Saowaluck Ukrisdawithid; Thanundorn Pithakkiet |
- Abstract:
- This paper explores uncertainty quantification in electrometric pH measurements using a Microsoft® Excel spreadsheet. The aim of this study is to simplify the process for analysts by providing a computational tool that calculates uncertainty based on pH calibration and measurement models. The provided layout allows immediate uncertainty calculation using the GUM, Kragten and Monte Carlo approaches. The GUM approach via partial derivatives confirms with relative uncertainty, while the Kragten approach evaluates the change in the result compared to the standard uncertainty, which reduces the risk of miscalculation. The Monte Carlo approach examines the distribution pattern of the input quantities to calculate the distribution of the result. The combination of these three approaches helps in developing effective strategies and understanding different aspects of the problem. The uncertainty calculator improves statistical management, improves the quality of laboratory results, saves computation time and reduces errors. It also has benefits for testing laboratories’ quality systems, improves PT activities and supports the development of reference laboratories.
- Download:
- IMEKO-TC8-11-24-2025-032.pdf
- DOI:
- 10.21014/tc11-2025.032
- Event details
- IMEKO TC:
- TC11
- Event name:
- IMEKO TC8, TC11 and TC24 Conference
- Title:
Joint conference of the TCs ‘Traceability in Metrology’ (IMEKO TC8), ‘Measurement in Testing, Inspection and Certification’ (IMEKO TC11), and ‘Chemical Measurements’ (IMEKO TC24).
- Place:
- Torino, ITALY
- Time:
- 14 September 2025 - 17 September 2025