Prepare a minimum 15-page agency report that analyzes issues confronted in a police department setting. Please check the Final Report Rubric in the syllabus and read the instructions below. You are a data analyst in the Police Department of Formdale (imaginary city), California. The 2020 Census census had the city population at 124,564. Your task is to write an report that includes the most important crime and department-related statistics. You don’t need to use all available data. It’s up to you what you pick for the report. You can use any technique we learned during the semester. You are free to clean, recode or collapse variables to make them more suitable for the analysis. Use academic articles to support your argument. You can find a list of recommended articles in Course Materials. The min 15-page report should have 7 main sections: Executive summary (1 page) Introduction (1 page) Department characteristics, workforce demographics (4 pages) Crime statistics in Formdale (4 pages) Community Engagement (4 pages) Conclusions & Recommendations (1 pages) Reference List (APA Style) Create multiple charts and tables to summarize and visualize your data. Each chart/table should be interpreted in text. Analyze trends if data are available for multiple years. Create charts in Excel and copy-paste them to your main Word document. Submit only your final report as a Word or PDF file (no need for your background Excel sheets). Google other police department reports to get some ideas. But don’t copy their exact structure because they typically usee long PR narratives to describe and advertise the department. Your focus should be on data and facts. USE THE FILES ATTACHED FOR REPORT DONT HAVE TO USE IT ALL ALONG WITH ANY OF THESE ARTICLES. Recommended articles for the Final Report Seasonal Cycles in Crime - Dong, K., Cao, Y., Siercke, B., Wilber, M. & McCalla, S. G. 2017. Advising caution in studying seasonal oscillations in crime rates. Plos One - McDowall, D., Loftin C. & Pate, M. 2012. Seasonal cycles in crime, and their variability. Journal of Quantitative Criminology, 28: pp. 389-410. - Uittenbogaard, A. & Ceccato, A. 2012. Space-time clusters of crime in Stockholm, Sweden. Review of European Studies, 4, 5, pp. 148-155. Promotion of Female Police Officers & Diversity in Policing - Archbold, C. A. & Schulz, D. M. 2008.Making Rank - The lingering effects of tokenism on female police officers’ promotion aspirations. Police Quarterly, 11, 1, pp. 50-73. - Archbold, C. A. & Hassell, K. D. 2009. Paying a marriage tax - An examination of the barriers to the promotion of female police officers. Policing: An International Journal of Police Strategies & Management, ,32, 1, pp. 56-74. - Guajardo, S. A. 2015. New York City Police Department downsizing and its impact on female officer employment, Journal of Ethnicity in Criminal Justice, 13, pp. 255-282. - Morabito, M. S. & Shelley, T. O. Constrained agency theory and leadership: A new perspective to understand how female police officers overcome the structural and social impediments to promotion. Feminist Criminology, 13, 3, pp. 287–308. - Prenzler, T. & Sinclair, G. 2013. The status of women police officers: An international review. International Journal of Law, Crime and Justice, 41, pp. 115-131. - Richard H. & Donohue Jr. R. 2020. Shades of Blue: A review of the hiring, recruitment, and selection of female and minority police officers. The Social Science Journal - Ba, B. A., Knox, D., Mummolo, J. & Rivera, R. 2021. The role of officer race and gender in police-civilian interactions in Chicago. Science, 371, 6530, pp. 696-702. - Silvestri, M. & Tong, S. 2020. Women police leaders in Europe: A tale of prejudice and patronage. European Journal of Criminology - van Ewijk, A. R. 2011. Diversity within police forces in Europe: A case for the comprehensive View. Policing, 6, 1, pp. 76–92. - Wilson, F. T. & Blackburn, A. G. 2014. The depiction of female municipal police officers in the first four fecades of the core cop film genre: “It's a man's world. Women & Criminal Justice, 24, 2, pp. 83-105. Police Legitimacy & Procedural Justice - Jackson, J. & Bradford, B. 2019. Measuring public attitudes towards the police. Technical Report, Prepared for: Public Safety Canada - Tyler, T. R. 2004. Enhancing police legitimacy. The Annals of the American Academy of Political and Social Science, 593, pp. 84-99.