Introduction to Frequency Tables and Contingency Tables resources
02. Video Tutorials (3)
Crosstab tables in SPSS
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.
Frequency Tables and Contingency Tables Part 1
This teach yourself unit explains how to tabulate and present categorical data in the form of frequency tables and contingency tables and motivates the need to consider row and column percentages which are considered in part 2. This resource was developed by John Flynn (previously of Lincoln University). statstutor also acknowledges permission by Dr Doug Stirling (Massey University) to use material from the CAST collection of e-books in Statistics.
Frequency Tables and Contingency Tables Part 2
This teach yourself unit considers how to interpret row and column percentages from contingency tables (see part 1). This resource was developed by John Flynn (previously of Lincoln University). statstutor also acknowledges permission by Dr Doug Stirling (Massey University) to use material from the CAST collection of e-books in Statistics.
07. Community Project (3)
3 Descriptive statistics (Workshop SOURCE)
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.
4 Excel Pivot tables (Workshop SOURCE)
This PowerPoint workshop is an introduction to Excel 2010, PivotTables and Excel functions. 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.
Pivot Tables in Excel SOURCE
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 (4)
Data for SPSS Workbook for New Statistics Tutors (Excel file)
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).
Introductory Statistics and Hypothesis Testing (PowerPoint Workshop)
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 for SPSS Workbook for New Statistics Tutors
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).
SPSS Workbook for New Statistics Tutors
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).
10. Workshops (2)
3 Descriptive statistics (Workshop)
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.
4 Excel Pivot tables (Workshop)
This PowerPoint workshop is an introduction to Excel 2010, PivotTables and Excel functions. 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 a data file for use in the workshop.
11. Quick reference worksheet (1)
Pivot Tables in Excel
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 and reviewed by Ellen Marshall, University of Sheffield.