Automotive Holiday Deals Books Gift Guide Books Gift Guide Shop Men's Athletic Shoes Learn more nav_sap_SWP_6M_fly_beacon Train egg_2015 All-New Amazon Fire TV Grocery Gifts Under $50 Amazon Gift Card Offer cm15 cm15 cm15 $30 Off Amazon Echo $30 Off Fire HD 6 Kindle Cyber Monday Deals BestoftheYear Outdoor Deals on Tikes

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Advanced Excel for Scientific Data Analysis Corrected Edition

17 customer reviews
ISBN-13: 978-0195152753
ISBN-10: 0195152751
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
More Buying Choices
9 New from $60.10 25 Used from $6.99

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Get Up to 80% Back Rent Textbooks

Special Offers and Product Promotions

  • Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more | Shop now

Editorial Reviews


"This guide to Excel focuses on three areas-least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College."-SciTech Book News

About the Author

Robert de Levie is the author of more than 160 papers in analytical chemistry and electrochemistry, of an early Spreadsheet Workbook for Quantitative Chemical Analysis, McGraw-Hill, 1992; of a textbook on the Principles of Quantitative Chemical Analysis, McGraw-Hill 1997; of an Oxford Chemistry Primer on Aqueous Acid-Base Equilibria and Titrations, Oxford University Press, 1999; and most recently, of How to Use Excel in Analytical Chemistry, Cambridge University Press, 2001. He was born and raised in the Netherlands, earned his Ph.D. in physical chemistry at the University of Amsterdam, was a postdoctoral fellow with Paul Delahay in Baton Rouge, Louisiana, and for 34 years taught analytical chemistry and electrochemistry at Georgetown University. For ten of those years, he was the US editor of the Journal of Electroanalytical Chemistry. Now an emeritus professor, he lives on Orr's Island, and is associated with Bowdoin College in nearby Brunswick, Maine.

Hero Quick Promo
Holiday Deals in Kindle Books
Save up to 85% on more than 1,000 Kindle Books. These deals are valid until November 30, 2015. Learn more

Product Details

  • Paperback: 638 pages
  • Publisher: Oxford University Press; Corrected edition (January 15, 2004)
  • Language: English
  • ISBN-10: 0195152751
  • ISBN-13: 978-0195152753
  • Product Dimensions: 9.1 x 1.3 x 6.1 inches
  • Shipping Weight: 2 pounds
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (17 customer reviews)
  • Amazon Best Sellers Rank: #1,083,882 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

59 of 59 people found the following review helpful By johare on March 25, 2004
Format: Paperback
Advanced Excel does very well what it does, so your main concern is whether what it does interests you. The book is intended for engineers and scientists who do real computation, not intended for those making turnkey applications for businesses.
Three chapters describe the use of Excel for least squares fitting. Treatment is authoritative, including things like phantom relations, orthogonal polynomials, fitting to a Lorentzian, finding the derivative of data, and so forth. Although there is a lot of detail, it is well presented, and you will be able to follow without being an expert yourself. Less extensive but still detailed are chapters on Fourier analysis and on convolution and deconvolution. A brief introduction to numerical integration of ordinary differential equations is exactly that, introductory. Tons of references to other literature are provided.
So, if you have a specialized interest in these topics, this book is a must. What else is here?
Approximately the last half of the book is devoted to writing macros, and to a presentation of macros used in the first half of the book. The publisher maintains a web site where these can be downloaded, saving you the tedium and error of typing them into your computer from the book. The approach is to use message boxes to communicate with computation in VBA. VBA is used primarily as a programming language, and there is rather little about the Excel object model. You will learn very little about worksheet manipulation using VBA.
The reader with less interest in the applications, but an interest in applying Excel to their own problems, will also find a lot of interesting details here. The author knows a lot about Excel, and you will pick up not only the big picture, but also many useful details.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
35 of 35 people found the following review helpful By John Matlock on July 27, 2005
Format: Paperback
If I had written this book I think I would have called it Scientific Excel rather than Advanced Excel. To be sure, the book is certainly for advanced Excel users, but it won't help you do an advanced business application.

You'd best have some knowledge about Excel before starting this one. There's a brief survey of Excel at the beginning that starts off comparing a spreadsheet to an accountant's ledger. That's pretty basic. Anyone with any Excel experience at all can follow the first three pages. On page four he is talking about making a thousand point plot with random numbers, normal distribution -- no longer something from Excel for Dummies. By page 5 he's calculating averages and standard deviations. By the end of this Survey chapter he's talking about the accuracy of the calculations performed by Excel.

Subsequent chapters discuss various types of mathematical manipulation that are often needed in the analysis of scientific data.

There are three chapters on Least Squares. This is the fitting of a curve to collected data so that the trends might be more easily visualized.

There is a chapter on Fourier Transformations, which is the probably the most frequently used analysis tool when working in signal processing. Geophysical seismic data, radar receivers, cell phone systems are all processed primarily using Fourier Transforms. This kind of data is of course too voluminous for Excel, but the techniques used here would be ideal for quite a number of laboratory applications.

A couple of chapters cover convolution, deconvolution, and time-frequency analysis as well as Numerical integration of ordinary differential equations.

All of these processing tasks are done using macros.
Read more ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
33 of 34 people found the following review helpful By J. Tellinghuisen on January 6, 2005
Format: Paperback
This book by Robert de Levie is a thorough and comprehensive how-to guide to the use of the Excel program on common numerical tasks in physical science. It starts with a chapter that surveys the capabilities of the Excel program itself. It then continues with three chapters of progressively increasing sophistication on the method of least squares, followed by single chapters on Fourier transformation, convolution and deconvolution, and numerical solution of differential equations. The final four chapters are given over to the writing of macros and the author's presentation of the many macros he has developed in the course of solving the problems illustrated in the book. Readers should be aware that all of these macros, as well as the numerical data used in many of the examples, are also available in computer-readable form from the publisher's web site and, in fact, are available to purchasers and nonpurchasers alike.

I should acknowledge at the outset that I am very much NOT a fan of Excel. However, the program is by now so firmly established that there is little doubt of the value of the contents of this book to many in the intended audience of scientists and engineers. Moreover, there is also plenty of value for those of us who prefer to use computational tools other than Excel. Since my own primary interests relative to this book fall within the chapters on least-squares methods, that is where I will direct my specific comments.

As already noted, the book is about computations, not about theory, so although key working equations are often presented, they are seldom derived. Thus a beginner wanting to understand the method of least squares might want to consult another source to complement the "nuts and bolts" provided by the examples illustrated here.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Want to discover more products? Check out this page to see more: advanced excel