The Importance of Teaching Metrology for Chemistry Undergraduate Courses - Supplementary Material

The supplementary material is an Excel spreadsheets containing the statistical treatment of some examples. The tabs "Data", "Var_x" and Var_y" in the Excel file are to be used to perform regressions using the CCC Software as explained by its "User manual (for Release 1.3)" available at the INRIM site. The tabs "Cd Expl A5 QUAM OLS" and "Cd Expl A5 QUAM WLS" are spreadsheets with the OLS and WLS regressions to fit a straight line on the calibration curve data for Cd determination. These spreadsheets can be used to fit straight lines on other calibration curves. The following four tabs with names stating "CCC" have the results from CCC Software V. 1.3 for OLS or WLS rectilinear or parabole fit and some calculations in grey cells for the adapted Example A5 QUAM for Cd determination. The final four tabs have data to be pasted on the first three tabs of the file to use the CCC Software to fit the calibration curves of Cd or sulfur determinations.