distributions.xls - this file plots two normal distributions and confidence intervals for any means, standard deviations, values of n, etc.
ttest1.xls - this Excel workbook contains several examples (from class) on using the t-test.
driving.xls - the class example (driving force plot) showing calculation of slope, standard errors, and confidence intervals (by "by hand" and using the built-in Excel regression analysis)
regress1.xls - this Excel workbook shows examples of calculating best fit lines and correlation coefficients for linear data.
ppt_titrate.xls - adapted from Harris, p. 171, this spreadsheet calculates a precipitation titration curve for AgI and AgBr (class example). It also demonstrates the the use of Excel for endpoint determination.
activity.xls - three example worksheets showing the effect of ionic strength on pH and solubility.
polyprotic.xls - three worksheets with many graphs. Includes calculation of the pH of weak acids, fractional composition and buffers.
ab_titration.xls - calculation and comparison of weak acid-strong base titrations (from Harris) and an example Gran Plot.
