Book contents
- Experimental Methods for Science and Engineering Students
- Reviews
- Experimental Methods for Science and Engineering Students
- Copyright page
- Dedication
- Contents
- Preface to the Second Edition
- Preface to the First Edition
- 1 Introduction to Experimentation
- 2 Characteristics of Experimental Data
- 3 Graphical Presentation of Data
- 4 Dealing with Uncertainties
- 5 Statistical Approach to Variability in Measurements
- 6 Fitting a Line to x–y Data Using the Method of Least Squares
- 7 Report Writing and Presentations
- 8 Using Excel to Present and Analyse Data
- 9 Computer-Aided Data Capture
- Book part
- Solutions to Exercises and Problems
- Further Reading
- References
- Index
8 - Using Excel to Present and Analyse Data
Published online by Cambridge University Press: 24 August 2019
- Experimental Methods for Science and Engineering Students
- Reviews
- Experimental Methods for Science and Engineering Students
- Copyright page
- Dedication
- Contents
- Preface to the Second Edition
- Preface to the First Edition
- 1 Introduction to Experimentation
- 2 Characteristics of Experimental Data
- 3 Graphical Presentation of Data
- 4 Dealing with Uncertainties
- 5 Statistical Approach to Variability in Measurements
- 6 Fitting a Line to x–y Data Using the Method of Least Squares
- 7 Report Writing and Presentations
- 8 Using Excel to Present and Analyse Data
- 9 Computer-Aided Data Capture
- Book part
- Solutions to Exercises and Problems
- Further Reading
- References
- Index
Summary
Pencil, paper and a scientific calculator are often adequate when analysing small amounts of data. However, spreadsheets are favoured especially when large amounts of data are involved. This chapter explores some of the basic features of spreadsheets and show how they may be applied to the analysis and presentation of experimental data. The Excel spreadsheet program by Microsoft is highlighted due to its availability, power, and longevity. Specific features of Excel are discussed such as the LINEST function for fitting equations, and the Analysis ToolPak which contains a number of useful analysis tools.
Keywords
- Type
- Chapter
- Information
- Experimental Methods for Science and Engineering StudentsAn Introduction to the Analysis and Presentation of Data, pp. 168 - 184Publisher: Cambridge University PressPrint publication year: 2019