ECON101 University of California Violence and Property Crime Report
Anonymous

Question Description

The overall aim of our lab section this term is to increase your proficiency in Microsoft Excel and data analysis. By the end of the term, you should feel comfortable taking on any workplace assignments that involves data analysis through Excel. The first official lab aims to teach you a few lessons

Unformatted Attachment Preview

ECON 101: Statistics for Economics Lab Assignment 1 Dates: October 4th, October 7th and October 8th Due: October 11th, October 14th and October 15th The overall aim of our lab section this term is to increase your proficiency in Microsoft Excel and data analysis. By the end of the term, you should feel comfortable taking on any workplace assignments that involves data analysis through Excel. The first official lab aims to teach you a few lessons: • • • • Learn how to collect publicly accessible data. Find the descriptive measures of the data. Show the distribution of the data with a histogram. Present the data in a format that is easy-to-read for a wide audience. This week we will obtain data on the Violent and Property Crime rates in Riverside, as well as a city of your choice. Data on crime rates can be found at FBI’s Uniform Crime Reporting website at: https://www.ucrdatatool.gov/. Here are the steps that your lab TA will go through with you. 1. Go to https://www.ucrdatatool.gov/, click on “Go to the table-building tool” at the bottom of the page: 2. On the next page, you will see the possible geographical coverage areas that the FBI reports the data on the left-hand side (All States and US Total, Agencies by State, Larger Agencies). Click on “Larger Agencies”: 3. On the next screen, you will see the different ways that you can download data (Single agency reported crime, One Variable of Data or One year of data). Click on “Single agency reported crime”: 4. The next screen allows you to restrict which types of police departments you can look at. You can click “All” and then next. 5. This final screen allows you to choose the police department you want to analyze, the type of variables you want to obtain and the years you are interested in: 6. Scroll through the police departments/agencies (a.) and click on “Riverside Police Dept”. In (b.), hold down Ctrl and click on “Violent crime rates” and “Property crime rates”. Both terms should be highlighted. The years to include (c.) should go from 1985 to 2014, the maximum range. Click “Get Table”. 7. The following screen will show the rates for Violent Crime and Property crime in Riverside between 1985 and 2014. This is the “raw data”. Quickly get this into an Excel spreadsheet by clicking “Spreadsheet of this table (.csv file)” at the top of the page: A download should start and when you open up the file, Microsoft Excel will open up and the same data on the webpage will be available in the Excel file. 8. Now that you have your data in Excel, you will be able to obtain a number of statistics. Create a table that shows the mean, median, variance, standard deviation, skewness and the number of years that the rate is above the average for both violent crime and property crime. In creating the table, you will use the Excel functions: average, median, var.s, stdev.s and skew. Create an additional column using the “if” function that separates years where crime is above the mean. Find the covariance and correlation between violent crime and property crime. 9. Make sure your table is easy-to-read and informative. This will involve adding a title, merging cells, drawing lines, etc. Copy-and-paste your table to a Microsoft Word document. Do steps 10 through 13 on your own. Feel free to consult with your peers, but everyone should turn in their own assignment. 10. Return to the screen where you can choose which agency you want to examine. Choose an agency that you are interested in. The agency can be where you live, where you were born, where you vacation or a place you are interested in learning about. Make sure that the agency is a Police Department instead of a Sheriff’s Department. 11. Create a table with the mean, median, variance, standard deviation, skewness and the number of years that the rate is above the average for both violent crime and property crime. Also report the covariance and correlation between violent crime and property crime. 12. Combine the new table with the table that you created using the Riverside data and transfer it to a Microsoft Word document. 13. In one paragraph, describe your tables and compare the statistics between the cities in your table. Turn in your one-page document (table and paragraph) at the start of lab next week. ...
Purchase answer to see full attachment

Final Answer

Attached.

LastName1
Student’s Name
Instructors Name
Course Name
Date
Violence and property crime reported in a police department from 1985 to 2014.
Riverside Police Dept
Mean

Median

Variance

261,215

262,088

1,473,623,261

935.0767

808.4500

162,838.4315

7.9567

7.4000

14.6508

40.7897

36.8000

156.4431
#DIV/0!

44.8000

44.8000

296.7833

243.4500

15,249.4718

589.4167

526.1500

75,960.3407

5,206.0200

4,703.6000

2,946,877.5237

1,305.6667

874.5000

489,807.6602

3,006.0533

2,881.2000

585,913.6750

894.2967

871.2500

146,815.5348

Population
Violent Crime rate

Violence crime

Murder and nonnegligent
manslaughter rate
Legacy rape rate /1

Skewn
ess
0.2199

403.5324

13
12
0.7100

12.5077

Revised rape...

UCLA

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors