NOTE to the writer: there are 3 files uploaded and ZIP file is the data for writing the report and there is a sample report .###Project_description.pdfYour assignment is to complete a report for your Chief Constable on last years crime trends. The Chief is very busy, so only the most important and relevant information should be included. You will want to include SOME graphs, maps and tables, but DO NOT leave it to the Chief to interpret them it is up to you to explain what they mean and why they are important. Begin by looking at your data from many angles. Some questions to ask and start analyzing: 1. Are there any hot spots/hot places in the data? If so, present them in an appropriate form (tables, charts, graphs) as you see fit. 2. Are there any temporal (time, days, months, etc.) trends in the data? If so, present them in an appropriate form (tables, charts, graphs) as you see fit. 3. If you were the local analyst, what would be your next step with respect to analysis? Are there any prevention opportunities available to you based on the data? What would you present to the Chief Constable if he/she asked to know everything about your chosen crime type in the data? The data may represent any type of crime you wish. Your final report should be written up in Word, with the appropriate tables, charts and graphs included with the text in a memo to the Chief Constable. You may refer to this document for some ideas on how to appropriately incorporate your description of the problem with applicable graphs and maps: http://vancouver.ca/police/assets/pdf/statistics-reports/report-2008-2010-sex-assaults.pdf Please also remember the tips and tricks surrounding your tables, charts and graphs. Your report should be clean, clear, and easy to read. It should contain actionable and PRIORITIZED information do NOT simply paste everything you can onto the page for the Chief you must do your job as an Analyst and only include that information which is the MOST RELEVANT and that the Chief MUST SEE.Basics: 6 (min) pages (this includes charts and graphs, so again, prioritize your information) 11 or 12 point font, 1 margins (ensure your graphs, charts and tables adhere to the margins) Saved in PDF from Word (Save As, PDF) Use Template provided ** YOU MUST ALSO SUBMIT YOUR EXCEL FILE, AND I WILL BE LOOKING FOR YOUR USE OF FORMULAS AND CLEAR ANALYSIS OF THE DATA!**###Extra info:Data Files (crime data)Data can be downloaded from the following link:https://geodash.vpd.ca/opendata/ Suggested Steps1. Clean your data (Excel)a. Make new time fieldb. Clean any date fields that need it 2. Snoop around your dataa. Using pivot tables (or whatever you like), check out:i. Times of crimesii. Dates of crimesiii. Days of the weekiv. Seasons!v. Are certain crimes happening on certain dates/times/seasons?vi. Are certain addresses popping up more often?vii. Are the years different?viii. What about crime around holidays? Special Events (Olympics)? 3. Get an idea of what youd like to focus ona. A certain crime type?b. Comparison of two crime types? (e.g., auto theft vs. burglary, etc.)c. Comparison of seasons?d. Weekend vs. weekday crimes?e. Daytime vs. nighttime crimes?f. Or are you interested more in something totally different?g. DO NOT ANALYZE ALL OF THE DATA YOU MUST CHOOSE SOMETHING SMALLER AND MORE MANAGEABLE THAT MAKES SENSE! 4. Work your way back through the weekly modules to do the analysis. 5. Write up your results!
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]