Advanced Excel for Scientific Data Analysis

Advanced Excel for Scientific Data Analysis

4.33 (9 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 4 business days
When will my order arrive?

Description

Excel is by far the most widely distributed data analysis software, but few users are aware of its full powers. This book takes off where most other books dealing with scientific applications of Excel end. It focuses on three areas: least squares, Fourier transformation, and digital simulation, and illustrates these with extensive examples, often taken from the literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. These macros and functions are provided in uncompiled, computer-readable, easily modifiable form, and readers can therefore use them as starting points for making their own, personalized data analysis tools. The second edition of Advanced Excel addresses two recent developments. First, the new version of Excel, introduced at the beginning of 2007, has many more columns (16,384) than the present version (256), making it a much better environment for matrix operations, a staple of advanced mathematical methods in science and engineering, and a natural for a wide spreadsheet. The second edition includes a chapter explaining and illustrating matrix algebra in Excel.The second recent development is one outside Microsoft.An Italian engineer, Leonardo Volpi, has developed software with which Excel calculations can be made much more precise. With this freely downloadable tool, which de Levie has already used quite extensively, Excel can be made into a highly precise instrument, not only for scientific data analysis, but also for statistics, something it has not been in the past. This edition includes a new chapter on numerical methods (mostly devoted to working with matrices) and a new chapter on spreadsheet reliability (with emphasis on using Volpi's high-precision tools).show more

Product details

  • Paperback | 730 pages
  • 154.94 x 236.22 x 40.64mm | 907.18g
  • Oxford University Press Inc
  • New York, United States
  • English
  • Revised
  • 2nd Revised edition
  • 250 lines
  • 0195370228
  • 9780195370225
  • 1,697,921

Review quote

"A very useful book that will help users familiar with Excel exploit its computational capacities to the fullest."--Journal of the American Chemical Societyshow more

About Robert De Levie

Robert de Levie earned his Ph.D. at the University of Amsterdam. He was a postdoctoral fellow with Paul Delahay at LSU in Baton Rouge LA for two years, and then for 34 years taught analytical chemistry and electrochemistry at Georgetown University in Washington DC. For ten of those years he was the US editor of the Journal of Electroanalytical Chemistry. Now an emeritus professor, he is associated with Bowdoin College.show more

Table of contents

1. Survey of Excel; 2. Simple linear least squares; 3. Further linear least squares; 4. Non-linear least squares; 5. Fourier transformation; 6. Convolution, deconvolution & time-frequency analysis; 7. Numerical integration of ordinary differential equations; 8. Write your own macros; 9. Some common mathematical operations; 10. Matrix operations; 11. Spreadsheet reliability; A. SOME ASPECTS OF EXCEL; B. SOME DETAILS OF MATRIX.XLA; C. MACROBUNDLES & MACROMORSELS; D. TRANSITIONING TO EXCEL 2007; INDEXshow more

Rating details

9 ratings
4.33 out of 5 stars
5 44% (4)
4 44% (4)
3 11% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X