graph

profilemzpepper504

  

Graphs represent data in an engaging manner and make comparisons and analyses easier. For example, a graph depicting the number of crimes committed each year over a decade is easier to comprehend visually than reading the numerical values for each year. Before creating a graph, however, it is important to choose one that appropriately represents the data. A histogram, rather than a pie chart, is appropriate for depicting the age groups (e.g., 15–24, 25–34) of murder victims in a city. Histograms are designed to be used with variables that are categorized, but pie charts plot each value. Therefore, it would be easier to read a histogram showing bars for age groups of murder victims than a pie chart in which every single age would have to be plotted. In the past, creating graphs was cumbersome and time consuming, but present-day software programs such as Microsoft Word and Excel provide tutorials that walk you through the process. With knowledge of these software programs, you can create customized charts and figures to represent your research data in visually interesting ways. In this Assignment, you create at least two different graphs in Excel or Word that can be used to illustrate hypothetical data related to six incidents of crime.

· Create at least two different graphs in Excel or Word using the data provided in the table below:      


   

Type of Crime


Offender’s Age
   (Years)


Offender’s Gender


Time of the Incident

 

Theft


22


Male


Early morning

 

Possession of drugs


21


Female


Late evening

 

Theft


19


Male


Late evening

 

Theft


33


Female


Afternoon

 

Possession of drugs


47


Female


Morning

 

Possession of drugs


17


Male


Early morning

· Briefly describe the data represented in the graphs and/or charts you created.

· Explain why the graphs and/or charts you created best represent the data compared to other options. Be specific.

Submit the graphs you created in a document that is separate from your written Assignment.

Bachman, R. D., & Schutt, R. K. (2019). The practice of research in criminology and criminal justice (7th ed.). Thousand Oaks, CA: SAGE Publications.

· Chapter 4, “Conceptualization and Measurement” (pp. 86–116)

The Practice of Research in Criminology and Criminal Justice, 7th Edition by Bachman, R. D. & Schutt, R. K. Copyright 2019 by SAGE Publications, Inc. Reprinted by permission of SAGE Publications, Inc via the Copyright Clearance Center.

Bachman, R. D., & Schutt, R. K. (2019). The practice of research in criminology and criminal justice (7th ed.). Thousand Oaks, CA: SAGE Publications.

· Chapter 14, “Analyzing Quantitative Data” (pp. 404–415 and 426–444)

The Practice of Research in Criminology and Criminal Justice, 7th Edition by Bachman, R. D. & Schutt, R. K. Copyright 2019 by SAGE Publications, Inc. Reprinted by permission of SAGE Publications, Inc via the Copyright Clearance Center.

Trochim, W. M. K. (2006). Levels of measurement. In Research methods knowledge base. Retrieved from http://www.socialresearchmethods.net/kb/measlevl.php

Walden University: Academic Skill Center. (n.d.). ASC software assistance: Microsoft Excel. Retrieved March 15, 2019, from https://academicguides.waldenu.edu/ASCsoftware/msoffice/excel

Microsoft Office Online. (n.d.). Excel help center. Retrieved March 30, 2019, from https://support.office.com/en-us/excel

Navigate to the tables and charts section of this page to access the applicably level of training you may need for creating charts and graphs in Excel.


Lynda.com. (2019). Excel: Introduction to charts and graphs. Retrieved from https://www.lynda.com/Excel-tutorials/Excel-Introduction-Charts-Graphs/802837-2.html

Lynda.com. (2018). Excel 2019 essential training. Retrieved from https://www.lynda.com/Excel-tutorials/Excel-2019-Essential-Training/728368-2.html

Lynda.com. (2016). Excel 2016 essential training with Dennis Taylor. Retrieved from https://www.lynda.com/Excel-tutorials/Excel-2016-Essential-Training/376985-2.html

  • 4 years ago
  • 15
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    graphtable.docx
  • attachment
    graph.xlsx