Presenting and Summarising Data resources
02. Video Tutorials (14)

How to use SPSS to create a bar or line chart of means, including how to add error bars and confidence intervals. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Ellen Marshall, University of Sheffield. It was developed with sigma resource development funding.

How to use SPSS to create a clustered bar or line chart of means, including how to add error bars and confidence intervals. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Ellen Marshall, University of Sheffield. It was developed with sigma resource development funding.

How to use SPSS to compute z-scores for a variable. Choose one of two available methods. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Tim Sparks, Coventry University. It was developed with sigma resource development funding.

How to create a crosstab table in SPSS with 2 or more variables. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Tim Sparks, Coventry University. It was developed with sigma resource development funding.

How to use the SPSS chart editor to adjust the size, colours, labels, etc. on your chart. This example uses a clustered bar chart. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by David Bowers, Independent consultant in mathematics, statistics and learning development. It was developed with sigma resource development funding.

How to use the SPSS chart editor to adjust the size, colours, labels, etc. on your chart. This example uses a scatterplot. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by David Bowers, Independent consultant in mathematics, statistics and learning development. It was developed with sigma resource development funding.

How to use SPSS to create a grouped scatterplot and add separate trend lines for each group (a linear trend line is sometimes referred to as a regression line). This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Ellen Marshall, University of Sheffield. It was developed with sigma resource development funding.

How to interpret row, column and total percentages in a crosstabs table created in SPSS. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Tim Sparks, Coventry University. It was developed with sigma resource development funding.

How to use SPSS to create a bar or line chart of means with repeated measures data, including how to add error bars and confidence intervals. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Ellen Marshall, University of Sheffield. It was developed with sigma resource development funding.

How to use SPSS to create a clustered bar or line chart of means with one repeated measure, including how to add error bars and confidence intervals. It is not possible to create a clustered chart of means with two repeated measures using the chart builder in SPSS. However, you can create a line chart of means for two repeated measures by running a 2-way repeated measures ANOVA. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Ellen Marshall, University of Sheffield. It was developed with sigma resource development funding.

How to use SPSS to create a scatterplot and add a trend line (a linear trend line is sometimes referred to as a regression line). This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Ellen Marshall, University of Sheffield. It was developed with sigma resource development funding.

How to use SPSS to select a random sample of cases to analyse from your data set. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Alun Owen, University of Worcester. It was developed with sigma resource development funding.

How to use SPSS to select specific cases (i.e. rows of data) to analyse. This can be individual case selections or groups of cases (e.g. select all males/females, etc.). This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Alun Owen, University of Worcester. It was developed with sigma resource development funding.

How to use 'Split file' to analyse groups separately in SPSS. By using the Split file tool, SPSS will analyse groups of a categorical variable separately. E.g. split your file by gender to analyse males and females separately. This will not physically split your file - all your data stays in the same place. This resource from the "SPSS Tutorial Series" is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Tim Sparks, Coventry University. It was developed with sigma resource development funding.
04. Tests and Quizzes (1)

5 questions. 1. Choosing whether given random variables are qualitative or quantitative. 2. Deciding whether or not three sampling methods are simple random sampling, stratified sampling, systematic or judgemental sampling. Also whether or not the method of selection is random, quasi-random or non-random.3. Given a table of the number of days in which sales were between £x thousands and £(x+1) thousands find the relative percentage frequencies of these volume of sales.4. Given random set of data (between 13 and 23 numbers all less than 100), find their stem-and-leaf plot. 5. Given sample data find mean, standard deviation, median, interquartile range. Numbas resources have been made available under a Creative Commons licence by the School of Mathematics & Statistics at Newcastle University.
07. Community Project (8)

A PowerPoint workshop which covers some basic topics such as data types and the research study process. This has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains the source file and the associated statstutor metadata spreadsheet.

This PowerPoint workshop covers: types of data; tables; charts; measures of middle value; measures of spread; and choice of table, chart and measure. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains an associated Activities sheet, the source file and the associated statstutor metadata spreadsheet.

This PowerPoint workshop explains how to create pie charts, simple bar charts and scatter plots in Excel 2010. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains the source file and the associated statstutor metadata spreadsheet.

This PowerPoint workshop provides an introduction to SPSS. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains an associated data file, the source file and the associated statstutor metadata spreadsheet.

This PowerPoint workshop provides an introduction to parametric testing using SPSS. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains an associated data file, the source file and the associated statstutor metadata spreadsheet.

A Quick Reference worksheet on measures of middle value. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains the source file and the associated statstutor metadata spreadsheet.

A Quick Reference worksheet on measures of spread. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains the source file and the associated statstutor metadata spreadsheet.

A Quick Reference worksheet on creating PivotTables in Excel. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains the source file and the associated statstutor metadata spreadsheet.
08. Staff Resources (6)

Data sets for the self-study training resource for new statistics tutors entitled "SPSS Workbook for New Statistics Tutors". These were developed by Ellen Marshall (University of Sheffield) and reviewed by Jean Russell (University of Sheffield).

This is a paper-based scenario aimed to be used as part of the tutor training workshop using the resource entitled "Introductory Statistics and Hypothesis Testing". This was developed and contributed to the statstutor Community Project by Alun Owen (University of Worcester) and Ellen Marshall (University of Sheffield) and reviewed by Jean Russell (University of Sheffield).

These slides are aimed to be used in a workshop to train mathematics (or new statistics) tutors who need to provide statistics support. They cover key topics including hypothesis testing and choosing the right test. These slides were developed and contributed to the statstutor Community Project by Alun Owen (University of Worcester) and Ellen Marshall (University of Sheffield) and reviewed by Ruth Fairclough (University of Wolverhampton).

Solutions to the self-study training resource for new statistics tutors entitled "SPSS Workbook for New Statistics Tutors". These were developed and contributed to the statstutor Community Project by Ellen Marshall (University of Sheffield) and reviewed by Jean Russell (University of Sheffield).

This is a paper-based scenario aimed to be used as part of the tutor training workshop using the resource entitled "Introductory Statistics and Hypothesis Testing". This was developed and contributed to the statstutor Community Project by Alun Owen (University of Worcester) and Ellen Marshall (University of Sheffield) and reviewed by Jean Russell (University of Sheffield).

A handy quick guide to statistical tests and techniques for those providing statistics support. This covers when to use each technique along with the interpretation of results, checking assumptions and what to do if the assumptions are not met. This was developed by the MASH Centre at the University of Sheffield and contributed to the statstutor Community Project by Ellen Marshall (University of Sheffield) and Alun Owen (University of Worcester) and reviewed by Jean Russell and Nick Fieller, (University of Sheffield).
10. Workshops (5)

A PowerPoint workshop which covers some basic topics such as data types and the research study process. This has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield.

This PowerPoint workshop covers: types of data; tables; charts; measures of middle value; measures of spread; and choice of table, chart and measure. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield. It includes an Activities sheet.

This PowerPoint workshop explains how to create pie charts, simple bar charts and scatter plots in Excel 2010. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield.

This PowerPoint workshop provides an introduction to SPSS. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield. The zip file contains an associated data file.

This PowerPoint workshop provides an introduction to parametric testing using SPSS. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield. The zip file contains an associated data file.
11. Quick reference worksheet (2)

A Quick Reference worksheet on measures of middle value. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield.

A Quick Reference worksheet on measures of spread. This resource has been contributed to the statstutor Community Project by Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield.