SPSS TableLooks – Quick Introduction

SPSS TableLooks are files that contain styling -colors, fonts, borders and more- for SPSS output tables. What can I (not) do with TableLooks? Applying TableLooks Creating TableLooks Developing TableLooks Issues with TableLooks Output Table Styled by TableLook Example Practice Data File This tutorial uses bank_clean.sav throughout. Part of its data view is shown below. Feel free to download these […]

SPSS Output – Basics, Tips & Tricks

SPSS Output Tables SPSS Output Charts SPSS Output to WORD SPSS Output to Excel SPSS Output Tricks Exporting SPSS output is usually easier and faster than copy-pasting SPSS Output Introduction In SPSS, we usually work from 3 windows. These are the data editor window ; the syntax editor window ; the output viewer window . Our previous tutorials discussed the data […]

SPSS OUTPUT MODIFY – Batch Edit Output Items

Boldface Absolute Correlations > 0.5 Set Decimal Places for Output Tables Transpose One or Many Output Tables Delete Selection of Output Items Set Font Sizes and Styling for Output Tables Set Exact Sizes for Charts All examples require SPSS version 22 or higher. We’ll use bank_clean.sav -screenshot below- throughout this entire tutorial. OUTPUT MODIFY – What and Why? OUTPUT MODIFY […]

SPSS Computes Wrong Week Numbers?

While working on data holding a record for each day, I wanted to create some graphs on week level. So I extracted the weeks with XDATE.WEEK but the week numbers returned by SPSS are nonsensical: every week starts on January 1 and most years end up with week 53 holding just 1 day. There’s different standards for week […]

SPSS Datasets

This tutorial explains what SPSS datasets are. For a practical tutorial on working with datasets, see SPSS Datasets Tutorial 1 – Basics. Right, now an SPSS dataset is SPSS data that only exists in your computer’s working memory (RAM). Changes you make to it are discarded unless it’s saved as a data file. SPSS Data File and Dataset […]

SPSS Transformation Commands

Summary SPSS transformation commands (or simply “transformations”) can be loosely defined as commands that are not immediately carried out when you run them. Instead, they are kept in mind by SPSS and executed only when necessary. The table below gives an overview of SPSS’ main tranformation commands. Main SPSS Tranformation Commands COMMAND NAME GOAL TYPICAL USAGE […]

SPSS Sampling Basics

Summary How to draw one or many samples from your data in SPSS? This tutorial demonstrates some simple ways for doing so. We’ll point out some tips, tricks and pitfalls along the way. Let’s get started and create some test data by running the syntax below. SPSS Syntax for Creating Test Data *Create test data with […]

SPSS RV Function

Basic Use COMPUTE v1 = RV.NORMAL(0,1). Summary In SPSS, RV is short for random variable. It draws random values from a given probability distribution.* The latter is specified as a period separated suffix as in RV.BERNOULLI(.5).RV is mostly but not necessarily used with COMPUTE. Random Sample (N = 10,000) from a Standard Normal Distribution SPSS Rv Examples A nice way to get […]

Sampling in SPSS

Sampling is at the very core of statistical tests: drawing conclusions on research populations based on (small) samples from those populations. Basically all statistical tests quietly assume that the data you’re analyzing are a simple random sample from your population. This assumption being ignored is the very reason why political polls are often widely off and research findings can’t be […]

SPSS Output Tricks

SPSS output usually looks terrible. However, it doesn’t have to: you can manually style your tables and charts in the output window. The styles you apply such as colors, borders and fonts can be saved as SPSS chart templates and SPSS table templates. These can easily be reapplied to future output. A little known trick -but a real life saver […]

SPSS – Opening Data with Syntax

There’s several ways to open SPSS data files. The right way, however, is by syntax. The way we typically do so in practice may differ somewhat from what you’re used to. But give it a shot. It keeps things nicely organized and this eventually saves time and effort. We’ll use employees.sav throughout. Creating a Project Folder […]

SPSS – Combining Data with Syntax and Output

SPSS Syntax, Data and Output The previous tutorials explored SPSS’ three main windows. These are SPSS Data Editor window ; SPSS Syntax Editor window ; SPSS output viewer window . Now that we have a basic understanding of what they’re for, let’s take a look at the big picture: the figure below proposes a typical flowchart for proceeding through a research […]

Five Reasons for Not Relying on the Journal File

Summary Some SPSS users argue that it’s not really necessary to work from syntax. If something goes wrong or a client doesn’t believe your results, you can always recover what you did from your journal file. However, the journal file is no reasonable substitute for syntax. This tutorial explains why. 1. Essential Modifications May be Missing Manual […]

SPSS Datetime Variables Tutorial

Introduction This tutorial shows how to work proficiently with SPSS datetime variables. You can follow along with it by downloading and opening hospital.sav. SPSS Main Datetime Functions This tutorial will cover the datetime functions outlined in the table below. Most of them apply to SPSS date variables and time variables as well because their values are stored in numbers of […]

SPSS RANGE Function – Quick Tutorial

COMPUTE v2 = RANGE(V1,2,4). SPSS RANGE Function Result Summary SPSS’ RANGE function is used to evaluate whether or not values are within a given range. Test values equal to the lower or upper boundary are also within the given range. Run the syntax below for a quick demonstration. SPSS Range Syntax Example *1. Create couple of cases. data list free/v1(f1). begin […]

SPSS VARSTOCASES With Labels Tool

Running VARSTOCASES is often necessary for generating nice charts in SPSS. One of the many examples is a stacked bar chart for comparing multiple variables. Sadly, we lose our variable labels when running VARSTOCASES and we really do need those. The solution is a simple tool that generates our VARSTOCASES for us and applies the variable labels of the input variables as value […]

SPSS – Merge Categories of Categorical Variable

Summary Merging some categories of a categorical variable in SPSS is not hard if you do it the right way. This tutorial demonstrates just that. We recommend you try the examples for yourself by downloading and opening hotel_evaluation.sav. Right, when doing a routine inspection of this data file, we’ll see that the variable nation has many small categories. This becomes apparent when […]

SPSS Scratch Variables

Definition Scratch variables are temporary helper variables that don’t show up in your data. A variable is a scratch variable if (and only if) its name starts with “#”. SPSS Scratch Variable – Introduction Say we have a data file holding phone numbers. Now we’d like to extract the area codes into a separate variable. […]

SPSS INSERT Command

Definition SPSS Insert is a command for running syntax files from within another syntax file. This may help keeping your syntax organized. SPSS Insert Command – Why Use It? Executing all of your commands from syntax may be the single best practice for working with SPSS. One of the reasons is that you can correct steps early […]

SPSS Python Examples

Learn Python for SPSS the right way by running some of the examples below. They show precisely how to get things done in SPSS the fastest way possible and are easily modified to suit your needs. Enjoy! Latest SPSS Python Examples Batch Process Files with Python Create Several Excel Files with Python Change Value Labels with Python SPSS with […]