Abstract:Instrumental methods of analysis are used to define the price of goods, the compliance of products with a regulation, or the outcome of fundamental or applied research. These methods can only play their role properly if reported information is objective and their quality is fit for the intended use. If measurement results are reported with an adequately small measurement uncertainty both of these goals are achieved. The evaluation of the measurement uncertainty can be performed by the bottom-up approach, that involves a detailed description of the measurement process, or using a pragmatic top-down approach that quantify major uncertainty components from global performance data. The bottom-up approach is not so frequently used due to the need to master the quantification of individual components responsible for random and systematic effects that affect measurement results. This work presents a tutorial that can be easily used by non-experts in the accurate evaluation of the measurement uncertainty of instrumental methods of analysis calibrated using least-squares regressions. The tutorial includes the definition of the calibration interval, the assessments of instrumental response homoscedasticity, the definition of calibrators preparation procedure required for least-squares regression model application, the assessment of instrumental response linearity and the evaluation of measurement uncertainty. The developed measurement model is only applicable in calibration ranges where signal precision is constant. A MS-Excel file is made available to allow the easy application of the tutorial. This tool can be useful for cases where top-down approaches cannot produce results with adequately low measurement uncertainty. An example of the application of this tool to the determination of nitrate in water by ion chromatography is presented.

Design of integral spreadsheet calculator for engineering applications

Visual Interface Design of Hydrogenerator's Temperature Field Analysis Based on VB

Computer-aided calculating in data analysis of pharmaceutics with Microsoft Excel

Analysis of the application of various numerical integration methods and their practical implementation in MATLAB CAD

Introducing Excel spreadsheet calculations and numerical simulations with professional software into an undergraduate hydraulic engineering course

Design of Simulation Definite Integral Application learning Using Trapezoid Method based on VB.Net

A Proposed Numerical Integration Method Using Polynomial Interpolation

Open Source Implementations of Numerical Algorithms for Computing the Complete Elliptic Integral of the First Kind

An Electronic Teaching Assistant for Basic Operations Management Methods

Calculation of Integrals in MathPartner

Refining Calculus Pedagogy

Generalized Runge-Kutta Method with respect to the Non-Newtonian Calculus

A spreadsheet‐based tool for education of chemical process simulation and control fundamentals

Efficient Multiplicative Calculus-Based Iterative Scheme for Nonlinear Engineering Applications

Numerical Integration of Some Arbitrary Functions over an Ellipsoid by Discretizing into Hexahedral Elements for Biomaterial Studies

Software and Algorithmic Aspects of Automating Finite-element Discretization

Applying the significant-digit law to simplify grading of chemical engineering students design projects

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models

Spreadsheet for designing valid least-squares calibrations: A tutorial

Integral Calculus of One-Dimensional Functions: Personal Tasks and Samples

Application of Excel in Technology Design and the Equipment Calculation of Machines in Cotton Mill