How to Use Excel® in Analytical Chemistry - Levie, Robert de

. .

Résumé :
Advanced chemistry textbook on use of spreadsheets in analytical chemistry.

Biographie:
Robert de Levie was born in Amsterdam, where he also earned his PhD. After postdoctoral study with Paul Delahay he joined Georgetown University in Washington DC, where he taught analytical chemistry and electrochemistry for 34 years, before his recent move to Bowdoin College in Brunswick ME. For ten years he served as the US editor of the Journal of Electroanalytical chemistry.

Professor de Levie has published more than 130 research papers on various electrochemical topics, including the electrochemical response of porous and rough electrodes, the development of modern ac polarographic instrumentation, the measurement of adsorption of ions and molecules at the metal-solution interface, the properties of ion transport through lipid bilayer membranes, the physics and chemistry of electrochemical oscillations, the properties of condensed monolayer films at the metal-solution interface, and stochastic measurements.

He has also been interested in a more rational description of ionic equilibria, suitable for computer fitting of experimental data, and in the introduction of computer methods, such as spreadsheets, in the undergraduate curriculum. This interest has resulted in the development of quite general expressions for acid-base and redox titrations, and for the redox buffer strength. He has also written several books in this area.

Sommaire:
Because of their intuitive layout, extensive mathematical capabilities, and convenient graphics, spreadsheets provide an easy, straightforward route to scientific computing. This textbook for undergraduate and entry-level graduate chemistry and chemical engineering students uses Excel, the most powerful available spreadsheet, to explore and solve problems in general and chemical data analysis. This is the only up-to-date text on the use of spreadsheets in chemistry. The book discusses topics including statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. It contains many examples of data analysis, and uses spreadsheets for numerical simulations, and testing analytical procedures. It also treats modern data analysis methods such as linear and non-linear least squares in great detail, as well as methods based on Fourier transformation. The book shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet and describes in detail how to simulate chemical kinetics on a spreadsheet. It also introduces the reader to the use of VBA, the macro language of Microsoft Office, which lets the user import higher-level computer programs into the spreadsheet....