The following data are similar to those given in Example
(a) Create a spreadsheet to calculate the standard electrode
potential for the Ag-AgCl electrode using the method described in Example 22-1.
Make columns for the activity coefficients and the standard potential.
Calculate g values for H1 and Cl– for each molality. Then find g6 at
each molality. Use the measured values of E to find E0 at each
(b) Compare your values for the activity coefficients and
standard potential with those of MacInnes, and if there are any differences
between your values and those in the table above, suggest possible reasons for
(c) Use the Descriptive Statistics function of Excel’s
Analysis Toolpak15 to find the mean, standard deviation, 95%
confidence interval, and other useful statistics for the standard potential of
the Ag-AgCl electrode.
(d) Comment on the results of your analysis and, in
particular, the quality of MacInnes’s results.