Spreadsheet Applications in Chemistry Using Microsoft Excel [Paperback]

Dermot Diamond (Author), Venita C. A. Hanratty (Author)

Book Description

ISBN-10: 0471140872 | ISBN-13: 978-0471140870 | Publication Date: February 28, 1997 | Edition: 1

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.

Editorial Reviews

From the Publisher

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.

From the Back Cover

Everything you need to know about this emerging tool for scientific data processing

Spreadsheet packages -- once limited primarily to business applications-are emerging as invaluable tools for processing, analyzing, and presenting scientific data. Many spreadsheet programs now include built-in scientific and statistical tools, 3-D display options, and the capacity to nest dedicated scientific programs, enabling students, teachers, and scientists to process experimental data in a digital environment.

This book illustrates how EXCEL's flexible environment 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. While the examples used are primarily related to chemistry, the overall approach is useful in numerous disciplines, including physics, engineering, and biology. Supported by numerous illustrations, this book
* Covers statistical functions and regression analysis
* Includes advanced topics, such as digital filters, graphing complex equations, nonlinear curve fitting, and mathematical model building
* Discusses the use of VBA and macros for user interface customization and automation of repetitive tasks

See all Editorial Reviews

Product Details

• Paperback: 256 pages
• Publisher: Wiley-Interscience; 1 edition (February 28, 1997)
• Language: English
• ISBN-10: 0471140872
• ISBN-13: 978-0471140870
• Product Dimensions: 9.2 x 7.5 x 0.6 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Amazon Best Sellers Rank: #2,172,492 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.