Case B - Estimation of MU using data obtained on matrix CRM(s) in the frame of method verification

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 repeatability/reproducibility
       introduce your validation results (max 5 replicates x max 10 days) obtained analysing a reference material (RM);

2. calculate your bias
       introduce the reference value and associated expanded uncertainty (k=2) of the RM,
       the replicate results obtained on day 1 are used by default to calculate the bias;

3. estimate your MU
       introduce the average of the measurement results of your unknown sample,
       together with the number of replicates obtained on one or several days.


                                                                       *****


Note:
Microsoft does not allow 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.