文档介绍：[Go back to CEM 333 Course Information Page][Go back to CEM 333 Home Page]
An Excel Spreadsheet Exercise*
Question Use the data in the table below to construct a spreadsheet showing the titration curve data, the first-derivative data and the second-derivative data. Plot each of these results versus titrant volume and determine the end point of the titration.
Volume AgNO3, mL
E vs. SCE, V
Answer We will first enter the data into the spreadsheet and construct an ordinary titration curve. Enter the data from the table above and use the Chart Wizard to plot the ordinary titration curve as shown in Figure 1. This plot is made as an XY(scatter) plot. Name the Workbook, and save it.
Figure 1.
Now we pute the first derivative. In order to make room for these to line up with the appropriate volumes let us copy the data (columns A and B from Figure 1) into a separate sheet, Sheet2, leaving the original data and plot in Sheet1. Now, in Sheet 2, insert blank rows between each pair of data points as shown in Figure 2. Label columns C, D, E, and F with "[Delta]E, V", "[D