Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Data Analysis with IBM SPSS Statistics
Data Analysis with IBM SPSS Statistics

Data Analysis with IBM SPSS Statistics: Implementing data modeling, descriptive statistics and ANOVA

Arrow left icon
Profile Icon Ken Stehlik-Barry Profile Icon Anthony Babinec
Arrow right icon
$65.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.9 (7 Ratings)
Paperback Sep 2017 446 pages 1st Edition
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon Ken Stehlik-Barry Profile Icon Anthony Babinec
Arrow right icon
$65.99
Full star icon Full star icon Full star icon Full star icon Half star icon 4.9 (7 Ratings)
Paperback Sep 2017 446 pages 1st Edition
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m
eBook
$35.99 $51.99
Paperback
$65.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Table of content icon View table of contents Preview book icon Preview Book

Data Analysis with IBM SPSS Statistics

Accessing and Organizing Data

This chapter shows you how to read common file formats such as an Excel sheet or a delimited text file to IBM SPSS Statistics. The rationale for showing the reading of these formats is that most software programs read these file formats. In addition, many analysts use Excel for simple data activities such as data handling and producing charts. However, beyond these simple activities, Excel is limited in the data analytic capabilities it provides, so researchers have turned to IBM SPSS Statistics for its extensive statistical and analytical capabilities.

In order to use IBM SPSS Statistics, you must first read your data to the IBM SPSS Statistics Data Editor window. Once you successfully read the data, you provide variable properties to enrich the description of the data. After you have established the variable properties for the variables in your...

Accessing and organizing data overview

Once you read the data to IBM SPSS Statistics, you should at least do a cursory data check of the inputted data. Do you see numeric data? String data? Is the data in the expected scale and range? Is the data complete?

Of course, even if your data is not really very large in either the number of rows or columns, it can be difficult to assess via a simple visual inspection. For this reason, you might use SPSS Statistics to produce a tabular summary of variables showing counts and percentages. Doing so produces tables showing all the data codes in the designated variables. Once you have defined the SPSS Variable Properties such as value labels, you can control the tabular display to show data values (the data codes), value labels, or both.

A further consideration is how the data values are represented for categorical variables. Let's...

Reading Excel files

Here is a snapshot of a portion of an Excel spreadsheet:

Note that row 1 of the Excel spreadsheet is a header row containing variable names for the columns.

When working with Excel spreadsheets or delimited text files, use row 1 of the file to supply variable names that you intend to use in SPSS Statistics.

IBM SPSS Statistics can directly read an Excel sheet. There are different implementations in different recent releases of IBM SPSS Statistics but, in general, the capability exists on the File menu. In IBM SPSS Statistics 24, use the following path:

File | Import Data

Here is the Read Excel File dialog box:

By default, IBM SPSS Statistics shows the entire range of data that it encounters in the Excel sheet. You can use the Range portion of the dialog box to specify a subset range. Also by default, IBM SPSS Statistics expects to find variable names in...

Reading delimited text data files

Here is a snapshot of a portion of a comma-delimited text file:

A delimiter is a character such as a comma that serves as a separator between elements across a line of data. A text file is a kind of computer file that is structured as a sequence of lines of electronic text, often using the ASCII character set. Such a file is easily viewed in Windows accessories such as Notepad. Note that row 1 of the comma-delimited text file is a header row containing variable names for the columns.

IBM SPSS Statistics can directly read a delimited text file. There are different implementations in different recent releases of IBM SPSS Statistics, but the capability exists on the File menu. In IBM SPSS Statistics 24, use the following path:

File | Import Data

Here is the Read CSV File dialog box:

The Read CSV File dialog box shows the name of the file and a...

Saving IBM SPSS Statistics files

Use the SAVE command to save a data file in the IBM SPSS Statistics format, which contains data plus a dictionary. The dictionary contains a name for each variable, plus variable metadata (variable properties) such as assigned variable labels, value labels, missing values, and formats. As an aside, the dictionary also contains text that was specified on the DOCUMENTS command, if this command is used.

To save the data file along with variable properties from the menus, specify as follows:

File | Save

This brings up the Save Data As dialog box:

At a minimum, specify the folder in which you wish to save the file, along with a filename. Then press either Paste to paste the syntax or Save to write the file to disk. In addition, you can use the Variables… button to select variables to keep or drop.

Here is an example of the pasted syntax:

SAVE...

Reading IBM SPSS Statistics files

The IBM SPSS Statistics file is a data file created and saved in IBM SPSS Statistics. This file contains data in binary form, variable names, and other variable properties, and is directly readable by IBM SPSS Statistics.

In IBM SPSS Statistics 24, use File | Open | Data.

Here is the Open Data dialog box:

Click on OK to read the file, or click on Paste to paste the constructed syntax to the syntax window.

Here is the constructed syntax:

GET
FILE='C:\Users\Tony\Documents\KSBSPSSBOOK_DATA\chapter2\gss2014\gss2014extract170113.sav'.
DATASET NAME DataSet1 WINDOW=FRONT.

Running the syntax populates an IBM SPSS Statistics Data Editor window with the data.

Demo - first look at the data - frequencies

The GSS 2014 data extract has 2,538 rows. You can inspect the data by visually scanning and scrolling through the data window, but the sample size makes it difficult to grasp all of the data at once. For example, how many unique values are there in a given variable? Do the values in a given variable occur with about the same frequency, or do certain values predominate? Running Frequencies on the data can serve as a useful first look because it produces summary tables that show all data values on the specified variables.

To run Frequencies from the menus, specify as follows:

Analyze | Descriptive Statistics | Frequencies

This opens the Frequencies dialog box.

Move all variables except ID from the left-hand side to the right-hand side variable list. Why leave out ID? This is because the resulting frequency table is quite lengthy.

Variables...
Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Leverage the power of IBM SPSS Statistics to perform efficient statistical analysis of your data
  • Choose the right statistical technique to analyze different types of data and build efficient models from your data with ease
  • Overcome any hurdle that you might come across while learning the different SPSS Statistics concepts with clear instructions, tips and tricks

Description

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.

Who is this book for?

This book is designed for analysts and researchers who need to work with data to discover meaningful patterns but do not have the time (or inclination) to become programmers. We assume a foundational understanding of statistics such as one would learn in a basic course or two on statistical techniques and methods.

What you will learn

  • Install and set up SPSS to create a working environment for analytics
  • Techniques for exploring data visually and statistically, assessing data quality and addressing issues related to missing data
  • How to import different kinds of data and work with it
  • Organize data for analytical purposes (create new data elements, sampling, weighting, subsetting, and restructure your data)
  • Discover basic relationships among data elements (bivariate data patterns, differences in means, correlations)
  • Explore multivariate relationships
  • Leverage the offerings to draw accurate insights from your research, and benefit your decision-making
Estimated delivery fee Deliver to Indonesia

Standard delivery 10 - 13 business days

$12.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Sep 22, 2017
Length: 446 pages
Edition : 1st
Language : English
ISBN-13 : 9781787283817
Vendor :
IBM
Category :
Concepts :
Tools :

What do you get with Print?

Product feature icon Instant access to your digital eBook copy whilst your Print order is Shipped
Product feature icon Paperback book shipped to your preferred address
Product feature icon Download this book in EPUB and PDF formats
Product feature icon Access this title in our online reader with advanced features
Product feature icon DRM FREE - Read whenever, wherever and however you want
Estimated delivery fee Deliver to Indonesia

Standard delivery 10 - 13 business days

$12.95

Premium delivery 5 - 8 business days

$45.95
(Includes tracking information)

Product Details

Publication date : Sep 22, 2017
Length: 446 pages
Edition : 1st
Language : English
ISBN-13 : 9781787283817
Vendor :
IBM
Category :
Concepts :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 242.97
Learning IBM SPSS Statistics
$137.99
IBM SPSS Modeler Essentials
$38.99
Data Analysis with IBM SPSS Statistics
$65.99
Total $ 242.97 Stars icon

Table of Contents

16 Chapters
Installing and Configuring SPSS Chevron down icon Chevron up icon
Accessing and Organizing Data Chevron down icon Chevron up icon
Statistics for Individual Data Elements Chevron down icon Chevron up icon
Dealing with Missing Data and Outliers Chevron down icon Chevron up icon
Visually Exploring the Data Chevron down icon Chevron up icon
Sampling, Subsetting, and Weighting Chevron down icon Chevron up icon
Creating New Data Elements Chevron down icon Chevron up icon
Adding and Matching Files Chevron down icon Chevron up icon
Aggregating and Restructuring Data Chevron down icon Chevron up icon
Crosstabulation Patterns for Categorical Data Chevron down icon Chevron up icon
Comparing Means and ANOVA Chevron down icon Chevron up icon
Correlations Chevron down icon Chevron up icon
Linear Regression Chevron down icon Chevron up icon
Principal Components and Factor Analysis Chevron down icon Chevron up icon
Clustering Chevron down icon Chevron up icon
Discriminant Analysis Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.9
(7 Ratings)
5 star 85.7%
4 star 14.3%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Meta S. Brown Dec 08, 2017
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is a top-rate book for learning introductory and intermediate SPSS skills.As a former staff trainer who taught thousands of people to use SPSS, I know what's what on this topic. These authors are real insiders, whose history with SPSS goes a long way back. They're experts whose simple and clear writing style is the best in the business.What's in the book?Absolute basics - installation, importing data, basic data organization (such as labeling), assessing data propertiesData preparation - data transformations such as computing new variables, merging and aggregationExploration - using descriptive statistics to assess the dataBasic statistics - all the things you'd cover in an introductory statistics class - descriptives, crosstabulation, chi-square, t, ANOVA, correlation and linear regressionIntermediate to advanced statistics - factor analysis and perceptual mapping, principal components analysis, clustering and discriminant analysis
Amazon Verified review Amazon
G.MARI Dec 31, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Simple to understand
Amazon Verified review Amazon
Inge Kurniadi Apr 29, 2019
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Just starting the journey to deep dive & using stats function in IBM Statistics which sometimes not as simple as it looks.
Amazon Verified review Amazon
Jean Jenkins Jan 23, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
When I was a rookie data analyst this book would have been perfect for me. I had a reasonable understanding of statistics from graduate school courses, but no understanding of real-life data analysis challenges, particularly involving the less-than-perfect data that is usually available. Data Analysis with IBM SPSS Statistics does an excellent job of guiding the reader through this. One learns how to use SPSS to solve data problems, and there are many tips on multiple ways to approach a problem, and how to pick the best solution for the data and the planned analysis.The emphasis the authors place on showing the reader all the ways in which SPSS can help with the complex task of data preparation is one of the best features of this book. This is an aspect of data analysis that many inexperienced analysts underestimate, and the authors not only show the reader what SPSS can do for an analyst, but why it is so important. Tips throughout point out some especially helpful features, and warn analysts about some common pitfalls.The chapters discussing SPSS statistical techniques are equally helpful and thorough. Again, there is emphasis on evaluating one’s data to make sure it is suitable for a given technique, and the data adequacy tests that are presented are explained in detail. Analytical results are discussed carefully and suggestions for further investigation are offered.
Amazon Verified review Amazon
StephenSchacht Jan 06, 2018
Full star icon Full star icon Full star icon Full star icon Full star icon 5
E-book review. This book fully meets the needs of its target audience: analysts and researcher with a course of two of statistics who are new to IBM SPSS Statistics and will be using it for data analysis and statistical work. It covers all the major elements: installation; reading, defining, transforming, and combining data files; exploring data (especially commendable is the emphasis on checking data for outliers, inconsistent data, and missing values); plus examples using the analytic and statistical procedures in IBM SPSS Statistics. Strong points include the detailed coverage of the most important and the most commonly used features of SPSS, the presentation of both the menu system and command syntax for most operations and analyses, the very clear explanations of operations, the insightful interpretations of results from a variety of statistical analyses, and use of multiple datasets. The authors’ extensive experience in SPSS training and consulting pays dividends in their choices of tips and topics to emphasize, which efficiently passes, directly to the reader, knowledge usually gained through painful experience. There are a few minor instances of inconsistent usage (e.g., Output Window versus Viewer) and slight production blemishes (a reference or so to figure numbers which don’t appear in the e-book), but they do not take away from the substantial value of this work. Highly recommended for the intended audience.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is the delivery time and cost of print book? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela
What is custom duty/charge? Chevron down icon Chevron up icon

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order? Chevron down icon Chevron up icon

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges? Chevron down icon Chevron up icon

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

  • If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
  • Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.
How can I cancel my order? Chevron down icon Chevron up icon

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy? Chevron down icon Chevron up icon

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

  1. If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
  2. Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
  3. You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
  4. Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
  5. If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
  6. Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged? Chevron down icon Chevron up icon

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use? Chevron down icon Chevron up icon

You can pay with the following card types:

  1. Visa Debit
  2. Visa Credit
  3. MasterCard
  4. PayPal
What is the delivery time and cost of print books? Chevron down icon Chevron up icon

Shipping Details

USA:

'

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.


Unfortunately, due to several restrictions, we are unable to ship to the following countries:

  1. Afghanistan
  2. American Samoa
  3. Belarus
  4. Brunei Darussalam
  5. Central African Republic
  6. The Democratic Republic of Congo
  7. Eritrea
  8. Guinea-bissau
  9. Iran
  10. Lebanon
  11. Libiya Arab Jamahriya
  12. Somalia
  13. Sudan
  14. Russian Federation
  15. Syrian Arab Republic
  16. Ukraine
  17. Venezuela