Violent Crime Rates in United States Assignment
Violent Crime Rates in United States Assignment
The purpose of this exercise is for you to be able to query information from existing databases, download the information, create tables, charts, and graphs in Excel as well as interpret the results. Use the following FBI website to do a query and create your own spreadsheet of data in Excel: http://www.ucrdatatool.gov/Search/Crime/State/StatebyState.cfm
There are three parameters for your query:
Choose one or more states: for this select either the entire United States or only ONE state of your choice. Selecting more than one state will give you too many tables to work with.
Choose one or more variable groups: Again, only select ONE variable group and for this assignment you should choose either the violent crime rates or property crime rates. DO NOT select NUMBER of violent or property crimes.
Choose years to include: You can choose whatever time frame you would like as long as it has at least 10 years in a row (e.g., 1971 to 1981).
After you “Get Table” you will create a spreadsheet in Excel by clicking on “Spreadsheet of this table (.cvs file). Although a .cvs file is not an Excel file, it will ask you whether you want to open it in Excel, which you do. To complete the assignment, you will follow these steps:
Format the table that is provided by the website so that it would look good in a report (i.e., add borders, colors, bold column titles, etc.).
Create a line graph that depicts the crime rate over time.
Create a pie-chart that depicts the percentages of the crime type breakdown in one year (e.g., property crime is broken down into burglary, larceny-theft, and motor vehicle theft). Do NOT include the total for the category in your pie chart, only the subcategories.
Create a third chart or graph (not table) of your choice with the same data, as long as it makes sense.
Copy the table and the three charts, and paste them into a Word document.
After each table or chart, describe in three sentences or so what it is presenting as well as make several conclusions based on what the results are. For example, you might write something like this for the line chart: The chart depicts the overall property crime rate per year for the state of Arizona from 1985 to 2000. The chart shows that the overall property crime rates were highest in Arizona from in 1989, 1990, 1994, and 1995 with 1995 being the highest. Also, the property crime rates were lowest in the most recent years (i.e., 1998 to 2000).
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
