Advanced Excel for Scientific Data Analysis

( 1 )

Overview


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 ...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (6) from $9.34   
  • New (3) from $103.07   
  • Used (3) from $9.34   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$103.07
Seller since 2008

Feedback rating:

(193)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0195152751 New. Looks like an interesting title!

Ships from: Naperville, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$215.00
Seller since 2014

Feedback rating:

(178)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$215.00
Seller since 2014

Feedback rating:

(178)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview


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.
Read More Show Less

Editorial Reviews

From the Publisher

"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

Read More Show Less

Product Details

  • ISBN-13: 9780195152753
  • Publisher: Oxford University Press, USA
  • Publication date: 8/28/2003
  • Edition description: New Edition
  • Pages: 638
  • Product dimensions: 9.10 (w) x 6.10 (h) x 1.30 (d)

Meet 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.

Read More Show Less

Table of Contents

1 Survey of Excel 1
2 Simple linear least squares 53
3 Further linear least squares 98
4 Nonlinear least squares 158
5 Fourier transformation 230
6 Convolution, deconvolution, and time-frequency analysis 280
7 Numerical integration of ordinary differential equations 339
8 Write your own macros 377
9 Macros for least squares & for the propagation of imprecision 423
10 Fourier transform macros 513
11 Miscellaneous macros 549
Appendix 599
Epilogue 608
Index 610
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

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
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted August 27, 2008

    VERY VERY HIGHLY RECOMMENDED!!

    Do you need a spreadsheet tool to analyze experimental data? If you do, then this book is for you! Author Robert De Levie, has written the second edition of an outstanding book on advanced Excel, that shows you how to conduct the numerical analysis of experimental data, such as are usually encountered in the physical sciences. De Levie, begins by describing some of the standard mathematical methods, such as numerical integration and differentiation, and how to perform these most accurately on the spreadsheet. Then, the author examines precision¿with random fluctuations and their reduction or removal. Next, he shows you how to apply the least squares methods to polynomials in the independent variable x, and to multivariable functions. The author continues by describing the nonlinear least squares method, where one compares a given data set with a model expression that depends on one or more numerical parameters. In addition, he also deals with the application of Fourier transformation in numerical data analysis, rather than instrumentation, where it is often built in. Then, the author discusses the use of time-dependent signals. He also describes particular types of errors: The algorithmic deviations caused by replacing a differential equation by an approximation thereof. Next, the author will show you how to copy spreadsheet data into a macro, manipulate them, and return the result to the spreadsheet. He continues by looking at some common mathematical operations, often encountered in scientific data analysis, and their numerical implementations on the spreadsheet. In addition, the author shows you how to extend the set of tools available for matrix operations in Excel. Finally, he focuses on three types of spreadsheet-related errors: those that are rather easy to make on a spreadsheet, those that result from Excel¿s adherence to the IEEE-754 protocol, and those that are in hidden in Excel. The author of this most excellent book has made a great effort to make it as broadly useful as possible to the reader, and to incorporate examples from different areas. More importantly, the author believes that this book offers instead, an attempt at the synthesis of different areas, thus illustrating how many numerical problems can be fitted comfortably in the convenient, user-friendly format of the spreasheet.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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