Advanced Excel for Scientific Data Analysis
- ISBN-10
- 0195152751
- ISBN-13
- 9780195152753
- Category
- Analytical chemistry
- Pages
- 615
- Language
- English
- Published
- 2004
- Publisher
- Oxford University Press, USA
- Author
- Robert De Levie
Description
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.
Get the book
Other editions
Similar books
-
Spectrochemical Abstracts
By Ernest Horace Sebastian Van Someren, Frank Thomas BirksSpectrochemical Abstracts
-
Subsoil Monitoring at Nuclear Industry Enterprises: Foundations and Case Studies
By Mark Glinsky, Vladimir Vetrov, Alexander AbramovThe electric field intensity is 5–10 mV/m in the natural environment near the earth's surface. ... (Samsonov. 2010). Mechanical Impact Mechanical action is understood as a violation of the integrity of the geological array and ...
-
Analytical Chemistry and Quantitative Analysis
By David S. Hage, James D. CarrSideboxes allow for the discussion of other methods, including mass spectrometry and NMR spectroscopy, throughout the text.
-
Quantitative Analysis: Gravimetric, Volumetric and Instrumental Analysis
By Larry WilsonQuantitative Analysis: Gravimetric, Volumetric and Instrumental Analysis
-
Education and Teaching in Analytical Chemistry
By George Baiulescu, Constantin Pătroescu, Robert Alexander Chalmers[ 76 ] V. G. Berezkin and T. Yu . Chernysheva , J. Chromatog . , 1977 , 141 , 241 . [ 77 ] J. M. Petruzzi , Anal . Chem . , 1977 , 49,1217A . [ 78 ] Analyst , 1977 , 102 , 321 . [ 79 ] J. M. Petruzzi , Anal . Chem . , 1975 , 47,1277A .
-
Fundamentals of Analytical Chemistry
By Douglas A. Skoog, F. James Holler, Stanley R. CrouchFundamentals of Analytical Chemistry
-
Student Study Guide to Accompany Petrucci's General Chemistry, 3rd. Ed
By Robert K. WismerHow to Take Good Notes a There are several steps involved in producing a good notebook - one which will help you in your study of a subject . Although what follows is written for a chemistry lecture notebook , it can be adapted with ...
-
Modern Analytical Chemistry
By David HarveyModern Analytical Chemistry is a one-semester introductory text that meets the needs of all instructors.
-
Quantitative Analysis: Laboratory Manual
By Day, Arthur Louis Underwood, UnderwoodCan be packaged free with any copy of the text.
-
Advanced Environmental Analysis: Applications of Nanomaterials: Volume 1
By Chaudhery Mustansar Hussain, Boris KharisovRSC Detection Science Series Editor-in-Chief Professor Michael Thompson, University of Toronto, Canada Series Editors: ... and Advances 8: Biological Fluid-Surface Interactions in Detection and Medical Devices 9: Advanced Environmental ...