Chem 222 Excel Tutorial+Calib Curve

Kuwata Chemistry 222 Spring 2005 Analytical Chemistry Calibration Curve Handout I. Quick-and Dirty Excel Tutorial For those of you with little experience with Excel, I’ve provided some key techniques that should help you use the program both for problem sets and lab write-ups. Please come talk with me if you have questions about any of this material—I’ve come to love(!) Excel more and more throughout my career, and I’m always happy to help people exploit the program’s power. I also recommend you read Harris’ excellent discussions of Excel techniques. In particular, I recommend Sections 2-10 and 2-11 (pp. 38-42), the example on pp. 84-85, and Section 5-5 (pp. 92-93). Much of the power of Excel comes from the use of cell references. For example, say we wanted to plot the vapor pressure of water in Torr as a function of temperature in ºC. Let’s further say I want the plot to go from 10ºC to 30ºC, with points at every degree. (This could be useful in experiments in which we collect gases under water.) We are given the following empirical equation (called the “Antoine equation”): Blog P = A − T + C In this equation, P is the vapor pressure in atm, T is the temperature in K, and A, B, and C are constants. (In the temperature range of interest, A = 5.40221, B = 1838.675, and C = -31.737.) T, and on three The vapor pressure therefore depends on a continuously changing variable, constants. Excel is great at solving problems like this! ...