09 Nov 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.
