Question Description
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).
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.cfmThere 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).
