Problem Set 2- Aanyra Maddox

docx

School

Georgia State University *

*We aren’t endorsed by this school

Course

MATH2058

Subject

Statistics

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by ConstableHorse436

Report
Statistical Analysis in Criminal Justice Problem Set # 2 Name: Aanyra Maddox 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 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 labeled cumulative frequency distribution. 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? 38.46 % c. what proportion of police officers pulled over 15 people last month? 0.23 d. what proportion of police officers pulled over fewer than 12 people last month? 0.62 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 crosstab: Mental Health Disorder Take Prescription Drug Yes No Yes 37 91 No 22 12
a. What proportion of the sample has a mental health disorder? 0.36 b. Of those who take prescription drugs, what percentage has a mental disorder? 28.91% c. What percentage of the sample does not take prescription drugs? 20.99% d. Of those without a mental health disorder, what proportion takes prescription drugs? 0.88 e. What is the independent variable? Mental health disorder Is it located in the columns or rows? 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
494 258 172 38 28 Race of individuals shot by police in 2015 White Black Hispanic Other Unknown 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 about this chart. Write so that a person who did not know anything about the topic could understand. - One thing I found interesting about this chart is that as the years passed there was a gradual increase in data breaches. Another thing I found interesting was even though data breaches decreased in 2018, the records that were exposed increased . d. In 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. - The sizes of local police and sheriff’s offices that have more of “at least some BWCs in use” are larger. 2. What is the most common reason why BWCs are acquired by departments? (i.e., what table did you look at?) - According to Table 3, the most common reason why BWCs are acquired by departments is 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?) - According to Table 5, police agencies that have BWCs have a large percentage of BWC policies. 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. - One fact that I found interesting was that privacy concerns were the most common obstacle associated with using cameras or video in agencies with BWCs. I found this interesting because I was confused as to why privacy was such a huge concern. Having a body camera is extremely important and it can help the officer. I also feel as they are working, everything is public, they are in the public and helping the public, so what is it that is so private to them?