19,99 €
Mehr erfahren.
- Herausgeber: John Wiley & Sons
- Kategorie: Ratgeber
- Sprache: Englisch
Practice making sense of data with IBM's SPSS Statistics software SPSS Statistics Workbook For Dummies gives you the practice you need to navigate the leading statistical software suite. Data management and analysis, advanced analytics, business intelligence--SPSS is a powerhouse of a research platform, and this book helps you master the fundamentals and analyze data more effectively. You'll work through practice problems that help you understand the calculations you need to perform, complete predictive analyses, and produce informative graphs. This workbook gives you hands-on exercises to hone your statistical analysis skills with SPSS Statistics 28. Plus, explanations and insider tips help you navigate the software with ease. Practical and easy-to-understand, in classic Dummies style. * Practice organizing, analyzing, and graphing data * Learn to write, edit, and format SPSS syntax * Explore the upgrades and features new to SPSS 28 * Try your hand at advanced data analysis procedures For academics using SPSS for research, business analysts and market researchers looking to extract valuable insights from data, and anyone with a hankering for more stats practice.
Sie lesen das E-Book in den Legimi-Apps auf:
Seitenzahl: 290
Veröffentlichungsjahr: 2023
Ähnliche
SPSS® Statistics Workbook For Dummies®
Published by: John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030-5774,www.wiley.com
Copyright © 2023 by John Wiley & Sons, Inc., Hoboken, New Jersey
Published simultaneously in Canada
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the Publisher. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions.
Trademarks: Wiley, For Dummies, the Dummies Man logo, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and may not be used without written permission. SPSS is a registered trademark of IBM Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: WHILE THE PUBLISHER AND AUTHORS HAVE USED THEIR BEST EFFORTS IN PREPARING THIS WORK, THEY MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES REPRESENTATIVES, WRITTEN SALES MATERIALS OR PROMOTIONAL STATEMENTS FOR THIS WORK. THE FACT THAT AN ORGANIZATION, WEBSITE, OR PRODUCT IS REFERRED TO IN THIS WORK AS A CITATION AND/OR POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT THE PUBLISHER AND AUTHORS ENDORSE THE INFORMATION OR SERVICES THE ORGANIZATION, WEBSITE, OR PRODUCT MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. THIS WORK IS SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING PROFESSIONAL SERVICES. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR YOUR SITUATION. YOU SHOULD CONSULT WITH A SPECIALIST WHERE APPROPRIATE. FURTHER, READERS SHOULD BE AWARE THAT WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ. NEITHER THE PUBLISHER NOR AUTHORS SHALL BE LIABLE FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT LIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES.
For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002. For technical support, please visit https://hub.wiley.com/community/support/dummies.
Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.
ISBN 978-1-394-15630-6 (pbk); ISBN 978-1-394-15632-0 (ebk); ISBN 978-1-394-15631-3 (ebk)
SPSS® Statistics Workbook For Dummies®
To view this book's Cheat Sheet, simply go to www.dummies.com and search for “SPSS Statistics Workbook For Dummies Cheat Sheet” in the Search box.
Table of Contents
Cover
Title Page
Copyright
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Part 1: Getting Data into and out of SPSS
Chapter 1: Working Through Import and Export Challenges
Importing Data
Exporting Results
Answers to Problems in Working Through Import and Export Challenges
Chapter 2: Defining Data
Defining Metadata
Working with Dates and Times
Copying Data Properties
Answers to Problems in Defining Data
Part 2: Messing with Data in SPSS
Chapter 3: Using the Data Menu
Selecting Data
Splitting Data
Merging Files by Adding Cases
Merging Files Adding Variables
Answers to Problems in Using the Data Menu
Chapter 4: Putting the Transform Menu to Work
Counting Case Occurrences
Recoding Variables
Binning
Answers to Problems in Putting the Transform Menu to Work
Chapter 5: Computing Variables
Calculating a New Variable
Computing More Complex Variables
Using System Variables
Using String Functions
Using Multiple String Functions
Answers to Problems in Computing Variables
Part 3: Analyzing Data
Chapter 6: Using Descriptive Statistics
Level of Measurement
Focusing on Frequencies
Summarizing Variables with the Descriptives Procedure
Working with Z-Scores
Answers to Problems in Using Descriptive Statistics
Chapter 7: Testing Relationships with the Chi-Square Test of Independence
Running the Chi-Square Test of Independence
Comparing Column Proportions
Creating a Clustered Bar Chart
Answers to Problems in Testing Relationships with the Chi-Square Test of Independence
Chapter 8: Comparing Two Groups with T-Tests
Running the Independent-Samples T-Test Procedure
Running the Paired-Samples T-Test Procedure
Comparing the Means Graphically
Answers to Problems in Comparing Two Groups with T-Tests
Chapter 9: Comparing More Than Two Groups with ANOVA
Running the One-Way ANOVA Procedure
Conducting Post Hoc Tests
Comparing the Means Graphically
Answers to Problems in Comparing More Than Two Groups with ANOVA
Chapter 10: Testing Relationships with Correlation
Viewing Relationships
Running the Bivariate Procedure
Answers to Problems in Testing Relationships with Correlation
Chapter 11: Making Predictions Using Linear Regression
Performing Simple Linear Regression
Performing Multiple Linear Regression
Answers to Problems in Regression
Part 4: Producing and Editing Output
Chapter 12: Building Graphs with Bars, Lines, and Wedges
Building Bar Graphs
Creating Line Charts
Making Pie Charts
Constructing Histograms
Answers to Problems in Building Graphs with Bars, Lines, and Wedges
Chapter 13: Building Slightly More Complex Graphs
Building Clustered Graphs
Creating Multiple Line Charts
Using Error Bar Charts to Compare Means
Viewing Relationships between Continuous Variables
Identifying Outliers with Boxplots
Answers to Problems in Building Slightly More Complex Graphs
Chapter 14: Editing Output
Answers to Problems in Editing Output
Part 5: Programming SPSS with Command Syntax
Chapter 15: Working with Pasted SPSS Syntax
Pasting Procedures
Pasting Transformations
Controlling Variable View Specifications with Syntax
Answers to Problems in Pasting and Modifying Syntax
Chapter 16: Computing Variables with Syntax
Calculating New Variable with Syntax
Using DO IF … END IF
Answers to Problems in Computing Variables with Syntax
Part 6: The Part of Tens
Chapter 17: Ten Tricky SPSS Skills to Practice
Using RECODE INTO SAME
Using COMPUTE with System Missing and Other Missing Values
Merging Two or More Files
Creating Consistent Charts
Creating Consistent Tables
Replicating a Multistep Process in Syntax
Producing Tables with Custom Tables
Using the TEMPORARY Command
Explaining P-Values to Others
Explaining Statistical Assumptions to Others
Chapter 18: Ten Practice Certification Questions
Answers to Practice Questions
Index
About the Authors
Connect with Dummies
End User License Agreement
List of Tables
Chapter 18
Table 18-1 Breakdown of Chapters in Relation to SPSS Certification Exam Topics
List of Illustrations
Chapter 1
FIGURE 1-1: Select which data in the spreadsheet to include.
FIGURE 1-2: Pasting a table in Microsoft Word.
Chapter 2
FIGURE 2-1: The completed Value Labels dialog.
FIGURE 2-2: Date and Time wizard.
FIGURE 2-3: Select the source variable names you want to use for definitions.
Chapter 3
FIGURE 3-1: The If dialog.
FIGURE 3-2: The frequency of genders while in split mode.
FIGURE 3-3: Unpaired variables.
FIGURE 3-4: The Merge method dialog.
Chapter 4
FIGURE 4-1: The chosen variables to be counted and the name of the new variable...
FIGURE 4-2: Define the criteria that determine which values are included in the...
FIGURE 4-3: All possible values recoded for a new variable.
FIGURE 4-4: The dialog for automatic recoding.
FIGURE 4-5: Autorecoded values.
FIGURE 4-6: Specify how you want the data divided into bins.
FIGURE 4-7: A bar graph of the data with cutpoints for binning.
Chapter 5
FIGURE 5-1: A simple subtraction of two variables.
FIGURE 5-2: Calculating an average using an equation.
FIGURE 5-3: Calculating today’s date.
FIGURE 5-4: Creating a variable with all caps.
FIGURE 5-5: Creating a variable with all caps.
Chapter 6
FIGURE 6-1: The frequency table for the happiness of marriage variable.
FIGURE 6-2: A bar chart for the happiness of marriage variable.
FIGURE 6-3: The Descriptive Statistics table.
FIGURE 6-4: The Age variable has been standardized.
Chapter 7
FIGURE 7-1: The cross tabulation table.
FIGURE 7-2: The Chi-Square Tests table.
FIGURE 7-3: The cross tabulation table with the compare column proportions test...
FIGURE 7-4: A cluster bar graph displaying the relationship between belief in l...
Chapter 8
FIGURE 8-1: The Group Statistics table.
FIGURE 8-2: The Independent Samples Test table.
FIGURE 8-3: The Paired Samples Statistics table.
FIGURE 8-4: The Paired Samples Test table.
FIGURE 8-5: Error bar graph displaying the age when respondents had their first...
Chapter 9
FIGURE 9-1: The Descriptives table.
FIGURE 9-2: The Tests of Homogeneity of Variances table.
FIGURE 9-3: The ANOVA table.
FIGURE 9-4: The Multiple Comparisons table.
FIGURE 9-5: A simple error bar graph displaying the relationship between the ag...
Chapter 10
FIGURE 10-1: The scatterplot of weight and height.
FIGURE 10-2: The Correlations table.
Chapter 11
FIGURE 11-1: The simple linear regression results.
FIGURE 11-2: Multiple regression results with MPG and two independent variables...
Chapter 12
FIGURE 12-1: Bar graph of the Class variable.
FIGURE 12-2: Line graph of the Class variable.
FIGURE 12-3: Pie chart of the Degree variable.
FIGURE 12-4: A histogram displaying distribution of age.
Chapter 13
FIGURE 13-1: A cluster bar graph displaying the relationship between degree and...
FIGURE 13-2: Distribution of the CLASS by SEX variables.
FIGURE 13-3: Error bar graph displaying the age when respondents had their firs...
FIGURE 13-4: The scatterplot of weight and height.
FIGURE 13-5: Boxplot displaying the number of hours respondents watch TV per da...
Chapter 14
FIGURE 14-1: The graph with the edited y-axis.
FIGURE 14-2: Counts and percentages are in separate columns.
Chapter 15
FIGURE 15-1: Pasted Syntax from the Descriptives procedure.
FIGURE 15-2: Variable keywords in Syntax.
Chapter 16
FIGURE 16-1: A DESCRIPTIVES report of EDUC SPEDUC ED_DIFF2.
FIGURE 16-2: FREQUENCIES report of ED_DIFF3.
Guide
Cover
Title Page
Copyright
Table of Contents
Begin Reading
Index
About the Authors
Pages
i
ii
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
199
200
201
202
203
204
205
206
207
208
209
210
211
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
287
288
289
290
291
292
293
294
295
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
313
314
315
316
317
319
320
321
322
323
324
325
326
327
328
329
Introduction
Do you need to use IBM SPSS Statistics for school or work and you feel that you need more practice to become proficient? Maybe you eventually get the results you need when you work in SPSS, but it feels like you aren’t doing so efficiently. Maybe you're about to embark on an important assignment or research project, and you feel like some more practice (with carefully presented solutions) is just what you need.
Not to worry. Help has arrived. SPSS Statistics Workbook For Dummies is a collection of exercises and solutions to move you towards mastery with SPSS. It is a companion book to SPSS Statistics For Dummies, 4th Edition, but you don't need to read both. (You see more about how the books work together later in this introduction.)
We (Keith and Jesus) have trained tens of thousands of students during in-person workshops for SPSS Inc. (before IBM acquired SPSS). That experience, over many years, means we’ve looked over the shoulders of attendees as they’ve attempted exercises just like these. We can anticipate possible mistakes before you make them — and if you practice the examples in this workbook, you won’t make them at all. We’ve used that experience, along with the topics that IBM has identified as important for certification, to keep you focused on the critical skills for using SPSS efficiently.
About This Book
This workbook is designed to develop your ability to perform the most common and important tasks in the efficient use of SPSS Statistics. Like all books in the Dummies series, it features easy-access organization and doesn’t bog you down in unnecessary details. We carefully listed, discussed, debated, and narrowed the topics to maximize an efficient investment of your time.
We understand and value academic pursuits, but this is not an academic book. This is an eminently practical book written by two authors who have spent decades leading software training workshops. However, if you're a student, a researcher, or an academic, we have you covered. We explain critical statistical concepts, choosing the right technique, and interpreting your results. All that and more is explained from a practical point of view.
So why choose this workbook?
Dozens of practical examples with step by step solutions
Advice from two lifelong users of SPSS Statistics
Topics carefully chosen and prioritized for the tasks you will encounter most often
Tips and tricks to avoid the most common mistakes from two authors who have observed (and made) every mistake that is possible to make in SPSS
We follow a few conventions in this workbook:
Most chapters in this workbook will have the following repeating structure: explanation, example, questions, and answers. The answers are found at the end of each chapter. While skipping around chapters and sections to find what you need is encouraged, you’ll probably have the best luck reading each section, as indicated with a major heading, in its entirety.
Most of the exercises use the menus and dialogs, so when we show you a series of mouse clicks to access a specific area of the menus, we list the steps like this: choose File ⇒ Open ⇒ Data and load the GSS2018.sav file.
Two
chapters 15
and
16
, focus on using SPSS Syntax. SPSS Syntax programming code appears in
monofont
to help differentiate it from other text.
You are encouraged to write directly in this workbook when trying interpretive questions. When the questions prompt for an interpretation like “Describe your result,” space is provided for you to write your answer.
Foolish Assumptions
This book is for you if you have IBM SPSS Statistics and want to practice. Because it's a workbook, you get dozens of examples to help you prepare data, create variables, produce statistical analyses, and even write SPSS Syntax. You can even check out practice questions for IBM's certification exam in the final section of the book.
This workbook has been written as a companion to the book SPSS Statistics For Dummies, 4th Edition. That book, which is written for first-time users of SPSS, has more theory, overview, and initial setup. You aren’t required to have both books, but they make a perfect pair. SPSS Statistics For Dummies is the best place to start if you are at ground zero. You can start there, and then try the exercises in this one. Or, and we like this option even better, use them side by side.
This book is about IBM SPSS Statistics. We sometimes call it SPSS Statistics, or even just SPSS. You may encounter something called IBM SPSS Modeler. That is different software, and this book will not discuss SPSS Modeler at all (except just now).
Icons Used in This Book
The tip icon marks tips and shortcuts to make working in SPSS Statistics quicker and easier.
Remember icons highlight information that’s especially important to know. These reminders represent best practices in using SPSS.
The technical stuff icon indicates information of a highly technical nature that provides helpful context. You can skip this info to complete a practice example, but it will help you more fully understand SPSS.
The warning icon tells you to watch out! It notifies you of important information that may save you headaches when using SPSS.
The example icon presents a fully worked-out solution as a reference to assist you with the practice problems.
Beyond the Book
This workbook is just one part of the support we provide for mastering SPSS. For details about significant updates or changes that occur between editions of this workbook, go to www.dummies.com, type SPSS Statistics Workbook For Dummies in the Search box, and open the Download tab on this book’s dedicated page.
That page is also where you'll find the book's cheat sheet, which contains advice for exploring a new data set, identifying which menu to use to perform various important data preparation operations, and finding the correct graph type for your data by utilizing level of measurement.
You can find a wealth of related information at the companion book’s Dummies page by going to www.dummies.com and typing SPSS Statistics For Dummies in the Search box. Videos describing the topics covered in SPSS Statistics For Dummies, 4th Edition and ten SPSS gotchas can be found at https://keithmccormick.com/SPSS4Dummies.
Where to Go from Here
We wrote this book in a nonlinear way. You can skip around. It’s okay. We skipped around when we wrote it, too. But it does have a structure. If you have a deep interest in a broad topic, you might want to complete an entire part of the book.
If you need practice getting your data in and set up, check out Part 1. Part 2 is all about creating variables with the Compute dialog and by using other transformations. If you need to apply a formula or modify a variable, check out the dozens of examples in this part.
If you need practice producing statistical analyses and interpreting them, you need Part 3. Part 4 is all about graphing, providing lots of practice making nearly every graph type that SPSS Statistics supports. You also learn about editing output.
If you are intrigued with Syntax but have been afraid to dive in, see Part 5. You get a chance to try Syntax and then check your work. Many of the tasks are similar to those in Part 2, except you work in the Syntax window in Part 5.
In the final section, Part 6, we warn you about skills that are particularly tricky and then offer some practice questions to help you decide if the IBM SPSS Statistics certification exam is something you’d like to try.
Part 1
Getting Data into and out of SPSS
IN THIS PART …
Bring data into SPSS and show results in other applications.
Define data properties.
Chapter 1
Working Through Import and Export Challenges
IN THIS CHAPTER
Resolving trouble with delimiters on import
Exporting output
In this chapter you learn about ways to transfer data into and out of SPSS. Getting data into SPSS is the first step before any analysis can be done. If the data is available in an SPSS data file (.sav file extension), bringing that data into SPSS is easy. If your data comes from another program such as Excel or is in the txt, CSV, or SAS format, you can import that data into SPSS with just a little more work. The examples in this chapter demonstrate some complications that arise when importing these types of files.
After SPSS analyzes your data and displays results in easy-to-understand tables and graphs, you might want to use the results in another application to share your findings with others. This might involve
Formatting tables as cleanly as possible for clarity of presentation and ease of viewing
Exporting output to a file format that can be read by any user, such as Portable Document Format (pdf)
Doing post-processing on pivot tables in another application, such as Microsoft Excel
Applications such as Microsoft's PowerPoint or Word can display the results of your analyses as plain text, as rich text, or as a metafile, which is a graphical representation of the output. Pivot tables can be pasted or exported to Microsoft Excel with each cell of the pivot table in a separate Excel cell.
In this chapter, you both copy and paste as well as export your SPSS output to another application.
Importing Data
This section contains an example of a procedure you can follow to read data from Excel files into SPSS. Along the way, SPSS keeps you informed about what’s going on so there won’t be any big surprises at the end. Here are a few things to consider to make the import process a little easier:
When reading the Excel file into SPSS, the file must not be open in Excel.
Variable names are read from the first row of the Excel spreadsheet. However, the blank spaces in the variable names are removed because blanks are not allowed in SPSS variable names.
The measurement levels of variables are assigned based on the criterion defined in Data options. Variables with a small number of values are set to nominal. Variables with many values are set to scale.
SPSS reads only the values in the cells of the spreadsheet. Formulas in the spreadsheet will be computed and these computed values imported to SPSS.
The formulas and other spreadsheet characteristics associated with the cells are not imported to SPSS.
We strongly recommend opening the original file in the software where it is stored so you can see how the file is structured.
In the following example, the Excel workbook has two worksheets: The first is the title page and the second contains the data. Do the following to read this data into SPSS:
Choose File ⇒ Import Data ⇒ Excel.
Select the GSS2018 Title.xlsx file and then click Open.
You can download the file from the book’s companion website at www.dummies.com/go/spssstatisticsworkbookfd.
In the Worksheet drop-down list, select the GSS2018 worksheet.
An Excel file can contain more than one worksheet, and you can choose the worksheet you want from the drop-down list, as shown in Figure 1-1.
Also, if you’ve elected to read only part of the data, use the Range drop-down list to specify the range of Excel cells that you want to import. Use the five check boxes, as needed, to specify whether the names of variables appear in the first row, the percentage of data to use to determine the variable type, and how to handle leading or trailing spaces.
Inspect the data preview to make sure the variables and data will be read properly.
FIGURE 1-1: Select which data in the spreadsheet to include.
Click the Read Variable Names from the First Row of Data check box.
Click OK.
Your data appears in the SPSS window.
Switch to the Variable View tab to examine the variable definitions and make any changes.
SPSS makes a bunch of assumptions about your data, and some of those assumptions are probably wrong.
Save the file using your chosen SPSS name, and you’re off and running.
See the following for an example of importing data into SPSS.
Q. Text files are another common source of data. Many spreadsheet programs and databases can save their contents in a text file format. Commonly used delimiter characters are tabs or commas.
Import the file GSS2018.csv to SPSS. Note that the comma-separated file has variable names in the first row. The variable names are in the first row and the data begins in row 2.
A. Do the following:
Choose File ⇒ Import Data ⇒ CSV Data.
Select the GSS2018.csv file, and then click Open.
The Text Import Wizard appears, allowing you to load and format your data. Examine the input data. The screen lets you peek at the contents of the input file so you can verify that you’ve chosen the right file.
Click Advanced Options (Text Wizard). Examine the input data.
If your file uses a predefined format (it doesn’t in this example), you can select it here and skip some of the later steps.
Click Continue.
Specify that the data is delimited and the names are included.
SPSS takes a guess, but you can also specify how your data is organized. It can be divided using commas (as in this example), spaces, tabs, semicolons, or some combination. Or your data may not be divided — it may be that all the data items are jammed together and each has a fixed width. If your text file includes the names of the variables, you need to tell SPSS.
Click Continue.
Specify how SPSS should interpret the text.
You can tell SPSS something about the file and which data you want to read.
Perhaps some lines at the top of the file should be ignored — this happens when you’re reading data from text intended for printing and header information is at the top. By telling SPSS about it, those first lines can be skipped.
Also, you can have one line of text represent one case (one row of data in SPSS), or you can have SPSS count the variables to determine where each row starts.
And you don’t have to read the entire file — you can select a maximum number of lines to read starting at the beginning of the file, or you can select a percentage of the total and have lines of text randomly selected throughout the file.
Click Continue.
Specify tab as the delimiter.
SPSS can use commas, spaces, tabs, and semicolons as delimiting characters. You can even use some other character as a delimiter by selecting Other and then typing the character. You can also specify whether your text is formatted with quotes (which is common) and whether you use single or double quotes.
Strings must be surrounded in quotes if they contain any of the characters being used as delimiters.
Click Continue.
If necessary, change the variable name and data format.
SPSS makes a guess for the type of each variable. To change a name, select it in the column heading at the bottom of the window, and then type the new name in the Variable Name field at the top. If you need to change the format, use the Data Format drop-down list.
You can also change the data types later in the Variable View tab of the Data Editor window.
Click Continue.
In the Would You Like to Save This File Format for Future Use? section, click No.
Saving the file format for future use is something you would do if you were loading more files of this same format into SPSS — it reduces the number of questions to answer and the amount of formatting to do next time.
Click the Done button.
Look at the data, and correct the data types and formats, if necessary. Then save it all to a file by choosing File ⇒ Save As.
1 Import the GSS2018.xlsx file to SPSS. This example has one worksheet, the variable names are in the first row, and the data begins in row 2.
2 Import the GSS2018 extra title.xlsx file to SPSS. This example has two worksheets in the Excel workbook. The first worksheet is the title page. The second worksheet contains the data, with the variable names in the first row and the data beginning in row 5.
3 Import the GSS2018.dat file to SPSS. This file has a DAT format. The variable names are in the first row and the data begins in row 2.
4 Import the GSS2018 lines.txt file to SPSS. This file has a TXT format. The variable names are in the first row and the data begins in row 3.
Exporting Results
If you have a single table or a small number of tables, you can copy and paste these directly into a file opened in another application. Alternatively, SPSS provides an export facility to export large numbers of tables and charts into a file in a variety of common formats: Excel, Portable Document Format (PDF), HTML, text, Microsoft Word, and PowerPoint files.
Choose File ⇒ Open ⇒ Output and load the Chapter1Output.spv file.
Download the file at www.dummies.com/go/spssstatisticsworkbookfd.
Select the R’s highest degree frequency table.
Choose Edit ⇒ Copy.
Switch to Word or another word-processing application.
Choose Edit ⇒ Paste Special.
When copying and pasting SPSS pivot tables, always use Paste Special because it provides various options for displaying the table.
Choose Formatted Text (RFT).
The table is pasted and looks like a Word table that can be edited, as shown in Figure 1-2.
FIGURE 1-2: Pasting a table in Microsoft Word.
See the following for an example of taking SPSS output and bringing into another application.
Q. Using the Chapter 1 Output.spv file, copy the graph for R’s highest degree and paste it into Word.
A. Select and copy the graph. Then go to Word and choose Edit ⇒ Paste (or Paste Special).
Charts are always pasted as images that cannot be edited.
5 Using the Chapter 1 Output.spv file, copy the R’s highest degree frequency table and paste in Word as a picture.
6 Using the Chapter 1 Output.spv file, copy the R’s highest degree frequency table and paste it in Excel as a table using Unicode Text.
7 Using the Chapter 1 Output.spv file, copy the R’s highest degree frequency table and paste it in Excel as a picture.
8 Export the Chapter 1 Output.spv file to Word.
Answers to Problems in Working Through Import and Export Challenges
1 Choose File ⇒ Import Data ⇒ Excel. Click the Read Variable Names from the First Row of Data check box.
2 Choose File ⇒ Import Data ⇒ Excel. Select the GSS2018 worksheet. Click the Read Variable Names from the First Row of Data check box. After the data has been imported, delete the extra rows that appear at the beginning of the file.
3 Choose File ⇒ Import Data ⇒ Text Data. Use the defaults but specify that tab is the only delimiter. Deselecting space as a delimiter will remove the extra column.
Always check the data preview to make sure you do not have any columns that do not have variable names. If this occurs, you did not select the correct delimiter.
4 Choose File ⇒ Import Data ⇒ Text Data. Use the defaults but specify that the first case of data begins on line 3. Also specify that tab is the only delimiter.
5 Select and copy the R’s highest degree frequency table. Then go to Word and choose Edit ⇒ Paste Special and select Picture. You would choose to copy SPSS output as a picture if you did all your editing in SPSS and would like the output to appear exactly as it appeared in SPSS.
6 Select and copy the R’s highest degree frequency table. Then go to Excel, choose Edit ⇒ Paste Special, and select Unicode Text. You would use the Unicode Text option so that you can further edit your tables in Excel.
7
