Advanced Excel for Scientific Data Analysis

4.33 avg rating
( 9 ratings by Goodreads )
 
9780195152753: Advanced Excel for Scientific Data Analysis
View all copies of this ISBN edition:
 
 

Excel is by far the most widely distributed data analysis software but few users are aware of its full powers. Advanced Excel For Scientific Data Analysis takes off from where most 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; readers can therefore use them as starting points for making their own personalized data analysis tools. Detailed descriptions and sample applications of standard and specialized uses of least squares for fitting data to a variety of functions, including resolving multi-component spectra; standard processes such as calibration curves and extrapolation; custom macros for general "error" propagation, standard deviations of Solver results, weighted or equidistant least squares, Gram-Schmidt orthogonalization, Fourier transformation, convolution and deconvolution, time-frequency analysis, and data mapping. There are also worked examples showing how to use centering, the covariance matrix, imprecision contours, and Wiener filtering and custom functions for bisections, Lagrange interpolation, Euler and Runge-Kutta integration.

"synopsis" may belong to another edition of this title.

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.

Review:


"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 this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

de Levie, Robert
Published by Oxford University Press (2004)
ISBN 10: 0195152751 ISBN 13: 9780195152753
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Oxford University Press, 2004. Paperback. Condition: New. Never used!. Seller Inventory # P110195152751

More information about this seller | Contact this seller

Buy New
US$ 43.28
Convert Currency

Add to Basket

Shipping: US$ 1.99
Within U.S.A.
Destination, Rates & Speeds

2.

de Levie, Robert
Published by Oxford University Press
ISBN 10: 0195152751 ISBN 13: 9780195152753
New PAPERBACK Quantity Available: 1
Seller:
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Oxford University Press. PAPERBACK. Condition: New. 0195152751 New Condition. Seller Inventory # NEW7.0975611

More information about this seller | Contact this seller

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

3.

de Levie, Robert
Published by Oxford University Press
ISBN 10: 0195152751 ISBN 13: 9780195152753
New Softcover Quantity Available: 1
Seller:
Ohmsoft LLC
(Lake Forest, IL, U.S.A.)
Rating
[?]

Book Description Oxford University Press. Condition: New. Paperback. Worldwide shipping. FREE fast shipping inside USA (express 2-3 day delivery also available). Tracking service included. Ships from United States of America. Seller Inventory # 0195152751

More information about this seller | Contact this seller

Buy New
US$ 68.24
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Robert de Levie
Published by Oxford University Press, USA (2004)
ISBN 10: 0195152751 ISBN 13: 9780195152753
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Oxford University Press, USA, 2004. Paperback. Condition: New. Corrected. Seller Inventory # DADAX0195152751

More information about this seller | Contact this seller

Buy New
US$ 64.81
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds

5.

Robert de Levie
Published by Oxford University Press (2004)
ISBN 10: 0195152751 ISBN 13: 9780195152753
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Oxford University Press, 2004. Condition: New. book. Seller Inventory # M0195152751

More information about this seller | Contact this seller

Buy New
US$ 84.15
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds