22/12/2020
[Reference] S. Trapmann et al. doi:10.2760/738565, JRC120898 (LINK to the pdf file)
The XLS sheet below calculates your measurement uncertainty (MU).
You have to:
0. define/introduce your measurement "unit";
1. determine your uncertainty function
introduce 15 measurement results of the routine samples (6 low and 9 high contents) analysed twice;
2. calculate your bias
introduce up to 7 replicate measurement results of the reference material (RM),
introduce the reference value and associated expanded uncertainty (k=2) of the RM;
3. estimate your MU
introduce the measurement result value.
Note:
Microsoft does not allow to copy&paste cells into the online spreadsheet.
You have to type in all values one-by-one, in the yellow cell ONLY.
Your values will not be saved. The spreadsheet will be reset (= all introduced values deleted) each time you leave or refresh this page.