Advanced Excel for Scientific Data Analysis

quot;Advanced Excel for Scientific Data Analysisquot; by Robert de Levie
Oxford University Press | 638 pages | English | 2004 | ISBN: 019517089X | File type: PDF | 27,3 mb
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 quot;errorquot; 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.
http://www.sharingmatrix.com/file/2369909/Advanced_Excel.rar
http://rapidshare.com/files/363314648/Advanced_Excel.rar
You can find more books in
No more mirrors, please!
Handbook of Psychodiagnostic Testing: Analysis of Personality in the Psychological Report (0)
Advanced Excel for Scientific Data Analysis(0)
Advanced Excel for Scientific Data Analysis(0)
The One #3 (of 10) (2011)(0)
The Bountiful Solar Greenhouse(0)
Astrobiology of Earth: The Emergence, Evolution and Future of Life on a Planet in Turmoil(0)
Einziger deutscher Flugzeugtraeger Graf Zeppelin(0)
The World That Made New Orleans: From Spanish Silver to Congo Square(0)
Putt Like a Pro(0)
High-Iron Mungbean Recipes For North India(0)
Sport for Development And Peace: Towards Achieving the Millennium Development Goals(0)
Web Analytics: An Hour a Day (0)
20 Holiday Craft Projects(0)
Adaptation to Climate Change: A Spatial Challenge(0)
Armored Car: A History Of American Wheeled Combat Vehicles(0)
Handbook of Psychodiagnostic Testing: Analysis of Personality in the Psychological Report (0)
Advanced Excel for Scientific Data Analysis(0)