Spreadsheet applications in chemistry using Microsoft Excel / Dermot Diamond and Venita C. A. Hanratty.
By: Diamond, Dermot
.
Contributor(s): Hanratty, Venita C. A.
Material type: 
BookPublisher: New York : Wiley, 1997Description: xii, 244 p. : ill. ; 24 cm.ISBN: 0471140872 .Subject(s): Microsoft Excel (Computer file) | Chemistry -- Statistical methods -- Data processing | Electronic spreadsheetsDDC classification: 542.8553 | Item type | Current library | Call number | Copy number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
| General Lending | MTU Bishopstown Library Lending | 542.8553 (Browse shelf(Opens below)) | 1 | Available | 00016412 |
Enhanced descriptions from Syndetics:
This book illustrates how EXCEL can be used to help scientists process, analyze, and present scientific data. EXCEL provides a flexible environment that can be used to prepare spreadsheet solutions for scientific data processing problems. It demonstrates step-by-step how to program EXCEL to perform appropriate tasks, automate repetitive data processing tasks, and prepare integrated documents by transferring data and graphics. It covers problems such as how to perform linear regression and use the built-in statistical tools of EXCEL, as well as addressing advanced topics such as graphing complex equations, model building and the use of VBA and macros for user interface. Though the examples emphasize chemical applications, the information provided will prove useful to all scientists.
"A Wiley-Interscience publication.".
Includes bibliographical references and index.
Introduction to excel -- Statistical functions and regression analysis -- Introduction to macros and VBA -- Case studies in quantum chemistry -- Case studies in physical chemistry -- Importing and processing instrumental data -- Processing experimental data using solver -- Case studies involving VBA.
Table of contents provided by Syndetics
- Introduction to Excel
- Statistical Functions and Regression Analysis
- Introduction to Macros and VBA
- Case Studies in Quantum Chemistry
- Case Studies in Physical Chemistry
- Importing and Processing Instrumental Data
- Processing Experimental Data Using Solver
- Case Studies Involving VBA
- Appendix
- Index
Reviews provided by Syndetics
CHOICE Review
Diamond and Hanratty have two main goals: to instruct the reader in the use of the Microsoft Excel spreadsheet program (chapters 1 and 3), and to show spreadsheet applications in chemistry (chapters 4 to 8). The accompanying computer disk contains spreadsheet files discussed in the text. The first three chapters quickly take the reader through the basics of Excel, focusing mainly on the scientific uses of a spreadsheet. Graphing, statistical methods, regression analysis, and the use of macros are presented. The case studies are drawn mostly from upper-division undergraduate course work in physical and analytical chemistry. Topics include quantum chemistry, kinetics, equilibria, titration methods, and importing experimental data from instrumental output. Detailed Excel instructions and some explanation of the underlying chemistry are provided for all the case studies. Recommended as an ancillary work for upper-division undergraduate or beginning graduate chemistry students. R. J. Shine; Ramapo College of New JerseyAuthor notes provided by Syndetics
Dermot Diamond, PhD, Senior Lecturer at the Dublin City University School of Chemical Sciences, is currently the Director of the DCU Biomedical and Environmental Sensor Technology (BEST) Centre.Venita C. A. Hanratty, PhD, has lectured at Trinity College Dublin and Dublin City University in physical chemistry and computer applications in chemistry. Currently, she is a software support specialist with Digital Equipment Ireland, Ltd.