Problems Now that the datasets are successfully related, it is time to make use of the information. Remember from the class discussion, analysts often have to manipulate data to make it useful for internal and external stakeholders. Two variables that don't exist currently but would be useful is a variable describing if a person is a victim of cybercrime and a variable that portrays the type of victimization that individual experienced. The information exists currently, but fields need to be related and new variables need to be constructed from the related variables.

Instructions For this lab, students will create two new variables:

Victim variable: a binary variable with the following construction:

0 for no history of victimization and

1 for having been a victim of cybercrime

Victim Type: an ordinal variable with the following scale:

0 for no victimization

1 for credit card fraud

2 for other identity theft

3 for both

Following best practice, these new variables will sit in a separate file with an included key that relates to the other datafiles. Students can construct the variables in either Excel or Tableau (or other software platform). The student will submit:

Frequencies for both Victim and Victim Type variable

An analysis of interest with either Victim and Victim Type and other variables contained in the related dataset and an artifact of that analysis (i.e., cross-tab, scatterplot).