SPSS chart templates are tiny text files that contain styling for charts. What are SPSS Chart Templates? Creating a Chart Template Applying Chart Templates Where do I Get Some Decent Chart Templates? Developing Your Own Chart Templates Practice Data File This tutorial walks you through creating and using chart templates. We’ll use bank.sav -partly shown below- throughout. […]
How to automatically transfer Save data from one sheet to another in excel Easily Record & Save data and transfer it to another sheet Learn how to auto save/record data entries in excel 2007 2010 2013 2016 without any formulas just using macro in excel transfer data from one excel worksheet to another automatically Record […]
One of the most common research questions is do different groups have different mean scores on some variable? This question is best answered in 3 steps: create a table showing mean scores per group -you’ll probably want to include the frequencies and standard deviations as well; create a chart showing mean scores per group; run some statistical test –ANOVA in this case. However, this […]
In some cases, ALTER TYPE in SPSS version 24 seems to report incorrect altered values when converting a string to a numeric value. This results in messed up data while SPSS reports that everything is fine. Let’s try and replicate the problem with the example below. Example We imported some .csv data in which some numeric values were flagged with an “a”. This indicates […]
SPSS OMS (short for Output Management System) can convert your output to SPSS datasets. As we’ll demonstrate in a minute, this can save you huge amounts of time, effort and frustration. We recommend you follow along by downloading and opening course_evaluation.sav, part of which is shown below. Today’s Challenge Some client wants to see charts holding correlations of […]
Summary SPSS table templates are files that tell SPSS how to style one, many or all tables that appear in the output viewer window. Some examples of such styling are the colors and sizes of fonts and borders. The figure below shows a DESCRIPTIVES table with and without a table template applied to it. Just like SPSS data […]
Summary Reading multiple sheet Excel workbooks into SPSS is easily done with this Custom Dialog. This tutorial demonstrates how to use it. Before You Start SPSS Read and Merge Excel Files Tool Make sure you have the SPSS Python Essentials installed. Download and install the xlrd module. If you’d like to generate some test data as done in […]
Question “I have an Excel workbook whose three sheets contain data values, variable labels and value labels. How can I apply the dictionary information from these last two sheets to the SPSS dataset after importing the data values?” Option A: Python A nice and clean option is to have Python read the dictionary information from the Excel sheets. The […]
xlrd is a module that allows Python to read data from Excel files. This tutorial explains where to get it and how to install it. Downloading the Python Xlrd Module The Python xlrd (short for “Excel Read”) module can be found here. After downloading it, you can extract the contents (twice) with 7 Zip. Copy the path of the folder that […]
A teacher held a course evaluation. The data in SPSS format are in course_evaluation.sav, part of which is shown below. Students from different majors participated and now the education director wants separate Excel files for each major. A super easy way for creating these is by using SPSS with Python. We’ll walk you through. 1. Save SPSS Data as […]
The right way for looping over tables, charts and other procedures in SPSS is with Python. We’ll show how to do so on some real world examples. We’ll use alcotest.sav throughout, part of which is shown below. Note that you need to have the SPSS Python Essentials properly installed for running these examples on your own computer. Example 1: Simple Loop over Bar […]
Summary By default, SPSS right pads string values with spaces up to the length of their containing string variables. You don’t usually see this but it may complicate concatenating strings. Such complications are avoided by trimming off trailing spaces using RTRIM (right trim). In Unicode mode, RTRIM is applied automatically but it’s fine to use it anyway. Results of steps 6 and 7 of the […]
An often requested feature is to export variable and value labels to Excel. This handy tool creates an SPSS Dataset containing these labels. It can either be be saved as an Excel sheet or further edited in SPSS. SPSS Create Dictionary Dataset Tool – How To Use Make sure you have the SPSS Python Essentials installed. Next, download and […]
This handy tool will set the exact sizes for one or many charts in the active output window. SPSS Set Chart Sizes Tool – How to Use it This tool requires SPSS version 18 or higher. For SPSS versions 14 through 17, you can use the syntax version from SPSS Set Chart Sizes with Syntax Tool. Before proceeding, […]
In SPSS, I don’t like to recode variables into new variables: the new variables don’t have any dictionary information such as variable/value labels or formats. Second, a recoded variable is appended to the end of the file but I rather have it in its original position. Both problems are avoided by recoding into the same variables. However, […]
6. Inconvenient Distributions (Overview and data file are are found here) Let’s first state this clearly: we don’t exclude variables simply because their distributions are not to our liking. What we mean by “inconvenient distributions” are variables that don’t really provide us with useful information. This point is perhaps best explained by an example. Let’s inspect q4. […]
Concatenating two or more strings is creating a new string consisting of the characters of the first string followed by the characters of the subsequent string(s) in their original order. SPSS CONCAT Function Concatenating in SPSS is done by the CONCAT function. The most basic usage is COMPUTE A = CONCAT(B,C,D). Note that you can concatenate only strings. For concatenating numbers, […]
Summary A previous tutorial covered assembling your own toolbar. This will become even more interesting if you add your own toolbar tools to it. This tutorial quickly walks you through and suggests some best practices. 1. Create a Folder with Syntax and Images Setting Up your SPSS Toolbar Tools Like so may Speed Things Up […]
Summary Toolbars can be very useful in SPSS. They allow users to do a lot of stuff with a single mouse click. However, some users may feel there’s some limitations to their default configuration. An ideal way to get around these is to assemble your own toolbar. Some limitations of standard toolbars Most users will […]
The table below lists all SPSS commands and the additional licenses -if any- you need for using them. This overview is based on SPSS version 22 but we hope to soon update it for version 24. Consult the notes section for some tips on using the table or downloading it as an SPSS (.sav) data file. Overview NAME TYPE OPTION […]
