Week 4 Project
Assignment Due May 24 at 11:59 PM
Week 4 Project: Using Minitab 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 Minitab 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 graphic 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 Minitab 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 Minitab including standard demographic variables comparing victimization rates by age and gender between the two years.
- Use the data in your Minitab table to select a graph and prepare a chart to support your hypothesis. Present your Minitab 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.
Name your document SU_MCJ5100_W4_A2_LastName_FirstInitial . Submit your document to the Submissions Area by the due date assigned. Cite sources in APA format on a separate page.
Project Resources
Step-By-Step Instructions Open the instructions on how to use the data set in Minitab for this project.
Sample Data NVAT Report Use this Data Set to complete this project.
MCJ5100 W4A2: Step-by-Step instructions on how to get the dataset
The following series of screen shots show how to find the data set used in this exercise. For the purpose of this assignment, we will only use part of the date. This data is provided in the Excel Spreadsheet towards the end of this document.
1. Go to:
http://www.bjs.gov/index.cfm?ty=nvat
2. Choose the year range and other variables as shown.
Click on the Excel button on the top right hand of this screen to export the date to Excel spreadsheet.
For the purpose of our assignment, we will only use the overall Violent Victimization data (and not the sub-categories)
Choose the data up until Row 35 and use the copy paste function to put the data in excel spreadsheet as shown below.
The data has been provided in the Excel Spreadsheet attached.
Next we will look at how to work in Minitab.
Working in Minitab
Now that you have your data, enter the sample data in Minitab. You can use the copy past function from Excel and Minitab to populate the worksheet as shown below:
Bar Graph
2012-2013 Males by age category and annual total of Violent Victimization
Pie Chart
From the Graph menu select Pie Chart to get the following execution window, select Chart values from a table
Select Categorical variable and Summary variables
Explanation of Results: The information in the charts shows both the age and gender of Violent Victimization victims in 2012 and 2013. These charts represent findings males were higher victims of violent victimization in 2012 between the ages of 18-20, 35-40 and 65 and older.
Binominal Distribution using Scatter Plot
Enter Y and X variables and categorical variables for grouping (0-3)
Results: If your Minitab is set to separate graphs you get the following. To show all on one graph go to the next slide
To show information on one graph, select Multiple Graphs, then Overlaid on the same graph
Scatterplot
Explanation of Results: hypothesis that being male and less than 25 years of age increases the likelihood of being Violent Victimization victims. Based on the data provided this hypothesis is not proven. Male victims between the ages of 18-20, 35-40 and 65 and older are much more likely to be victims of a Violent Victimization.
Sample
Data_NVAT_Report.xlsx
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-24 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
Sheet2
Sheet3
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 | ||||||||||||