Education homework
FGHJKL;LKMJNBVC
2 years ago
20
PUBH6033_Wk5_Assign1_Worksheet1.doc
DataTransformationWorksheet.docx
PUBH_6032_M3_SPSS_Skills_Dataset1.xlsx
PUBH6033_Wk5_Assign1_Worksheet1.doc
DataTransformationWorksheet.docx
Module 3 Data Transformation Worksheet
Name: _____________________
In this assignment, you will use the SPSS Skills Data Set and SPSS software to practice several data transformation procedures. Begin by downloading the SPSS Skills Data Set (Excel file) to your computer and complete the following steps:
Step 1: Import Data Set
· Open the SPSS software
· Locate the SPSS Skills Data Set in your files
· Click “Open” and then “OK”
If you have correctly imported the Excel file, you will see rows and columns of data displayed in the Data View window.
Step 2: Split File by STROKE
· Select “Data”
· Select “Split File”
· Highlight the variable STROKE
· Select “Organize output by groups”
· Click the arrow to move STROKE to the box
If you have correctly split the file, you will see a shift in the order of cases, now listed by STROKE instead of ID number.
Step 3: Select Cases: 50% Random Sample
· Select “Data”
· Select “Select Cases”
· Select “Random sample of cases”
· Click the “Sample” button
· In the Approximately box, enter “50”
· Click “Continue” and then “OK”
If you have correctly completed this select cases procedure, you will see a random selection of 50% of the cases.
Step 4: Recode RACE Variable
· Select “Transform”
· Select “Recode into Different Variables”
· Highlight the variable “RACE”
· Click the arrow to move RACE to the box
· Under Output Variable, enter the following information:
· Name: RACENUM
· Label: Race number category
· Click “Change:
· Click “Old and New Values”
· Enter old and new values for each RACE category using the following information, then click “Add” to move information to the OldNew box:
|
Old Value |
New Value |
|
Black |
1 |
|
White |
2 |
|
Other |
3 |
· Click “Continue” and then “OK”
If you have correctly recoded the RACE variable, you will see a new column with RACENUM in Data View.
Step 5: Take a screenshot of Data View
To demonstrate that you have correctly completed each step, take a screenshot of Data View and post it here.
Page 2 of 2
PUBH_6032_M3_SPSS_Skills_Dataset1.xlsx
Sheet1
| ID | RACE | BMI | STROKE |
| 1 | White | 25 | 0 |
| 2 | Black | 32 | 0 |
| 3 | Other | 19 | 0 |
| 4 | White | 25 | 1 |
| 5 | White | 21 | 1 |
| 6 | Black | 36 | 0 |
| 7 | Other | 30 | 1 |
| 8 | White | 39 | 1 |
| 9 | White | 29 | 0 |
| 10 | White | 25 | 0 |
| 11 | Black | 32 | 1 |
| 12 | White | 40 | 1 |
| 13 | Other | 35 | 0 |
| 14 | Black | 38 | 1 |
| 15 | Other | 36 | 0 |
| 16 | Other | 30 | 0 |
| 17 | White | 41 | 1 |
| 18 | White | 24 | 0 |
| 19 | Other | 35 | 1 |
| 20 | Black | 30 | 0 |
| 21 | White | 44 | 1 |
| 22 | Black | 45 | 1 |
| 23 | White | 29 | 0 |
| 24 | Other | 39 | 0 |
| 25 | White | 27 | 0 |
| 26 | Other | 37 | 1 |
| 27 | Black | 22 | 0 |
| 28 | Other | 31 | 1 |
| 29 | White | 19 | 0 |
| 30 | Black | 41 | 1 |