CRJU3610_Problem Set_2 new Answer Key

docx

School

El Camino Community College District *

*We aren’t endorsed by this school

Course

CRIMINOLOG

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by nijatsunami

Statistical Analysis in Criminal Justice Problem Set # 2 Name_________________________________________________________________ Purpose In these problems, you will:  Demonstrate your ability to evaluate and use an excel spreadsheet  Develop and interpret charts and graphs Instructions Use the excel data in the folder “Excel Data for Class & Problem Sets” to answer the following questions. You must upload your own Excel Workbook as your Problem Set in iCollege. Please insert a new sheet into the Workbook and label it PS2. Do all of your work in this sheet PS2.  Your homework must be completed independently, or it is considered academic dishonesty Problems 1. In a sample of police officers, the number of times they pulled over a person for making an illegal turn last month: 2, 10, 15, 7, 0, 15, 10, 12, 15, 9, 10 37, 9 Present these data in a cumulative frequency distribution. Do this by hand. Also, do this excel by using the =countif function as we did in class. You must submit your excel workbook in ICollege with Sheet 1 labelled cumulative frequency distribution. x f % Cf C% 0 1 7.69 1 7.69 2 1 7.69 2 15.38 7 1 7.69 3 23.07 9 2 15.39 5 38.46 10 3 23.08 8 61.54 12 1 7.69 9 69.23 15 3 23.08 12 92.31 37 1 7.69 13 100.00 2. Based on your cumulative frequency distribution: a. how many police officers pulled over 9 people last month? 2

b. what percentage of police officers pulled over more than 10 people last month? 100-61.54=38.46% c. what proportion of police officers pulled over 15 people last month? .2308 d. what proportion of police officers pulled over fewer than 12 people last month? .6154 3. You hypothesize that those with mental health disorders will be more likely to take prescription drugs than those without mental disorders. You collect data and create a cross-tab to reflect what you found. Using this cross-tab: Mental Health Disorder Take Prescription Drug Yes No 128 Yes 37 91 34 No 22 12 59 103 N=162 a. What proportion of the sample has a mental health disorder? 59/162=.3642 b. Of those who take prescription drugs, what percentage has a mental disorder? (37/128)*100=28.91% c. What percentage of the sample does not take prescription drugs? (34/162)*100=20.99% d. Of those without a mental health disorder, what proportion takes prescription drugs? 91/103=.88 e. What is the independent variable? Is it located in the columns or rows? Mental health disorder; columns 4. There were 990 people shot dead by the police in 2015. Below are data reflecting the race of the VICTIM who was by the police. Based on the following information, create an appropriate chart to depict the data. Be sure to label all of the relevant parts of your chart and make it look pretty! Retrieved from https://www.washingtonpost.com/graphics/national/police-shootings/ Race f White 494

Black 258 Hispanic 172 Other 38 Unknown 28 White Black Hispanic Other Unknown 0 100 200 300 400 500 600 Race of victim of person shot by police, 2015 Victim Race f 5. Based on this graph, answer the following: a. What type of graph is this? Line graph b. What year was the number of data breaches the highest? 2017

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

c. Write two sentences to describe what is interesting from this chart. Write so that a person who did not know anything about the topic could understand. Since 2005, there has been an increasing number of data breaches and records exposed. This increase has been dramatic from 157m to 1244 million breaches d. At what year was the number of records exposed the highest? 2018 6. Using the report found at https://www.bjs.gov/content/pub/pdf/bwclea16.pdf answer the following questions. 1. Using to Table 1, describe the size of local police and sheriff’s offices that have at least some BWC in use. Agencies with 1,000 or more full-time sworn officers are more likely than smaller agencies to have BWC in use. 2. What is the most common reason why BWC are acquired by departments? (i.e., what table did you look at?) Table 3; to improve officer safety 3. Do most police agencies that have BWC also have a BWC policy? How do you know? (i.e., what table did you look at?) Yes; Table 5; 85.9% of agencies that had acquired BWC also had a policy 4.Other than what has been asked about in this question, identify one FACT that you find interesting from this report and EXPLAIN why you find it interesting.

CRJU3610_Problem Set_2 new Answer Key

Related Documents