Data Analysis with Excel

An Introduction for Physical Scientists
Erscheinungsjahr 2002
ISBN: 978-0-521-79737-5
Verlag: Cambridge University Press

Buch, Englisch, 464 Seiten, Format (B × H): 175 mm x 248 mm, Gewicht: 1016 g

Data analysis is of central importance in the education of scientists. This book offers a compact and readable introduction to techniques relevant to physical science students. The material is thoroughly integrated with the popular and powerful spreadsheet package Excel by Microsoft. Excel features of most relevance to the analysis of experimental data in the physical sciences are dealt with in some detail. Fully worked problems reinforce basic principles. Underlying assumptions and range of applicability of techniques are discussed, though detailed derivations of basic equations are mostly avoided or confined to the appendices. Exercises and answers are included at the end of chapters. Further relevant topics are included in online support for the book. Data Analysis with Excel is suitable for undergraduate students in the physical sciences. It will also appeal to graduate students and researchers needing an introduction to statistical techniques and the use of spreadsheets in data analysis.

Autoren/Hrsg.

Kirkup, Les

Fachgebiete

• Naturwissenschaften Chemie Chemie Allgemein Toxikologie, Gefahrstoffe, Sicherheit in der Chemie
• Naturwissenschaften Chemie Chemie Allgemein Pharmazeutische Chemie, Medizinische Chemie
• Naturwissenschaften Chemie Chemie Allgemein Chemometrik, Chemoinformatik
• Naturwissenschaften Chemie Chemie Allgemein Chemische Labormethoden, Stöchiometrie
• Naturwissenschaften Physik Physik Allgemein Geschichte der Physik
• Naturwissenschaften Physik Physik Allgemein Experimentalphysik
• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel
• Naturwissenschaften Physik Physik Allgemein Theoretische Physik, Mathematische Physik, Computerphysik

Inhaltsverzeichnis

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.

Über Autor(innen)

Kirkup, Les
Les Kirkup is Associate Professor in the School of Physics and Advanced Materials, University of Technology, Sydney. A dedicated lecturer, many of his educational developments have focused on enhancing the laboratory experience of undergraduate students. In May 2011, he was awarded an Australian Learning and Teaching Council National Teaching Fellowship.