1) What is the sample size of the dataset?
2) Using the current variables, develop a simple study that includes a dependent variable and a few independent variables. The important thing to emphasize in this Q is what is your: (1) research question, (2) dependent variable, and (3) independent variable(s).
3) What is the mean, median, and mode “Age” of offenders?
4) Would the median or mean offer a better measure of central tendency when summarizing the “# Incident Injuries” variable?
5) What level of measurement is the variable “Offender Race/Ethnicity”?
6) What level of measurement is the variable “Offender Education Level”?
7) What level of measurement is the variable “Date of Attack”?
8) Which offender produced the greatest number of incident fatalities and incident injuries?
9) Were offenders more likely to be Jihadist-Inspired, Far-Right, or Far-Left “Terrorist Types”?
10) On average, were there more fatalities in religious locations or government locations?
11) What type of test would you use to determine if there was a relationship between “Conclusion” of an attack (i.e., Arrested, Killed, Suicide) and “Incident Location” (i.e., Government, Religious, Other)? You do not need to conduct the test, just explain your answer.
12) What type of test would use to determine whether “# Fatalities” impacted the “Conclusion” of an attack (i.e., Arrested, Killed, Suicide)? You do not need to conduct the test, just explain your answer.
13) Conduct a test in Excel to determine if the “Total # of Guns” variable impacts the “# of Incident Fatalities” variable. In other words, was there a significant difference. Explain your process for obtaining this answer.
14) Conduct a test in Excel to determine if the “Offender Mentally Ill” variable impacts the “# of Incident Injuries” variable. In other words, was there a significant difference. Explain your process for obtaining this answer.
15) Create a pie chart that looks at “Offender Born in Another Country” (no = 0; yes = 1). Copy and paste the graph from Excel into this word doc.
16) Explain the findings from the graph you created in Q15. Include as much detail as you can and address what you find interesting.
17) Create a line graph that looks at the “# of Incident Fatalities” committed by Decade (Not Year). In other words, how many Fatalities (in total) were committed each Decade. Remember, you will need to create a new “Sheet” with new (added) cells. Copy and paste the graph from Excel into this word doc.
18) Explain the findings from the graph you created in Q17. Include as much detail as you can and address what you find interesting.
19) Create a bar graph that looks at “Terrorist Type” by “Offender Conclusion”. Remember, you will need to create a new “Sheet” with new (added) cells. Copy and paste the graph from Excel into this word doc.
20) Explain the findings from the graph you created in Q19. Include as much detail as you can and address what you find interesting.