- View more resources from this publisher
Royal Statistical Society Centre for Statistical Education
Tooltip
These resources have been reviewed and selected by STEM Learning’s team of education specialists for factual accuracy and relevance to teaching STEM subjects in UK schools.
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.
Show health and safety information
Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.
Downloads
-
Chapter 7: using spreadsheets 408.7 KB
Show downloads
-
Chapter 7: using spreadsheets 408.7 KB
Information on the permitted use of this resource is covered by the Category Three Content section in STEM Learning’s Terms and conditions.
