Rules for Naming Variables in SPSS

This quick tutorial details the rules for naming variables in the SPSS statistics package. SPSS allows you to rename variables either via its Variable View or by using syntax. There are a number of rules governing the naming of variables. Rules & Best Practices for Naming Variables Names can be safely up to 32 characters … Read more

How to Rename a Dataset in SPSS

This quick tutorial will show you how to rename a dataset in the SPSS statistics package. Quick Steps In the SPSS Data View, click File, then Rename Dataset… Type the new dataset name into the dialog box, following SPSS’s naming conventions Click OK The Data The normal scenario for renaming a dataset is where you’re … Read more

How to Calculate the Median in SPSS

This quick tutorial will show how to calculate the median of a set of data in SPSS. Quick Steps Click Analyze -> Descriptive Statistics -> Frequencies Move the variable for which you wish to calculate the median into the right-hand column Click the Statistics button, select Median under Central Tendency, and then press Continue Click … Read more

Frequency Distribution in SPSS

This quick tutorial will show you how to generate a frequency distribution table and histogram within SPSS. Quick Steps Click on Analyze -> Descriptive Statistics -> Frequencies Move the variable of interest into the right-hand column Click on the Chart button, select Histograms, and the press the Continue button Click OK to generate a frequency … Read more

One Way ANOVA in SPSS Including Interpretation

In this tutorial we’ll look at how to perform a one-way analysis of variance (ANOVA) for independent groups in SPSS, and how to interpret the result using Tukey’s HSD. Quick Steps Click on Analyze -> Compare Means -> One-Way ANOVA Drag and drop your independent variable into the Factor box and dependent variable into the … Read more

Interpreting Chi Square Results in SPSS

This quick tutorial will show you how to interpret the result of a chi square calculation you have performed in SPSS. The Result The tutorial starts from the assumption that you have already calculated the chi square statistic for your data set, and you want to know how to interpret the result that SPSS has … Read more

Pearson Correlation Coefficient and Interpretation in SPSS

In this quick SPSS tutorial, we’ll look at how to calculate the Pearson correlation coefficient in SPSS, and how to interpret the result. Quick Steps Click on Analyze -> Correlate -> Bivariate Move the two variables you want to test over to the Variables box on the right Make sure Pearson is checked under Correlation … Read more

How to Recode String Variables in SPSS

In this quick tutorial, we’re going to look at how to recode a string variable as a numeric variable in the SPSS statistics program. This is often done using the automatic recode functionality of SPSS, but in this case we’re going to do it manually because of the extra control we get. Quick Steps Click … Read more

How to Select Cases in SPSS

In this tutorial, we’ll look at how to select cases in SPSS, and how to work with the resultant filtered data. The Data The data we’re using for this tutorial comes from a hypothetical study that examines how long it takes people to fall asleep during a statistics lesson. The two variables we’re interested in … Read more

Export Data from SPSS into a MySQL Database

In this tutorial, we’re going to see how to export data from SPSS into the MySQL database. If you want to follow along, you’re going to need the login details for your database, and also the IP address or domain name of the server on which it is hosted. The Data As you can see … Read more

How to Generate Random Numbers in SPSS

This tutorial will show you how to generate random numbers in SPSS and also outline a couple of use cases for such a procedure. The Data As a starting point, you should at least┬áhave an ID variable populated in the Data View of SPSS. The ID variable functions to identify the number of cases in … Read more

How to Move Columns in SPSS

This quick tutorial will show you how to reorder columns in the SPSS Data View. Quick Steps Select the entire column you want to move by click on its name at the top Drag the column to its new location The Problem In a previous tutorial, we created a new variable to hold a set … Read more

Create ID Number in SPSS

This quick tutorial will show you how to create a unique identifier for each case – i.e., each person, experimental subject, etc – within a data set in SPSS. The advantage of doing this is it disambiguates cases that might otherwise be confused – for example, if you had two John Smiths in your sample. … Read more

Paired Sample T Test in SPSS

This quick tutorial is designed to show how to do a paired samples t test in SPSS and how to interpret the result. A paired samples t test will sometimes be performed in the context of a pretest-posttest experimental design. For this tutorial, we’re going to use data from a hypothetical study looking at the … Read more

Independent Samples T Test in SPSS

This quick tutorial will show you how to do an independent samples t test in SPSS and how to interpret the result. Quick Steps Click on Analyze -> Compare Means -> Independent-Samples T Test Drag and drop the dependent variable into the Test Variable(s) box, and the grouping variable into the Grouping Variable box Click … Read more

Import Data from MySQL into SPSS

In this tutorial, we will learn how to import data from a MySQL database into the SPSS statistics package. Specifically, we will detail how to set up a MySQL data source and how to import data from it. To follow along, you’re going to need your database IP address, and the username and password you … Read more

How To Do Fisher Exact Test in SPSS

This quick tutorial will show you how to do Fisher’s exact test in SPSS. This test tends to be used when sample sizes are small, and you want to test whether two categorical variables (for example, gender and smoking status) are associated with each other. Quick Steps Click on Analyze -> Descriptive Statistics -> Crosstabs … Read more

How to Calculate Skewness and Kurtosis in SPSS

This quick tutorial will show you how to calculate the skewness and kurtosis of a distribution in the SPSS statistics package. Quick Steps Click on Analyze -> Descriptive Statistics -> Descriptives Drag and drop the variable for which you wish to calculate skewness and kurtosis into the box on the right Click on Options, and … Read more

How to Calculate Percentiles in SPSS

This quick tutorial will show you how to calculate percentiles in SPSS using the default HAVERAGE method. Quick Steps Click on Analyze -> Descriptive Statistics -> Frequencies Drag and drop the variable for which you wish to calculate the percentile(s) into the box on the right Click the Statistics button Select the Percentile(s) option, type … Read more