Dr. Daniel and Diva give you an Excel dataset to import into SPSS. You learn about potential problems and how to fix them before importing, along with Pro Tips all along the way. You learn how to set levels of measurement, use variable labels, create a unique identification number variable, recode string variables into numeric, delete a variable, and create a variable set. By the end of this video, you will be comfortable getting data into SPSS and preparing it for an analysis. This is the video series that I wish I had as a beginner with SPSS.
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Chapters
0:00 Introduction – Dr. Daniel & Diva the Pomeranian
0:49 Download the Excel data
1:17 Examine the variables in the dataset
3:51 Open SPSS
3:59 Options in the FILE command
4:45 Import an Excel file into SPSS
6:38 Set levels of measurement for variables in SPSS
7:34 Variable labels
9:36 Use CASENUM command to add unique identifier
12:17 String variables cannot be used for many analyses
13:25 AUTOMATIC RECODE string variables to numeric
15:34 The Value Label button
16:00 Delete a variable
16:18 Create a VARIABLE SET
18:14 Review of what we learned
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Statistics Instructors: you are free to link to this video and the playlist for your seated or online statistics course or for other educational purposes.
Music
Fate And Luck Version C
Intro - See Me On Top Version B
Outro - Hard Jack
Source: Digital Juice Royalty Free Music; www.digitaljuice.com
This series uses IBM SPSS Statistics 27.0.1
Edited in Camtasia 2020
Visual and audio content from DigitalJuice.com
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Link to a Google Drive folder with any files that I use in the videos including spreadsheets, the Bear Handout, and datasets. As I add new files, they will appear here, as well.
https://drive.google.com/drive/folders/1n9aCsq5j4dQ6m_sv62ohDI69aol3rW6Q?usp=sharing
To download, hover your cursor over the file icon and a blue download icon will appear. You do not need to request access to a file.