Calibration 2 lecture

We continue our discussion of calibration curves- exploring how the Data Analysis toolbox in Microsoft Excel can be used to calculate the equation of the least squares line AND the analysis of variance (ANOVA) table for the regression line. We'll see how we can trick Excel into breaking up the SSresiduals in the ANOVA table created by the Regression tool into the SSLOF and SSerror using the One-Way ANOVA tool. Several data sets are used as examples (a set of Cd atomic absorption data and data from an HPLC analysis of naphthionic acid).

Calibration 2 mp3 podcast Right-click and select "save target as" if downloading manually.