Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Applications of Microsoft® Excel in Analytical Chemistry 2nd Edition

F. James Holler, Stanley R. Crouch

  • Published
  • 480 Pages

Overview

This supplement can be used in any analytical chemistry course. The exercises teach students how to use Microsoft® Excel® 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 students 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.

F. James Holler, University of Kentucky

F. James Holler is professor emeritus of chemistry and 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.

Stanley R. Crouch, Michigan State University

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.
  • The description and instructions were completely changed from those of Excel 2003 to Excel 2010 (2007).
  • There is now a better coordination with Skoog, Fundamentals of Analytical Chemistry, 9e in terms of worked examples. The Spreadsheet examples, formerly in the Skoog book were off-loaded to the new Excel book so that the burden for teaching about Excel is now on the Excel book.
  • Precipitation titrations were included in Chapter 9.
  • Descriptions and instructions written so that they can be used with either the Office 2007 or 2010 versions of Excel.
  • Cross references to Skoog Fundamentals of Analytical Chemistry, 9e and Skoog, Analytical Chemistry: An Introduction are included.
  • 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.
  • Exercises teach students how to use Microsoft® Excel® with 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 students 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.
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.

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}
z

  • STARTING AT $16.99

  • ISBN-10: 1285686691
  • ISBN-13: 9781285686691
  • STARTING AT $21.49

  • ISBN-10: 128508795X
  • ISBN-13: 9781285087955
  • Bookstore Wholesale Price $18.75
  • RETAIL $24.95