Click to have a closer look
About this book
Presents methods of data analysis using the powerful spreadsheet package, Excel. Basic principles are reinforced using fully worked problems, and the underlying assumptions and range of applicability of techniques are discussed. Online support for the book covers further relevant topics.
Preface; 1. Introduction to scientific data analysis; 2. Excel and data analysis; 3. Data distributions I; 4. Data distributions II; 5. Measurement, error and uncertainty; 6. Least squares I; 7. Least squares II; 8. Tests of significance; 9. Data analysis tools in Excel and the Analysis ToolPak; Appendices; References; Index.
Handbook / Manual
Out of Print
446 pages, Figs, tabs
'This book is extremely well structured. It both describes the main functionality of Excel with special emphasis on scientific data analysis, as well as the statistical background to the methods ... definitely one of the best on the market in this important area ... the author should be congratulated on doing a wonderful job.' Chemistry & Industry Overall, I found the book excellent.' S. Middleton, The Physicist 'Any scientist familiar with Microsoft windows who has Excel(r) installed will find in this book a simple and straightforward introduction to the use of spreadsheet calculations and data display ... The coverage of this book will be more than adequate for undergraduate courses and will be sufficient for many postgraduate and research readers ... This book gives a good introduction to Excel(r) for data analysis for the first time user and covers the data analysis methods that most physical scientists will need. The book is a useful reference for those who already use Excel(r) and for those who may want to extend the data analysis methods that they use.' Contemporary Physics