Accessibility options:

# Data Management in SPSS resources

Show me all resources applicable to

### 02. Video Tutorials (19)

Change the coding of a variable using 'Recode into same variable' in SPSS
This video explains how to change the coding of a categorical variable in SPSS using the 'Recode into same variable' option. This replaces the existing data with the new coding rather than creating a new variable. This resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Vikki O'Neill, Queen's University Belfast.
Compute a mean score in SPSS
This video explains how to compute a new variable which is the mean of 2 or more variables combined. This resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Vikki O'Neill, Queen's University Belfast.
Compute a total score in SPSS
The video explains How to compute a new variable which is the sum of 2 or more variables combined. This sum is called a total score. This resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Vikki O'Neill, Queen's University Belfast.
Confidence Intervals and Error Bars in SPSS
A short video tutorial to demonstrate how to calculate confidence intervals and error bars using SPSS. This resource has been made available under a Creative Commons licence by Kristian Evans, Swansea University.
Create dummy variables from an existing categorical variable in SPSS
This video explains how to use SPSS to dummy code categorical variables. Often, this is required if you want to use the variable in regression, but it has more than 2 categories. This resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Vikki O'Neill, Queen's University Belfast.
Define the level of measurement of data in SPSS
In SPSS, data is either nominal, ordinal or scale. It's important that you know the difference between these options and choose the one that is best for your data. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Enter data and define variables in SPSS
A general overview of how to define variables and enter data into SPSS. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Enter data from a questionnaire, Example 1: Single response
Using SPSS, enter data from a questionnaire in which respondents had to choose one option (e.g., Gender, Age group, etc...). This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Enter data from a questionnaire, Example 2: Single response Likert scale questions
Using SPSS, enter data from a questionnaire in which respondents had to choose one option from a likert scale. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Enter data from a questionnaire, Example 3: Multiple response questions (tick all that apply)
Using SPSS, enter data from a questionnaire in which respondents can choose more than one option for a question. For example, 'tick all that apply'. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Enter data from a questionnaire, Example 4: Ranked response questions
Using SPSS, enter data from a questionnaire in which respondents rank a series of options. For example, 'rank in order or importance the following...'. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Enter data from a questionnaire, Example 5: Open response questions
Using SPSS, numerical data from an open response question on a questionnaire. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Import data from Excel into SPSS
How to import your excel data into SPSS as well as preparing your file to be imported. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Missing values in SPSS
Determine how to use SPSS to replace missing data with a code and then define it in the variable view. This "Getting started with SPSS" resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Kate Richards, MEI.
Recode a scale variable into categories in SPSS
This video shows how to create and define groups or bands for a scale variable in SPSS using 'recode into different variable'. This changes the level of measurement from scale to ordinal. This resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Vikki O'Neill, Queen's University Belfast.
Reduce the number of groups of a categorical variable in SPSS
This video explains how to reduce the number of groups of a categorical variable in SPSS using 'recode into different variables'. This resource is contributed to the statstutor Community project by Christine Pereira, Brunel University and reviewed by Vikki O'Neill, Queen's University Belfast.
Select a random sample of data or range of cases to analyse in SPSS
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.
Select specific cases to analyse in SPSS
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.
Use 'Split file' to analyse groups separately in SPSS
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.

### 03. Teach Yourself Worksheets (3)

How to Select a Subset of Cases for Analysis in SPSS (Worksheet)
This teach yourself worksheet explains the easiest way to use SPSS to undertake an analysis for a subset of cases, or separate analyses for a number of different subsets (subgroups) separately.
Opening Excel Data in SPSS and Creating Value Lables in SPSS (Workseet)
This teach yourself worksheet explains how to open an Excel worksheet as an SPSS dataset, and also how to add value labels to coded data in SPSS.
Recoding Variables in SPSS (Worksheet)
This teach yourself worksheet explains how to recode data or create codes for a new grouping variable in an SPSS data set.

### 07. Community Project (2)

7 SPSS (Workshop SOURCE)
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.
Chi-squared test SOURCE
A Quick Reference worksheet on the Chi-squared test for Two-Way Tables. This resource has been contributed to the statstutor Community Project by Mollie Gilchrist and Peter Samuels, Birmingham City under a Creative Commons licence CC-BY-SA and reviewed by Ellen Marshall, University of Sheffield. The zip file contains two data files, 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).
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).
The Statistics Tutor's Quick Guide to Commonly Used Statistical Tests
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).

### 09. Guides (2)

A Guide to SPSS
A Guide to SPSS for Information Science with tutorials funded by the Subject Centre for Information and Computer Sciences (Higher Education Academy) made available to statstutor by Prof Anne Morris, Loughborough University. This Guide is freely available for use (with acknowledgement) in non-commercial UK organisations.
Getting started with data handling in SPSS
This is one of four "Getting started with ..." developed by Cheryl Voake-Jones and Emma Cliffe from the Mathematics Resources Centre at the University of Bath covering data handling in SPSS. The resource includes an audio tutorial with transcript and associated files. These resources were developed with funding from sigma.

### 10. Workshops (1)

7 SPSS (Workshop)
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.

### 11. Quick reference worksheet (1)

Chi-squared test
A Quick Reference worksheet on the Chi-squared test for Two-Way Tables. The zip file contains the pdf worksheet and two Excel data files that accompany it. This resource has been contributed to the statstutor Community Project by Mollie Gilchrist and Peter Samuels, Birmingham City University and reviewed by Ellen Marshall, University of Sheffield. The zip file contains two associated data files.