- distributions.xls - plots two normal distributions and confidence intervals for any means, standard deviations, values of n, etc.
- ttest1.xls - several examples of using the t-test.
- driving.xls - shows calculation of slope, standard errors, and confidence intervals (by "by hand" and using the built-in Excel regression analysis)
- regress1.xls - shows examples of calculating best fit lines and correlation coefficients for linear data.
- ppt_titrate.xls - adapted from Harris, 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.