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
Chapter 6 - Least squares I
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
Introduction
Establishing and understanding the relationship between quantities are principal goals in the physical sciences. As examples, we might be keen to know how the:
size of a crystal depends on the growth time of the crystal;
output intensity of a light emitting diode varies with the emission wavelength;
amount of light absorbed by a chemical species depends on the species concentration;
electrical power supplied by a solar cell varies with optical power incident on the cell;
viscosity of an engine oil depends upon the temperature of the oil;
rate of flow of a fluid through a hollow tube depends on the internal diameter of the tube.
Once an experiment is complete and the data presented in the form of an x–y graph, an examination of the data assists in answering important qualitative questions such as: Is there evidence of a clear trend in the data? If so, is that trend linear, and do any of the data conflict with the general trend? A qualitative analysis often suggests which quantitative methods of analysis to apply.
There are many situations in the physical sciences in which prior knowledge or experience suggests a relationship between measured quantities. Perhaps we are already aware of an equation which predicts how one quantity depends on another. Our goal in this situation might be to discover how well the equation can be made to ‘fit’ the data.
- Type
- Chapter
- Information
- Data Analysis for Physical ScientistsFeaturing Excel®, pp. 226 - 296Publisher: Cambridge University PressPrint publication year: 2012