22/12/2020
[Reference] S. Trapmann et al. doi:10.2760/738565, JRC120898 (https://europa.eu/!CM47Cf)
Instructions for Using the XLS Measurement Uncertainty (MU) Calculator
Follow the steps below to calculate your measurement uncertainty (MU):
0. Specification of your Measurement Unit relevant to your analysis;
1. Determination of your repeatability/intermediate-precision
introduce your validation results (max 5 replicates per day; up to 10 days) obtained analysing a reference material (RM);
2. Determination of the bias
introduce the reference value and associated expanded uncertainty (k=2) of the RM,
Use the replicate results from day 1 by default;
3. Estimatation of your MU
introduce the average measurement result for your unknown sample,
together with the number of replicates obtained on one or several days.
*****
Note:
Microsoft does not allow to 'copy & paste' cells into the online spreadsheet.
All values must be entered manually, one at a time, into the designated yellow cell ONLY.
Please note that your inputs will not be saved; the spreadsheet will be reset (clearing all values) each time you leave or refresh this page.
pihin007 (C) 2025
Disclaimer:
The information provided hereinis offered on an "as is" basis, without any warranty, express or implied, including, but not limited to, implied warranties of fitness for a particular purpose, accuracy, or error-free functionality. The user assumes all risks associated with the use, quality, and performance of this application. The owner of these tools shall not be held liable for any direct, indirect, incidental, consequential, direct, or other damages, including, but not limited to, data loss, loss of profits, or financial losses, arising from the use of, or inability to use, this application.
.