4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

Data Management and Manipulation with IBM SPSS Statistics (V21)


Course Description


Overview

Data Management and Manipulation with IBM SPSS Statistics is a two day course on the use of a wide range of transformation techniques, ways to automate data preparation work, manipulate data files and analytical results. Students will gain an understanding of the various options for controlling the IBM SPSS Statistics operating environment and how to use basic syntax to perform data transformations efficiently.

Audience

This intermediate course is intended for:
  • Anyone who has worked with IBM SPSS Statistics and wants to explore additional data management and manipulation features of IBM SPSS Statistics and generally increase their efficiency with IBM SPSS Statistics.
  • Anyone who has learned the basic operations of IBM SPSS Statistics on their own.

Prerequisites

You should complete:
  • "Introduction to IBM SPSS Statistics" course or experience with IBM SPSS Statistics (Version 15 or later) including familiarity with defining data, basic uses of Recode and Compute transformations, and creating charts.
You should have:
  • General computer literacy
No statistical background is necessary.

Key topics

Helpful Data Management Features
  • Read data using options available in the Database Wizard
  • Sort variables on any Attribute and customize the Variable View of attributes
  • Create and use Variable Sets
  • Generate variable attribute information for variables in a data file
  • Compare datasets
Transformations: Computing with Numeric Data
  • Use the Compute Variable dialog to create new variables and transform data
  • Use functions to perform transformations
  • Create and add additional variable Attributes
Transformations: Computing with Date and Time Variables
  • Learn how dates and times are represented in IBM SPSS Statistics
  • Create a date or time variable
  • Distinguish Date and Time functions in the Compute Variable dialog
  • Set default options for date variables with a 2-digit year
  • Use and understand the functionality of the Date and Time Wizard
Transformations: Computing with Alphanumeric Data
  • Use the Compute Variable dialog and string functions for transformations on alphanumeric variables
  • Use IBM SPSS Statistics syntax for string transformations
  • Describe character encoding for data and its use with string functions
Additional Data Transformations
  • Use Automatic Recode to easily recode string variables into numeric variables
  • Use the Count Values transformation to count values across variables
Identifying Duplicate Cases and Restructuring Data
  • Use the features of the IBM SPSS Statistics dialog Identify Duplicate Cases
  • Know when restructuring data is necessary
  • Use the features of the Restructure Data Wizard to restructure cases to variables
Aggregating Data
  • Describe the features of the Aggregate Data procedure
  • Create multiple summaries from one variable
  • Create a new data file with the aggregated results
  • Add the aggregated results to the original data file
Merging Files - Adding Cases
  • Describe and use the features of the Add Cases dialog
  • Set formats for variables so files can be added
  • Handle variables with different names in the files to be added
  • Check to see whether files were added successfully
Merging Files - Adding Variables
  • Describe the difference between a one-to-one and one-to-many match
  • Describe and use the features of the Add Variables dialog
  • Check to see whether files have been matched successfully
  • Merge data files without pre-sorting
Analyzing Multiple Response Questions
  • Define how multiple response questions are coded in a data file
  • Define multiple response sets in IBM SPSS Statistics
  • Use the Multiple Response Frequencies and Crosstabs procedure
Working with Charts
  • Use the features of the Chart Editor
  • Create and apply customized chart templates by modifying aspects of charts using options available within the Chart Editor
An Introduction to the Output Management System
  • Describe the capabilities of the Output Management System
  • Describe and use the features in the OMS Control Panel
  • Use the Output Management System to exclude items from the IBM SPSS Statistics Viewer
  • Use the Output Management System to export pivot tables to other applications
Automating IBM SPSS Statistics
  • Describe and use the features of the Syntax Editor
  • Make simple changes to syntax
  • Describe and use the features of the Production Facility dialog box
  • Run a simple production job
  • Describe the use of external programming languages with IBM SPSS Statistics
Controlling the IBM SPSS Statistics Environment
  • Describe the features of the Options Dialog
  • Reset the display of variables
  • Set the default working data folders
  • Change transformation options for variables

Objectives

Please refer to course overview for description information.

Course Duration

2 days
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form