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

Hardcover (Print)
Buy New
Buy New from BN.com
$237.50
Used and New from Other Sellers
Used and New from Other Sellers
from $112.41
Usually ships in 1-2 business days
(Save 55%)
Other sellers (Hardcover)
  • All (6) from $112.41   
  • New (2) from $214.39   
  • Used (4) from $112.41   

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.

Read More Show Less

Editorial Reviews

From the Publisher
"...smoothly written, excellent tutorial about how such spreadsheets are created...very good book. No analytical chemistry teacher, no serious analytical chemistry student, should fail to acquire this book." The Chemical Educator
Read More Show Less

Product Details

  • ISBN-13: 9780521642828
  • Publisher: Cambridge University Press
  • Publication date: 2/28/2001
  • Pages: 502
  • Product dimensions: 6.85 (w) x 9.72 (h) x 1.10 (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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)