200 likes | 331 Views
Is 6833 Analytics Assignment. Ying Chen, Sri Murali, John Powell, Scott Weber. Homicide - National Trend. Definition: Willful (non-negligent) killing of one human being by another 1. Our Approach. Regression Model. Based on Historical Data Weighted Moving Average .1 – 3 previous years
E N D
Is 6833Analytics Assignment Ying Chen, Sri Murali, John Powell, Scott Weber
Homicide - National Trend • Definition: Willful (non-negligent) killing of one human being by another1
Regression Model • Based on Historical Data • Weighted Moving Average .1 – 3 previous years .2 – 2 previous years .3 – previous year .4 – current year • This statistical analysis was used for the total number and an individual neighborhood basis
Regression Model Conclusion • We predict that 43/91 neighborhoods (47.25%) will be murder free. • Prediction • Baden (11) • Jeff Vanderlou (9) • Midtown/Hamilton Heights/The Great Ville/ Wells-Goodfellow (5)
Demographic Based Model • Study Independent Variables Correlated to Homicides • Sources: • Report published Bureau of Justice Statistics in report Homicide Trends in the United States, 1980-2008, released in November 20113 • Research Paper Structural Determinants of Homicide: The Big Three, published in Journal of Quantitative Criminology in March 20114 • Article National Case-Control Study of Homicide Offending and Methamphetamine Use, published Journal of Interpersonal Violence, published in June 20095 • Research paper Crime is the Problem: Homicide, Acquisitive Crime, and Economic Conditions, published in Journal of Quantitative Criminology in September 20096
Data Analysis Review • Almost 90% of the offenders are males • 65% of the offenders are in the 18-34 age group • Larger cities experienced higher number of homicides • More than 2/3rds of homicides were by guns • Homicide rates correlated to other factors • Economic Conditions • Educational Level • Divorce Rate • Drug Use
St. Louis City Demographics • Analyzed data from 2010 census for census tracts in St. Louis city • Studied variables • Number of males in age group 18-34 • Educational level • Marital Status • Poverty level • Median Home Price
St. Louis City - Educational Level Expressed as a percentage of male population
Divorce Rate Number of men divorced compared to number of men married
Economic Conditions Percentage of Population in Poverty
Prediction Based on Historical Data • Based on historical demographic information, homicide is more likely to occur in the neighborhood of Wells-Goodfellow, which is comprised of census tracts 1062 and 1063 • Map of neighborhood9:
Conclusion • Given the research on the variables we have chosen to study are not up to date, we conclude that the best predictor of murder rates in neighborhoods in St. Louis city is the regression model. • We believe the variables are valid indicators of murder rates, but accurate conclusions cannot be drawn because the data is not current. • Baden, with 11 predicted murders in 2012, is the most dangerous neighborhood in the city.
Assumptions and Caveats • Demographic data obtained from 2010 census • Census data doesn’t accurately portray current demographics • Data from St. Louis Metropolitan Police Department assumed to include only homicides • More recent numbers were assigned higher weights • Demographic data for correlation based on single census tract
References • 1: FBI definition: http://www2.fbi.gov/ucr/cius2009/offenses/violent_crime/murder_homicide.html • 2: Homicide Rates: http://www.fbi.gov/about-us/cjis/ucr/crime-in-the-u.s/2010/crime-in-the-u.s.-2010/tables/10tbl01.xls • 3: BJS report and data: http://bjs.ojp.usdoj.gov/index.cfm?ty=pbdetail&iid=2221 • 4: Structural Determinants of Homicide: The Big Three: http://www.springerlink.com.ezproxy.umsl.edu/content/d484g87643485322/fulltext.html • 5: National Case-Control Study of Homicide Offending and Methamphetamine use: http://jiv.sagepub.com.ezproxy.umsl.edu/content/24/6/911.full.pdf+html • 6: Crime is the Problem: Homicide, Acquisitive Crime, and Economic Conditions: http://search.ebscohost.com.ezproxy.umsl.edu/login.aspx?direct=true&db=cja&AN=43757548&site=ehost-live • 7: Census data: http://factfinder2.census.gov • 8: St. Louis Metropolitan Police Department Crime Statistics: http://www.slmpd.org/crime_stats.html • 9: Map showing St. Louis City Neighborhoods and Census Tracts: https://sites.google.com/a/slu.edu/montrejr/census