This supplement can be used in any analytical chemistry course. The exercises teaches you how to use Microsoft (R) Excel (R) using applications from statistics, data analysis equilibrium calculations, curve fitting, and more. Operations include everything from basic arithmetic and cell formatting to Solver, Goal Seek, and the Data Analysis Toolpak. The authors show you how to use a spreadsheet to construct log diagrams and to plot the results. Statistical data treatment includes descriptive statistics, linear regression, hypothesis testing, and analysis of variance. Tutorial exercises include nonlinear regression such as fitting the Van Deemter equation, fitting kinetics data, determining error coefficients in spectrophotometry, and calculating titration curves. Additional features include solving complex systems of equilibrium equations and advanced graphical methods: error bars, charts with insets, matrices and determinants, and much more.
Les mer
Includes exercises that teach you how to use Microsoft[registered] Excel[registered] using applications from statistics, data analysis equilibrium calculations and more. This book shows you how to use a spreadsheet to construct log diagrams and to plot the results. It includes advanced graphical methods: error bars, charts with insets, and more.
Les mer
1. Excel Basics. 2. Basic Statistical Analysis with Excel. 3. Statistical Tests with Excel. 4. Least-Squares and Calibration Methods. 5. Equilibrium, Activity and Solving Equations. 6. The Systematic Approach to Equilibria: Solving Many Equations. 7. Neutralization Titrations and Graphical Representations. 8. Polyfunctional Acids and Bases. 9. Complexometric and Precipitation Titrations. 10. Potentiometry and Redox Titrations. 11. Dynamic Electrochemistry. 12. Spectrochemical Methods. 13. Kinetic Methods. 14. Chromatography. 15. Electrophoresis and Other Separation Methods. 16. Data Processing with Excel.
Les mer
1. Excel Basics. 2. Basic Statistical Analysis with Excel. 3. Statistical Tests with Excel. 4. Least-Squares and Calibration Methods. 5. Equilibrium, Activity and Solving Equations. 6. The Systematic Approach to Equilibria: Solving Many Equations. 7. Neutralization Titrations and Graphical Representations. 8. Polyfunctional Acids and Bases. 9. Complexometric and Precipitation Titrations. 10. Potentiometry and Redox Titrations. 11. Dynamic Electrochemistry. 12. Spectrochemical Methods. 13. Kinetic Methods. 14. Chromatography. 15. Electrophoresis and Other Separation Methods. 16. Data Processing with Excel.
Les mer

Produktdetaljer

ISBN
9781285087955
Publisert
2013-01-17
Utgave
2. utgave
Utgiver
Vendor
Brooks/Cole
Vekt
776 gr
Høyde
275 mm
Bredde
218 mm
Dybde
20 mm
Aldersnivå
05, U
Språk
Product language
Engelsk
Format
Product format
Heftet
Antall sider
480

Biographical note

Stanley R. Crouch is professor emeritus at Michigan State University. He received his undergraduate and M.S. degrees from Stanford University and his Ph.D. in analytical chemistry from the University of Illinois. He is the recipient of the 2001 American Chemical Society Division of Analytical Chemistry Award in Chemical Instrumentation and the 1996 ACS Division of Analytical Chemistry Award for Excellence in Teaching. F. James Holler is professor emeritus of chemistry and is a recipient of the Alumni Association Great Teacher Award at the University of Kentucky. He received his Ph.D. from Michigan State University. In addition to his role as co-author of several bestselling texts, he is co-creator of the world-famous Periodic Table of Comic Books.