12 Feb Using Microsoft Excel to Test Data Sets
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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.