Crime Data Report

Please ensure no AI usage or plagiarism, and complete this by 11 pm Monday.

In this assignment, you will analyze crime data to create a polished-looking Crime Data Report. Imagine that your boss wants you to produce a report comparing crime statistics in your jurisdiction to another jurisdiction, as well as detailed information about crime in the community, to present to the commissioner. To do so, you will use UCR and NIBRS data from the

• UCR Data:

1. Describe what the UCR is, what data it contains and one strength and limitation.
2. Download data on a Part 1 or Part 2 Crimes in two locales to compare. You can select two states or two police departments. In your report, provide a graphic of the rate of that crime over time on a line graph.
3. Be sure to describe the trend you observe and point out unique data points specifically.
4. Consider the visual format and aesthetic of the graphic, making sure its readable, appealing and the axes and other aspects are labeled properly.
5. NIBRS Data:

1. Describe what NIBRS is, what data it contains and one strength and limitation
2. Download data from two local-level police jurisdictions to compare it to on three different NIBRS crime characteristics variables (if you want to explore homicide specifically, CA reports this via the Expanded Homicide Data).

• 1. • Compare two reporting police agencies on any NIBRS variable (in a single year or cumulatively over time), and
     • Two more NIBRS variables in reporting police agencies in separate figures.
  2. For each graphic, describe the data presented, including any decisions to exclude data (i.e. you dont have to include all the data points or you could combine data points, just note your rationale) or any important qualifying information detailed in the Crime Data Explorer.
  3. Consider the visual format and aesthetic of the graphic, making sure its readable, appealing and the axes and other aspects are labeled properly.

IMPORTANT: Download the .csv files from the Crime Data Explorer and be sure to save them as Excel workbooks. Copy and combine all your data into separate worksheets in a single Excel workbook, making sure to label each worksheet appropriately.

Be sure to describe the data youre reporting on in full, including whether it’s percents/proportions or raw counts, the rate, as appropriate for your data. Be sure to consider the best type of graphic to depict the data (line chart, bar chart, pie chart, etc.).

Crime Data Report: Copy and paste the charts you make in Excel into a Word document (CAUTION: If you use GoogleSheets, it will copy it as a picture and the data are not clearly linked. Only copy from Excel and be sure to paste as the figure/chart not a picture). Please do not copy screenshots from the FBI website or Excelcopy the actual image of the chart/figure that you created.

At the beginning of the document, provide information regarding the data being presented (such as year of collection, source, authors, etc.). Then create a figure visually depicting these data. For each table and graph, provide a brief description/interpretation of what is depicted. Be sure to label each figure and table. Some additional things to make the best report:

• Use a report design theme to polish up your report.
• Be sure the formatting and font is consistent throughout (as in the same font and size),
• Make sure all the parts of the graph are properly labeled.
• Make sure the table is on the same page (not crossing over pages)
• Be sure to discuss the data and refer to the graph/table before presenting

Guidelines

You will submit two files for this assignment.

1. Submit your report via Canvas in a Word document (.doc, .docx) or PDF named with the title of your report and your last name (ex. Crime Report_KRAS). The format of the report is as follows:

• Title Page (title of project, name, date)
• Introduction (including information on the data source and what you are examining)
• Explanation/Interpretation, Figure 1
• Explanation/Interpretation, Figure 2
• References (the data tool and any other resource you used; on a separate page)

1. Your Excel Workbook (so that I can examine the data used)

Grading Rubric:

Accuracy (35): Accurately analyzes the data frequencies, trends, and other descriptive information and accurately depicts it in the graphical displays.

• Labeling of axes on figures and graphs and columns on tables
• Completeness of data presented
• Proper calculations in tables (if any)

Consistency and formatting (15): Consistency (the same) in presentation of information and formatting across the document.

• Font style and size consistency and appropriateness
• Completeness of all sections of the report

Style (10): Creativity of data display using tools in Word, Excel or other elements (color, size, style, position, etc.) to improve the readability and aesthetic of the report.

Excel Workbook (10): Accurate data and graphs that correspond with that reflected in the report.

I attached the example report and excel they gave me

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER