Cover image for How to use Excel in analytical chemistry and in general scientific data analysis
How to use Excel in analytical chemistry and in general scientific data analysis
De Levie, Robert.
Personal Author:
Publication Information:
Cambridge ; New York : Cambridge University Press, 2001.
Physical Description:
xiv, 487 pages : illustrations (some color) ; 26 cm
General Note:
Includes index.

Format :


Call Number
Material Type
Home Location
Item Holds
QD75.4.S8 D4 2001 Adult Non-Fiction Non-Fiction Area

On Order



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.

Reviews 1

Choice Review

Microsoft's Excel is a spreadsheet here for the duration. It has more power to calculate and analyze than most people, including this reviewer, will ever use. However, de Levie (Bowdoin College) goes into careful detail on every step, from making a simple graph to forward and inverse Fourier analysis of a time-dependent data set. There are an unfortunate number of misprints, often in formulae, and a few figures missing, but a careful reader will have no problem getting past these lacunae. This is not a textbook, but it would be a very useful supplement to any analytical chemistry text. The author covers most of the important quantitative applications of analytical chemistry and salts the text with statistical tests and statistical philosophy to delight the casual reader. Recommended to any student beginning a serious data analysis project. Undergraduates through professionals; two-year technical program students. D. H. Stedman University of Denver

Table of Contents

Part I Introduction to Using the Spreadsheet
1 How to use Excel
Part II Statistics and Related Methods
2 Introduction to statistics
3 More on least-squares
Part III Chemical Equilibria
4 Acids, bases, and salts
5 Other ionic equilibria
Part IV Instrumental Methods
6 Spectrometry, chromatography, and voltammetry
Part V Mathematical Methods
7 Fourier transformation
8 Standard mathematical tools
9 Numerical simulation of chemical kinetics
Part VI Spreadsheet Programming
10 Macros