Skip to content

Due to scheduled maintenance, online ordering, in regions where offered, will not be available on this site from 8:00 until 10:00 GMT on Sunday 24th March. We apologise for the inconvenience.

Cart

Your Cart

×

You have 0 items in your cart.

Register Sign in Wishlist
How to Use Excel® in Analytical Chemistry

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

£93.99

textbook
  • Date Published: February 2001
  • availability: In stock
  • format: Paperback
  • isbn: 9780521644846

£ 93.99
Paperback

Add to cart Add to wishlist

Other available formats:
Hardback, eBook


Request inspection copy

Lecturers may request a copy of this title for inspection

Description
Product filter button
Description
Contents
Resources
Courses
About the Authors
  • 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.

    • The only up-to-date text on the use of spreadsheets in chemistry
    • Two-colour throughout
    • Uses powerful method for fitting experimental titration curves and a graphic introduction to Fourier transformation
    • Suitable for the most up-to-date version of Excel, compatible with Excel 97 (PC), Excel 5 (Windows 3.1), Excel 95 (Windows 95) and Excel 98 (Mac)
    Read more

    Reviews & endorsements

    'It is a smoothly written, excellent tutorial about how such spreadsheets are created, and thus how you can create your own quite complex spreadsheets … a very good book. No analytical chemistry teacher, no serious analytical chemistry student, should fail to acquire this book.' Roy W. Clark, Chem. Educator

    '… this book is a welcome addition to my shelves. It is not for the fainthearted, with many complex calculations examined, but that is how it should be, for the complexity comes not from the way it is written, but from the subject matter tackled.' Pete Biggs, Chemistry and Industry

    '… the book has also made me reappraise the power of spreadsheets in allowing scientists to visualise complex numerical data. I would happily recommend it to those interested in applying mathematical methods to chemistry, but who perhaps lack full command of a programming language.' Chemistry in Britain

    'Spreadsheets are one of the most useful tools in scientific computing. The author has written a 'how to' book dealing with typical analytical chemistry calculations and using one of the most popular and widely available spreadsheet programs, Microsoft Excel. the range of topics covered is quite impressive and should meet the needs of most analytical chemists … It should also prove to be a valuable and useful supplement to courses in wet chemical or instrumental analysis.' Terrence A. Lee, Royal Society of Chemistry

    '… a welcome addition …'. Peter Biggs, Chemistry & Industry

    See more reviews

    Customer reviews

    Not yet reviewed

    Be the first to review

    Review was not posted due to profanity

    ×

    , create a review

    (If you're not , sign out)

    Please enter the right captcha value
    Please enter a star rating.
    Your review must be a minimum of 12 words.

    How do you rate this item?

    ×

    Product details

    • Date Published: February 2001
    • format: Paperback
    • isbn: 9780521644846
    • length: 502 pages
    • dimensions: 249 x 176 x 26 mm
    • weight: 1.017kg
    • contains: 143 b/w illus. 13 tables
    • availability: In stock
  • 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.

  • Resources for

    How to Use Excel® in Analytical Chemistry

    Robert de Levie

    Find resources associated with this title

    Type Name Unlocked * Format Size

    Showing of

    Back to top

    *This title has one or more locked files and access is given only to lecturers adopting the textbook for their class. We need to enforce this strictly so that solutions are not made available to students. To gain access to locked resources you either need first to sign in or register for an account.


    These resources are provided free of charge by Cambridge University Press with permission of the author of the corresponding work, but are subject to copyright. You are permitted to view, print and download these resources for your own personal use only, provided any copyright lines on the resources are not removed or altered in any way. Any other use, including but not limited to distribution of the resources in modified form, or via electronic or other media, is strictly prohibited unless you have permission from the author of the corresponding work and provided you give appropriate acknowledgement of the source.

    If you are having problems accessing these resources please email lecturers@cambridge.org

  • Instructors have used or reviewed this title for the following courses

    • Analytical Chemistry
    • General Chemistry ll
    • Instrumental Analysis
  • Author

    Robert de Levie, Bowdoin College, Maine

Sign In

Please sign in to access your account

Cancel

Not already registered? Create an account now. ×

Sorry, this resource is locked

Please register or sign in to request access. If you are having problems accessing these resources please email lecturers@cambridge.org

Register Sign in
Please note that this file is password protected. You will be asked to input your password on the next screen.

» Proceed

You are now leaving the Cambridge University Press website. Your eBook purchase and download will be completed by our partner www.ebooks.com. Please see the permission section of the www.ebooks.com catalogue page for details of the print & copy limits on our eBooks.

Continue ×

Continue ×

Continue ×

Find content that relates to you

Join us online

This site uses cookies to improve your experience. Read more Close

Are you sure you want to delete your account?

This cannot be undone.

Cancel

Thank you for your feedback which will help us improve our service.

If you requested a response, we will make sure to get back to you shortly.

×
Please fill in the required fields in your feedback submission.
×