How to Use Excel in Analytical Chemistry: And in General Scientific Data Analysis / Edition 1

How to Use Excel in Analytical Chemistry: And in General Scientific Data Analysis / Edition 1

by Robert de Levie
     
 

ISBN-10: 0521644844

ISBN-13: 9780521644846

Pub. Date: 02/05/2001

Publisher: Cambridge University Press

Spreadsheets provide one of the most easily learned routes to scientific computing. This book uses Excel®, the most powerful spreadsheet available, to explore and solve problems in general and chemical data analysis. It follows the usual sequence of college textbooks in analytical chemistry: statistics, chemical equilibria, pH calculations, titrations, and

Overview

Spreadsheets provide one of the most easily learned routes to scientific computing. This book uses Excel®, the most powerful spreadsheet available, to explore and solve problems in general and chemical data analysis. It follows the usual sequence of college textbooks in analytical chemistry: statistics, chemical equilibria, pH calculations, titrations, and instrumental methods such as chromatography, spectrometry, and electroanalysis. The text contains many examples of data analysis, and uses spreadsheets for numerical simulations and testing analytical procedures. It treats modern data analysis methods such as linear and nonlinear least squares in great detail, as well as methods based on Fourier transformation. It shows how matrix methods can be powerful tools in data analysis, and how easily these are implemented on a spreadsheet. It 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.

Product Details

ISBN-13:
9780521644846
Publisher:
Cambridge University Press
Publication date:
02/05/2001
Edition description:
New Edition
Pages:
502
Sales rank:
949,635
Product dimensions:
6.85(w) x 9.72(h) x 1.02(d)

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >