Book contents
- Frontmatter
- Contents
- Preface to the second edition
- Preface to the first edition
- Chapter 1 Introduction to scientific data analysis
- Chapter 2 Excel and data analysis
- Chapter 3 Data distributions I
- Chapter 4 Data distributions II
- Chapter 5 Measurement, error and uncertainty
- Chapter 6 Least squares I
- Chapter 7 Least squares II
- Chapter 8 Non-linear least squares
- Chapter 9 Tests of significance
- Chapter 10 Data Analysis tools in Excel and the Analysis ToolPak
- Appendix 1 Statistical tables
- Appendix 2 Propagation of uncertainties
- Appendix 3 Least squares and the principle of maximum likelihood
- Appendix 4 Standard uncertainties in mean, intercept and slope
- Appendix 5 Introduction to matrices for least squares analysis
- Appendix 6 Useful formulae
- Answers to exercises and end of chapter problems
- References
- Index
Preface to the second edition
Published online by Cambridge University Press: 05 March 2012
- Frontmatter
- Contents
- Preface to the second edition
- Preface to the first edition
- Chapter 1 Introduction to scientific data analysis
- Chapter 2 Excel and data analysis
- Chapter 3 Data distributions I
- Chapter 4 Data distributions II
- Chapter 5 Measurement, error and uncertainty
- Chapter 6 Least squares I
- Chapter 7 Least squares II
- Chapter 8 Non-linear least squares
- Chapter 9 Tests of significance
- Chapter 10 Data Analysis tools in Excel and the Analysis ToolPak
- Appendix 1 Statistical tables
- Appendix 2 Propagation of uncertainties
- Appendix 3 Least squares and the principle of maximum likelihood
- Appendix 4 Standard uncertainties in mean, intercept and slope
- Appendix 5 Introduction to matrices for least squares analysis
- Appendix 6 Useful formulae
- Answers to exercises and end of chapter problems
- References
- Index
Summary
Preface to the second edition
I thank Cambridge University Press, and in particular Simon Capelin, for the opportunity to revisit Data Analysis with Excel. I have revised sections of the book to include topics of contemporary relevance to undergraduate students, particularly in the area of uncertainty in measurement. I hope the book will continue to assist in developing the quantitative skills of students destined to graduate in the physical sciences. There is little doubt that the demand for such skills will continue to grow in society in general and particularly within industry, research, education and commerce.
This edition builds on the first with a new chapter added and others undergoing major or minor modifications (for example, to remedy mistakes, update references or include more end of chapter exercises).
- Type
- Chapter
- Information
- Data Analysis for Physical ScientistsFeaturing Excel®, pp. xi - xiiPublisher: Cambridge University PressPrint publication year: 2012