Advanced Excel for scientific data analysis, 3rd edition

9780984712304: Advanced Excel for scientific data analysis, 3rd edition

This greatly enlarged 3rd edition continues to exploit the convenience and transparency of the spreadsheet while enhancing its precision and accuracy. It teaches through detailed, fully worked-out examples, many taken from the literature, with extensive comments. This third edition contains *** New visualization tools, added emphasis on common computational pitfalls, and many new examples, plus an extensive set of directly applicable sample functions and macros for often-encountered data analysis problems, all open-access and freely available under the GNU General Public License. *** A collection of 125 additional matrix functions (increased from Excel's 5) including for eigenvalue and singular value problems of real and complex matrices, thanks to the work of Leonardo Volpi and coworkers. *** About 300 additional functions for calculating in extended precision, of up to over 32,000 decimals, covering all of Excel's Math & Trig, Statistical, and Engineering functions and many more, a project started by Leonardo Volpi and recently greatly enlarged by John Beyers. *** Still, you can use just as much power as you need. The included least squares macro xnLS operates as easily as its double-precision cousin LS, and only needs 35 decimals to ace all of the NIST StRD linear regression tests, decimal for decimal. *** All of these free, open-access add-ins retain the ease of use and transparency of the spreadsheet, and do not require you to write any VBA code. If you ever doubted the computational power and accuracy of Excel for scientific data analysis, read this book, try out its exercises, and judge for yourself. *** However, if you want to create VBA routines to solve your own problems, or wish to write special functions for your students or coworkers, extensive help is provided on how to write and validate these, and to make such custom add-ins fit seamlessly within Excel.

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

Compra nuovo Guarda l'articolo

Spese di spedizione: EUR 13,39
Da: U.S.A. a: Italia

Destinazione, tempi e costi

Aggiungere al carrello

I migliori risultati di ricerca su AbeBooks


Robert de Levie
Editore: Atlantic Academic LLC (2012)
ISBN 10: 0984712305 ISBN 13: 9780984712304
Nuovi Paperback Quantità: 1
Valutazione libreria

Descrizione libro Atlantic Academic LLC, 2012. Paperback. Condizione libro: New. Codice libro della libreria DADAX0984712305

Maggiori informazioni su questa libreria | Fare una domanda alla libreria

Compra nuovo
EUR 104,79
Convertire valuta

Aggiungere al carrello

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