Download Advanced Excel for Scientific Data Analysis, by Robert de Levie
In addition, we will certainly discuss you guide Advanced Excel For Scientific Data Analysis, By Robert De Levie in soft data kinds. It will certainly not disturb you making heavy of you bag. You require just computer device or device. The link that our company offer in this website is offered to click and after that download this Advanced Excel For Scientific Data Analysis, By Robert De Levie You understand, having soft file of a book Advanced Excel For Scientific Data Analysis, By Robert De Levie to be in your device can make alleviate the visitors. So this way, be a great viewers currently!
Advanced Excel for Scientific Data Analysis, by Robert de Levie
Download Advanced Excel for Scientific Data Analysis, by Robert de Levie
Advanced Excel For Scientific Data Analysis, By Robert De Levie. Thanks for visiting the very best internet site that available hundreds sort of book collections. Right here, we will certainly offer all publications Advanced Excel For Scientific Data Analysis, By Robert De Levie that you require. The books from famous writers as well as publishers are given. So, you can enjoy currently to obtain one at a time kind of book Advanced Excel For Scientific Data Analysis, By Robert De Levie that you will look. Well, pertaining to the book that you desire, is this Advanced Excel For Scientific Data Analysis, By Robert De Levie your option?
Why need to be Advanced Excel For Scientific Data Analysis, By Robert De Levie in this website? Get a lot more profits as just what we have informed you. You could discover the various other reduces besides the previous one. Alleviate of getting the book Advanced Excel For Scientific Data Analysis, By Robert De Levie as exactly what you really want is likewise offered. Why? We provide you several kinds of the books that will certainly not make you feel bored. You could download them in the web link that we offer. By downloading and install Advanced Excel For Scientific Data Analysis, By Robert De Levie, you have actually taken properly to choose the convenience one, as compared to the headache one.
The Advanced Excel For Scientific Data Analysis, By Robert De Levie tends to be great reading book that is understandable. This is why this book Advanced Excel For Scientific Data Analysis, By Robert De Levie comes to be a favored book to check out. Why don't you really want turned into one of them? You could enjoy checking out Advanced Excel For Scientific Data Analysis, By Robert De Levie while doing various other activities. The existence of the soft file of this book Advanced Excel For Scientific Data Analysis, By Robert De Levie is sort of getting experience conveniently. It consists of just how you should save guide Advanced Excel For Scientific Data Analysis, By Robert De Levie, not in racks of course. You could save it in your computer device and also gizmo.
By conserving Advanced Excel For Scientific Data Analysis, By Robert De Levie in the gadget, the way you review will likewise be much simpler. Open it as well as start checking out Advanced Excel For Scientific Data Analysis, By Robert De Levie, straightforward. This is reason we suggest this Advanced Excel For Scientific Data Analysis, By Robert De Levie in soft documents. It will not disturb your time to obtain the book. Furthermore, the on the internet heating and cooling unit will likewise reduce you to look Advanced Excel For Scientific Data Analysis, By Robert De Levie it, also without going someplace. If you have link net in your workplace, home, or gadget, you could download and install Advanced Excel For Scientific Data Analysis, By Robert De Levie it directly. You might not additionally wait to get the book Advanced Excel For Scientific Data Analysis, By Robert De Levie to send out by the vendor in various other days.
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.
- Sales Rank: #2232070 in Books
- Published on: 2004-01-15
- Original language: English
- Number of items: 1
- Dimensions: 6.10" h x 1.30" w x 9.10" l, .76 pounds
- Binding: Paperback
- 638 pages
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 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.
Most helpful customer reviews
60 of 60 people found the following review helpful.
Excellent for scientists and engineers
By johare
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. For example, how to call Solver from a macro. How to line your charts up with the spreadsheet grid. How to make the most of Excel's graphic abilities.
This book is NOT the typical Excel book full of screen shots and low on content. It teaches by example. By going through the examples presented, you really will learn how to use Excel for your application too.
35 of 35 people found the following review helpful.
Advanced Is Not Used Lightly in this Book's Title
By John Matlock
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. These are described in the book, or can be downloaded from the author's website -- [...] This web site also includes some additional macros that enhance Excel's computationability when handling numbers of higher precision.
The final four chapters of the book are on writing your own or modifying existing macros, with an orientation to scientific analysis.
I consider this to be almost a mandatory book for anyone interested in using Excel to analysis scientific data.
33 of 34 people found the following review helpful.
Scientific number-crunching with Excel
By J. Tellinghuisen
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.
Chapter 2 is devoted to the simplest of least-squares (LS) problems, unweighted fitting to a straight line (including one forced to go through the origin). This chapter also introduces the important topic of propagation of error (called propagation of imprecision by the author in an attempt to improve the terminology). A number of common applications are considered, the most important of which is probably the role of linear LS in calibration in analytical chemistry. This is, incidentally, an application where the common textbook expressions for error propagation lead to incorrect estimates of the imprecision; but de Levie "does it right."
Chapter 3 continues with linear LS, but now involving fitting to functions more complex than a straight line and often involving three or more adjustable parameters. (Note that the "linear" in linear LS refers to the manner in which the adjustable parameters occur in the fit function, not to the shape of the function itself; some authors refer to this as "multilinear.") The coverage begins with fitting to polynomials and is later extended to orthogonal polynomials. Toward the end of the chapter, weighted LS is introduced; this is needed to deal with the problem of transforming nonlinear fit relationships into linear ones, like exponentials (log transformation) and hyperbolic relationships (reciprocal transformation). Most of the examples in this chapter are from analytical and physical chemistry and are often encountered in the chemical teaching literature. These include the analysis of diatomic spectroscopic data (I2 and HCl), the analytical problem of estimating species abundances from UV-visible spectra of mixtures, and the treatment of enzyme kinetics data.
Chapter 4 turns to nonlinear LS, in which iterative methods are needed to obtain the solutions to the minimization problem at the heart of LS. The tool for accomplishing this task in Excel is the Solver routine. Solver has one glaring limitation, namely the failure to provide the statistical errors in the adjustable parameters. De Levie has solved that problem with his own macro, SolverAid. The capabilities of these routines are illustrated on a number of examples, again mostly from the realm of analytical chemistry and spectroscopy. Among the more unusual examples are fits of titration data, of discontinuous functions, and of continuous functions taken piecewise. Toward the end are included some illustrations of the performance of Solver on some benchmark nonlinear fitting problems provided by NIST (National Institute for Science and Technology).
I have personally checked many of the examples illustrated in these three chapters using other methods, and I can vouch for their general validity. In a few cases there are errors, but many of these have been corrected by the author since the first printing of the book. Users should consult the publisher's web site for a listing of these.
In summary, this work will prove a valuable addition to the bookshelves of Excel-oriented "number-crunchers." For those who prefer programs other than Excel, the examples can still provide useful instruction. For this group, the Excel material is of no use but also no real impediment. For those who hope to learn both data analysis and Excel at the same time, from "scratch," I doubt that this book will fill the bill: You'll probably need to start with more elementary treatises in both areas. I must admit that my aversion to the Excel program itself and its heavy focus in this book is what prevents me from giving the book the maximum rating.
Advanced Excel for Scientific Data Analysis, by Robert de Levie PDF
Advanced Excel for Scientific Data Analysis, by Robert de Levie EPub
Advanced Excel for Scientific Data Analysis, by Robert de Levie Doc
Advanced Excel for Scientific Data Analysis, by Robert de Levie iBooks
Advanced Excel for Scientific Data Analysis, by Robert de Levie rtf
Advanced Excel for Scientific Data Analysis, by Robert de Levie Mobipocket
Advanced Excel for Scientific Data Analysis, by Robert de Levie Kindle
Tidak ada komentar:
Posting Komentar