# Week 4 Project: Using Microsoft Excel to Test Data Sets This…

Week 4 Project: Using Microsoft Excel to Test Data Sets This…

Week 4 Project: Using Microsoft Excel to Test Data Sets
This week’s chapter readings included discrete probability distributions, which included a section on binominal distributions. Now you will apply this learning by testing a hypothesis based on your research topic using binominal distribution. In this assignment you will use Microsoft Excel software to compare 2012 National Crime Victimization (NCVS) data and 2013 National Crime Victimization (NCVS) data on violent crime.
Project Resources: (Access by clicking the links below for resources)

Step-by-step Instructions
Data Set from the Bureau of Justice Statistics

In Week 2, you learned how to make graphs. For this assignment you will continue to apply this learning to create graphs to support your work. You are encouraged to try different types of graphs and show all your work. On the basis of your comparison of 2012 and 2013 NCVS data, use what you have learned to enter data in Microsoft Excel software to:

Incorporate NCVS crime data and test a hypothesis based on your research topic on a binomial distribution as described in this week’s chapter readings. For example, you could test the hypothesis that being male and less than 25 years of age increases the likelihood of being the victim of a homicide.
Use the NCVS data to build a table in Microsoft Excel including standard demographic variables comparing victimization rates by age and gender between the two years.
Use the data in your Microsoft Excel table to select a graph and prepare a chart to support your hypothesis. Present your Microsoft Excel spreadsheet as a table in a Microsoft Word document.
Based on your readings analyze your findings for male and female victims creating charts from the data in your table to support your findings.

Sheet1

Year
M 12-14
M 15-17
M 18-20
M 21-24
M 25-34
M 35-49
M 50-64
M 65 or Older
F 12-14
F 15-17
F 18-20
F 21-24
F 25-34
F 35-49
F 50-64
F 65 or Older

2012
503294
214582
313483
329238
762630
1018092
458047
109067
259795
233718
278741
335999
672533
771891
453933
127551

2013
529511
203214
186244
262328
653813
628011
513163
69685
285419
286563
279457
309610
603866
611214
637688
66639

essaysresearch.org 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.
Why Hire essaysresearch.org 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.

Source link

Rate this post