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.

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

Above is the information for this assignment that I need help with.

No, I don't intend to submit the wording as my work, but it is steps you will follow to complete the assignment