Advanced Excel for Scientific Data Analysis

Valutazione media 4,38
( su 8 valutazioni fornite da Goodreads )
 
9780195370225: Advanced Excel for Scientific Data Analysis

Combining an easy-going style with an emphasis on practical applications, this greatly expanded second edition is remarkable in scope and coverage. As reviews of the first edition noted, the term "advanced" in the title is not used lightly. Less than a third of its 700+ pages are devoted to least squares analysis, yet the reader will learn about many aspects of this ubiquitous method that are seldom found together in one volume: multivariate and polynomial centering, the statistical uncertainty in uncertainty estimates, how to use the covariance, singular value decomposition, the pros and cons of weighted least squares, moving equidistant least squares, nonlinear least squares, and imprecision contours.

There are lucid chapters on Fourier transformation, convolution and deconvolution, and digital simulation of ordinary differential equations. A new chapter is devoted to some common but often only crudely used mathematical methods, such as numerical differentiation, Romberg integration, and cubic spline interpolation. Another new chapter shows how to use linear algebra on the spreadsheet with Volpi's extensive matrix toolbox of custom functions and macros. A third, newly added chapter describes how to set up the spreadsheet to make it less error-prone, and how to get superaccurate answers in Excel. The substantially enlarged chapter on writing functions and macros now has a set of MacroMorsels to illustrate specific points that otherwise might trip up novice programmers, and a detailed description of Excel's extensive debugging tools. All this is presented in an easily digestible format, illustrated with many examples from the literature, and supported by a large collection of open-access (i.e., fully transparent and user-modifiable) custom functions and macros.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

About the Author:


Robert de Levie earned his Ph.D. at the University of Amsterdam. He was a postdoctoral fellow with Paul Delahay at LSU in Baton Rouge LA for two years, and then for 34 years taught analytical chemistry and electrochemistry at Georgetown University in Washington DC. For ten of those years he was the US editor of the Journal of Electroanalytical Chemistry. Now an emeritus professor, he is associated with Bowdoin College.

Review:


"A very useful book that will help users familiar with Excel exploit its computational capacities to the fullest."--Journal of the American Chemical Society


Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

I migliori risultati di ricerca su AbeBooks

1.

Robert de Levie
Editore: Oxford University Press Inc (2008)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Quantità: > 20
Print on Demand
Da
Books2Anywhere
(Fairford, GLOS, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Oxford University Press Inc, 2008. PAP. Condizione libro: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice libro della libreria IQ-9780195370225

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 54,93
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 11,15
Da: Regno Unito a: Italia
Destinazione, tempi e costi

2.

Robert de Levie
Editore: Oxford University Press Inc (2008)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Quantità: > 20
Print on Demand
Da
Pbshop
(Wood Dale, IL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press Inc, 2008. PAP. Condizione libro: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Codice libro della libreria IQ-9780195370225

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 57,37
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 9,86
Da: U.S.A. a: Italia
Destinazione, tempi e costi

3.

Robert de Levie
Editore: Oxford University Press (2008)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 10
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press, 2008. Paperback. Condizione libro: New. Codice libro della libreria INGM9780195370225

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 56,93
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 12,00
Da: U.S.A. a: Italia
Destinazione, tempi e costi

4.

Robert De Levie
Editore: Oxford University Press Inc, United States (2008)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 10
Print on Demand
Da
The Book Depository
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Oxford University Press Inc, United States, 2008. Paperback. Condizione libro: New. 2nd Revised edition. Language: English . Brand New Book ***** Print on Demand *****.Excel is by far the most widely distributed data analysis software, but few users are aware of its full powers. This book takes off where most other 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, and readers can therefore use them as starting points for making their own, personalized data analysis tools. The second edition of Advanced Excel addresses two recent developments. First, the new version of Excel, introduced at the beginning of 2007, has many more columns (16,384) than the present version (256), making it a much better environment for matrix operations, a staple of advanced mathematical methods in science and engineering, and a natural for a wide spreadsheet. The second edition includes a chapter explaining and illustrating matrix algebra in Excel.The second recent development is one outside Microsoft.An Italian engineer, Leonardo Volpi, has developed software with which Excel calculations can be made much more precise. With this freely downloadable tool, which de Levie has already used quite extensively, Excel can be made into a highly precise instrument, not only for scientific data analysis, but also for statistics, something it has not been in the past. This edition includes a new chapter on numerical methods (mostly devoted to working with matrices) and a new chapter on spreadsheet reliability (with emphasis on using Volpi s high-precision tools). Codice libro della libreria APC9780195370225

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 70,12
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: Italia
Destinazione, tempi e costi

5.

Robert De Levie
Editore: Oxford University Press Inc, United States (2008)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 10
Print on Demand
Da
The Book Depository US
(London, Regno Unito)
Valutazione libreria
[?]

Descrizione libro Oxford University Press Inc, United States, 2008. Paperback. Condizione libro: New. 2nd Revised edition. Language: English . Brand New Book ***** Print on Demand *****. Excel is by far the most widely distributed data analysis software, but few users are aware of its full powers. This book takes off where most other 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, and readers can therefore use them as starting points for making their own, personalized data analysis tools. The second edition of Advanced Excel addresses two recent developments. First, the new version of Excel, introduced at the beginning of 2007, has many more columns (16,384) than the present version (256), making it a much better environment for matrix operations, a staple of advanced mathematical methods in science and engineering, and a natural for a wide spreadsheet. The second edition includes a chapter explaining and illustrating matrix algebra in Excel.The second recent development is one outside Microsoft.An Italian engineer, Leonardo Volpi, has developed software with which Excel calculations can be made much more precise. With this freely downloadable tool, which de Levie has already used quite extensively, Excel can be made into a highly precise instrument, not only for scientific data analysis, but also for statistics, something it has not been in the past. This edition includes a new chapter on numerical methods (mostly devoted to working with matrices) and a new chapter on spreadsheet reliability (with emphasis on using Volpi s high-precision tools). Codice libro della libreria APC9780195370225

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 70,55
Convertire valuta

Aggiungere al carrello

Spese di spedizione: GRATIS
Da: Regno Unito a: Italia
Destinazione, tempi e costi

6.

Robert de Levie
Editore: Oxford University Press (2017)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 2
Print on Demand
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press, 2017. Paperback. Condizione libro: New. This item is printed on demand. Codice libro della libreria P110195370228

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 55,87
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 17,14
Da: U.S.A. a: Italia
Destinazione, tempi e costi

7.

Robert de Levie
Editore: Oxford University Press (2008)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 1
Da
Ergodebooks
(RICHMOND, TX, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press, 2008. Paperback. Condizione libro: New. 2nd. Codice libro della libreria DADAX0195370228

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 67,83
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 12,00
Da: U.S.A. a: Italia
Destinazione, tempi e costi

8.

Robert de Levie
Editore: Oxford University Press
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 20
Da
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press. Paperback. Condizione libro: New. Paperback. 667 pages. Dimensions: 9.3in. x 6.1in. x 1.6in.Combining an easy-going style with an emphasis on practical applications, this greatly expanded second edition is remarkable in scope and coverage. As reviews of the first edition noted, the term advanced in the title is not used lightly. Less than a third of its 700 pages are devoted to least squares analysis, yet the reader will learn about many aspects of this ubiquitous method that are seldom found together in one volume: multivariate and polynomial centering, the statistical uncertainty in uncertainty estimates, how to use the covariance, singular value decomposition, the pros and cons of weighted least squares, moving equidistant least squares, nonlinear least squares, and imprecision contours. There are lucid chapters on Fourier transformation, convolution and deconvolution, and digital simulation of ordinary differential equations. A new chapter is devoted to some common but often only crudely used mathematical methods, such as numerical differentiation, Romberg integration, and cubic spline interpolation. Another new chapter shows how to use linear algebra on the spreadsheet with Volpis extensive matrix toolbox of custom functions and macros. A third, newly added chapter describes how to set up the spreadsheet to make it less error-prone, and how to get superaccurate answers in Excel. The substantially enlarged chapter on writing functions and macros now has a set of MacroMorsels to illustrate specific points that otherwise might trip up novice programmers, and a detailed description of Excels extensive debugging tools. All this is presented in an easily digestible format, illustrated with many examples from the literature, and supported by a large collection of open-access (i. e. , fully transparent and user-modifiable) custom functions and macros. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Codice libro della libreria 9780195370225

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 69,35
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 11,10
Da: U.S.A. a: Italia
Destinazione, tempi e costi

9.

Robert de Levie
Editore: Oxford University Press (2017)
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi Paperback Quantità: 13
Print on Demand
Da
Murray Media
(North Miami Beach, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press, 2017. Paperback. Condizione libro: New. This item is printed on demand. Codice libro della libreria 0195370228

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 67,71
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 17,14
Da: U.S.A. a: Italia
Destinazione, tempi e costi

10.

Levie, Robert de
Editore: Oxford University Press
ISBN 10: 0195370228 ISBN 13: 9780195370225
Nuovi PAPERBACK Quantità: 1
Da
Cloud 9 Books
(Wellington, FL, U.S.A.)
Valutazione libreria
[?]

Descrizione libro Oxford University Press. PAPERBACK. Condizione libro: New. 0195370228 New Condition. Codice libro della libreria NEW6.0077635

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 61,81
Convertire valuta

Aggiungere al carrello

Spese di spedizione: EUR 34,29
Da: U.S.A. a: Italia
Destinazione, tempi e costi

Vedi altre copie di questo libro

Vedi tutti i risultati per questo libro