Restructuring Data in SPSS – Overview

SPSS offers several simple ways for restructuring data. VARSTOCASES -short for “variables to cases”- stacks variables on top of each other. Its reverse is CASESTOVARS -short for “cases to variables”. It basically stacks groups of cases behind each other in new variables. AGGREGATE adds summary statistics such as frequencies, sums and means to your data, optionally collapsing cases in the process. […]

SPSS Data Preparation 5 – Inspect Variables

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. […]