Indagación estadística de vehículos involucrados en incidentes de apropiación ilícita en el Distrito Metropolitano de Quito período 2020-2023

Abstract

This statistical analysis focuses on the illicit appropriation of vehicles in the Metropolitan District of Quito during the period 2020-2023, addressing concerns about citizen security with the purpose of detecting patterns, trends and factors associated with said crime. The research is supported by a reliable data set; because it comes from a reputable source that remains confidential, providing a context to understand the factors related to the illicit appropriation of vehicles. The retrospective observational quantitative methodology is based on police records and is processed using the tools: Excel and Power BI. A descriptive analysis was performed, highlighting findings such as consistency in the number of vehicles stolen per incident and preference. Under these criteria; It was found that the preferred vehicle brand was Chevrolet. The temporal analysis highlights the concentration of robberies in 2022, while the spatial analysis identifies Calderón and Carapungo as the areas with the highest incidence. A relationship is revealed between population density and the frequency of robberies, highlighting the influence of socioeconomic factors. Data cleaning is necessary the integrity of the results, highlighting the importance of the quality of information in statistical analyses. The study concludes underscore of considering multivariable relationships to understand the dynamics of vehicle theft, providing a perspective for preventive strategies and security policies considering to the specific context of Quito.