Excell
Students must utilize international criminal justice data set to complete exercises: organizing the data, conducting descriptive and inferential statistics, and presenting data and results in tables, graphs and charts in Excel.
LAB ASSIGNMENT 2: VISUAL PRESENTATION OF THE DATA
NAME: ____________________________________
Use the data from the Eurostat, data set: EUROSTAT CRIME COUNTRIES & EUROSTAT HOMICIDE CITIES
Please review handout 3 attached for more detail and John Jay College of Criminal Justice Library for article review
1. A researcher is interested in finding out how the number of intentional homicide changed over the years (2009-2018) in Poland. Present visually the trend of homicide. Use the number/raw data. How the number of intentional homicide changed over the years?
2. A researcher is interested in comparing trends in theft over the years (2009 – 2018) between Norway and Sweden. Use the number/raw data to compare visually the trends and briefly describe them.
3. The United Kingdom is made up of four countries: Scotland, Wales, England, and Northern Ireland. Present visually proportions of assault in Scotland, England and Wales, and Northern Ireland in 2018. Present the results in percentage (%), assuming all four countries constitute together 100 percent (%).
4. Calculate: mean, mode and median for the number of homicide in capital city of Lithuania between 2009 and 2018.
5. Calculate: mean, mode and median for the number of homicide in capital city of Estonia between 2009 and 2018. Compare results of 4 and 5.
Email your calculations and results in EXCEL. The answers to questions you can provide on EXCEL file or on a separate MW file. Your assignment is due by 11/9 (THURSDAY).
Please also view YOUTUBE: Excel 2 for more info.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.