Spreadsheet plotting calibration curves

This tutorial should provide you the basics for other spreadsheet applications. You can write any formula that is in this book into an active cell, and insert appropriate data for calculations. And, obviously, we can perform a variety of data analyses. We can prepare plots and charts of the data, for example, a calibration curve of instrument response versus concentration, along with statistical information. We will illustrate this later in the chapter. 

Least-squares plots and coefficient of determination, pp. 102, 106 Using spreadsheets for plotting calibration curves, p. 107 Detection limits, p. 111 Statistics of sampling, p. 113... 

Using a spreadsheet, plot the emission readings for the standards against concentration and determine the concentration in the unknown solution from the calibration curve. From this, calculate the micrograms of solution in your unknown if it is water, and ppm or meq/L if it is serum (see footnote 1). 

Internal standard instrument. Add the same amount of hthium solution to your unknown as was added to your standard, and dilute to volume with water. Follow your instructor s directions for the operation of the instrument. The lithium emission tine is 670.8 nm. Prepare a calibration curve as above for the direct-reading instrument, but record the ratio of the Na/Li emission intensities. Determine the concentration of sodium in.the unknown solution and report micrograms of sodium in the unknown if it is water, and ppm or meq/L if it is serum (see footnote 1). Use a spreadsheet as described in Chapter 20 for the internal standard plot and calculation. 

Measure the retention times. For the aspirin chromatograms, also measure the areas. The peak areas may be obtained from the height times the width at half-height for each. Alternatively, the peaks may be cut out and weighed. Or the instrument may print out the integrated areas. Using a spreadsheet, plot a calibration curve of peak area against concentration. 

Using Spreadsheets for Plotting Calibration Curves (Section 3.18, Figure 3.9)... 

---