TY - BOOK AU - Kirkup,Les TI - Data analysis for physical scientists: featuring Excel SN - 9781139005258 (ebook) AV - Q180.55.S7 K57 2011 U1 - 502.85/554 23 PY - 2011/// CY - Cambridge PB - Cambridge University Press KW - Microsoft Excel (Computer file) KW - Research KW - Statistical methods KW - Data processing KW - Electronic spreadsheets N1 - Title from publisher's bibliographic system (viewed on 05 Oct 2015); Machine generated contents note: 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. Non-linear least squares; 9. Tests of significance; 10. Data analysis tools in Excel and the Analysis ToolPak; Appendixes; Answers to exercises and end-of-chapter problems; References; Index N2 - The ability to summarise data, compare models and apply computer-based analysis tools are vital skills necessary for studying and working in the physical sciences. This textbook supports undergraduate students as they develop and enhance these skills. Introducing data analysis techniques, this textbook pays particular attention to the internationally recognised guidelines for calculating and expressing measurement uncertainty. This new edition has been revised to incorporate Excel® 2010. It also provides a practical approach to fitting models to data using non-linear least squares, a powerful technique which can be applied to many types of model. Worked examples using actual experimental data help students understand how the calculations apply to real situations. Over 200 in-text exercises and end-of-chapter problems give students the opportunity to use the techniques themselves and gain confidence in applying them. Answers to the exercises and problems are given at the end of the book UR - https://doi.org/10.1017/CBO9781139005258 ER -