1.Your proposal – What do you plan to study?How do you plan to conduct your study?What data will you use?What will you produce that will address your project goals?

2.Your spreadsheet – This should contain an organized arrangement of the steps you went through in acquiring, shaping, and processing your data to meet the needs of your project (do not physically include your raw data)

3.Your write-up – provide an executive summary of the problem, the analysis, the findings and conclusions/recommendations. (5-page limit, and no raw data, but tables and graphs are fine.)

Here’s the link for the Crime Data. District 10 is what I’ve been focused on.

https://data.cityofchicago.org/Public-Safety/Crime…

We’ve used the data to do 3D maps in excel. Teacher is just wanting the above. Excel charts and diagrams can be added to the paper.

Teacher had comments about this paper:

Your title suggests that education is the independent variable, but then discuss the impact of unemployment.

Following your unemployment focus, your first research question asks, “Is unemployment a problem in Chicago?” How do you operationalize “problem?” And how will this be reported in your study?

Your second research question asks “Does unemployment contribute to adherence to general laws and regulations in Chicago?” The question implies an assumption that unemployment contributes to adherence to the law…rather counterintuitive. Additionally, you do not cover law violations in general, only weapons charges.

Your third question is nonsequitur. “Are people with no jobs more likely to violate gun laws than those with education?” First, the comparison between unemployment versus education is problematic. Second, you do not have the data on individuals’ employment status or education levels. You only have the census information about your district. You cannot infer causal relationships between aggregate characteristics and individual behavior. This is known as an “ecological fallacy.”

You need to couch the language of your questions in terms of geographic areas, not people.

Your examination of District 10 has a major problem…to assert that unemployment is high in district 10 begs the question, “Compared to what?” How do you know that unemployment is high and If it is high, what is average?

Additionally, there is no data provided that would suggest that areas where unemployment is lower also have lower gun law violations. So how do you propose to answer this research question?

The fourth question is worded better but you did not do anything to answer it. You did not examine the relationship between unemployment and weapon violations across Chicago, only District 10. A single district cannot be assumed to represent Chicago.

From 2009 to 2019 the total number of weapons violations in Chicago are:

415637043879390732463114336434504686545633403845.63662

The last number is the average for the 11 years. Dividing each year value by the average, provides a measure in which a value equal to 1 is the average, a value greater than 1 reports the degree of above-average arrests, and a value less that one reports the levels of below average arrests.

If you were to compare each of your three communities that are part of District 10, you will be able to see how the three communities compare in their arrest levels over the 11 years. Considering that community 29 has a higher level of unemployment than communities 30 and 31. You will be able to draw tentative conclusions about the association of unemployment and weapons violations.

Notice I said “tentative” you cannot prove causation at an individual level with aggregated data.

I’ve attached the original paper