Book Image

Data Analysis with IBM SPSS Statistics

By : Ken Stehlik-Barry, Anthony Babinec

Book Image

Data Analysis with IBM SPSS Statistics

By: Ken Stehlik-Barry, Anthony Babinec

Overview of this book

SPSS Statistics is a software package used for logical batched and non-batched statistical analysis. Analytical tools such as SPSS can readily provide even a novice user with an overwhelming amount of information and a broad range of options for analyzing patterns in the data. The journey starts with installing and configuring SPSS Statistics for first use and exploring the data to understand its potential (as well as its limitations). Use the right statistical analysis technique such as regression, classification and more, and analyze your data in the best possible manner. Work with graphs and charts to visualize your findings. With this information in hand, the discovery of patterns within the data can be undertaken. Finally, the high level objective of developing predictive models that can be applied to other situations will be addressed. By the end of this book, you will have a firm understanding of the various statistical analysis techniques offered by SPSS Statistics, and be able to master its use for data analysis with ease.

Preface

What this book covers

What you need for this book

Who this book is for

Reader feedback

Customer support

Free Chapter

Installing and Configuring SPSS

Installing and Configuring SPSS

The SPSS installation utility

Launching and using SPSS

Setting parameters within the SPSS software

Executing a basic SPSS session

Accessing and Organizing Data

Accessing and Organizing Data

Accessing and organizing data overview

Reading Excel files

Reading delimited text data files

Saving IBM SPSS Statistics files

Reading IBM SPSS Statistics files

Demo - first look at the data - frequencies

Variable properties

Statistics for Individual Data Elements

Statistics for Individual Data Elements

Getting the sample data

Descriptive statistics for numeric fields

Discovering coding issues using frequencies

Explore procedure

Dealing with Missing Data and Outliers

Dealing with Missing Data and Outliers

Visually Exploring the Data

Visually Exploring the Data

Graphs available in SPSS procedures

Sampling, Subsetting, and Weighting

Sampling, Subsetting, and Weighting

Select cases dialog box

Selecting a random sample of cases

Creating New Data Elements

Creating New Data Elements

Transforming fields in SPSS

The RECODE command

The COMPUTE command

The DO IF/ELSE IF command

General points regarding SPSS transformation commands

Adding and Matching Files

Adding and Matching Files

SPSS Statistics commands to merge files

Example of one-to-many merge - Northwind database

One-to-one merge - two data subsets from GSS2016

Example of combining cases using ADD FILES

Aggregating and Restructuring Data

Aggregating and Restructuring Data

Using aggregation to add fields to a file

Aggregating up one level

Second level aggregation

Matching the aggregated file back to find specific records

Restructuring rows to columns

Crosstabulation Patterns for Categorical Data

Crosstabulation Patterns for Categorical Data

Percentages in crosstabs

Comparing Means and ANOVA

Comparing Means and ANOVA

SPSS procedures for comparing Means

Post hoc comparisons

Correlations

Pearson correlations

Listwise versus pairwise missing values

Pivoting table editing to enhance correlation matrices

Visualizing correlations with scatterplots

Rank order correlations

Partial correlations

Linear Regression

Linear Regression

Assumptions of the classical linear regression model

Example - motor trend car data

Multiple regression - Model-building strategies

Principal Components and Factor Analysis

Principal Components and Factor Analysis

Choosing between principal components analysis and factor analysis

PCA example - violent crimes

Factor analysis - abilities

Clustering

Overview of cluster analysis

Overview of SPSS Statistics cluster analysis procedures

Hierarchical cluster analysis example

K-means cluster analysis example

Twostep cluster analysis example

Discriminant Analysis

Discriminant Analysis

Descriptive discriminant analysis

Predictive discriminant analysis

Assumptions underlying discriminant analysis

Statistical and graphical summary of the data

Discriminant analysis setup - key decisions

Examining the results

Scoring new observations

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Matching the aggregated file back to find specific records

Another use of this file is to match it back to the invoice-level file to find the invoice corresponding to the customer's largest purchase during the time covered by this data. Starting with the invoice-level file as the active dataset, the following dialog box shows how to use the customer-level file as a lookup table to get the information associated with the largest invoice:

CustomerID serves as the match key in this one-to-many match. The * and + symbols indicate which file was the source for each of the variables in the resulting file.

The SPSS syntax to perform this match is shown here along with the transformation commands used to identify the largest invoice for each customer:

STAR JOIN
 /SELECT t0.InvoiceNo, t0.InvoiceDate, t0.itemcost_total, t0.numproducts, t0.priorinvoicedate, 
 t0.priorcustID, t0.daysincepurchase...