Crime is an international concern, but it is documented and handled in very diff

Crime is an international concern, but it is documented and handled in very different ways in different countries. In the United States, violent crimes and property crimes are recorded by the Federal Bureau of Investigation (FBI). Additionally, each city documents crime, and some cities release data regarding crime rates. The city of Chicago, Illinois releases Crimes: 2001 to Present Links to an external site.
There are two main types of crimes: violent crimes, and property crimes. In this problem, we’ll focus on one specific type of property crime, called “motor vehicle theft” (sometimes referred to as grand theft auto). This is the act of stealing, or attempting to steal, a car. In this problem, we’ll use some basic data analysis in Excel to understand the motor vehicle thefts in Chicago from 2016 to 2021.
Assignment Instructions
Use the Motor Vehicle Theft worksheet and the list of descriptions of the variables to answer the quiz questions.
You may download the file by pushing the button.
Download Motor Vehicle Theft 2016-2021.xls
Here is a list of descriptions of the variables:
ID: a unique identifier for each observation.
Date: the date the crime occurred.
Block: The street location where the crime occurred.
Primary Type: The type of crime – it should all be Motor Vehicle Theft because I filtered to only that type of crime.
Location Description: the location where the crime occurred.
Arrest: whether or not an arrest was made for the crime (TRUE if an arrest was made, and FALSE if an arrest was not made).
Domestic: whether or not the crime was a domestic crime, meaning that it was committed against a family member (TRUE if it was domestic, and FALSE if it was not domestic).
Beat: the area, or “beat” in which the crime occurred. This is the smallest regional division defined by the Chicago police department.
District: the police district in which the crime occurred. Each district is composed of many beats, and are defined by the Chicago Police Department.
Community Area: the community area in which the crime occurred. Since the 1920s, Chicago has been divided into what are called “community areas”, of which there are now 77. The community areas were devised in an attempt to create socially homogeneous regions.
Year: the year in which the crime occurred.
Updated On: When the data for that crime were last updated.
Latitude: the latitude of the location at which the crime occurred.
Longitude: the longitude of the location at which the crime occurred.
please answer these questions. They are 12 intotal
How many elements are in this data set? How many variables are in this data set? What is the maximum value of the variable “ID”? Sort the variable “ID” from lowest to highest. What ID number is in row 45? How many observations have value TRUE in the Arrest variable (this is the number of crimes for which an arrest was made)?
How many observations have a LocationDescription value of ALLEY?
Use the Year variable. In which year did the most crimes occur?
By how much did crimes increase from the year 2019 to 2020?
What is the average number of crimes per year? Round to 1 decimal place.
Create a frequency chart for the number of thefts per year. In general, does it look like crimes increased or decreased from 2016 to 2021?
Use the variables Domestic and Arrest.Domestic means: whether or not the crime was a domestic crime, meaning that it was committed against a family member (TRUE if it was domestic, and FALSE if it was not domestic).
Arrest means: whether or not an arrest was made for the crime (TRUE if an arrest was made, and FALSE if an arrest was not made).
Overall, how many vehicle thefts that were counted as Domestic resulted in an Arrest? In other words, how many crimes had Domestic and Arrest both valued as TRUE?