Chapter 7 Using Spreadsheets
This chapter in the booklet Relevant and Engaging Statistics and Data Handling from the Royal Statistical Society Centre for Statistical Education (RSSCSE) addresses how spreadsheet software such as Excel is used to analyse and present data. However, it can appear very easy to analyse data and produce charts and diagrams in a spreadsheet, but very often the default ones produced are not the best ones, and some are even wrong. This chapter offers some dos and don’ts when using spreadsheet software, and goes through some worked examples that can help produce a correct statistic or graph.
HEALTH and SAFETY
Any use of a resource that includes a practical activity must include a risk assessment. Please note that collections may contain ARCHIVE resources, which were developed at a much earlier date. Since that time there have been significant changes in the rules and guidance affecting laboratory practical work. Further information is provided in our Health and Safety guidance.
More like this
The resource is part of Royal Statistical Society Centre for Statistical Education
- Relevant and Engaging Statistics
- Chapter 7 Using Spreadsheets