MCJ5100_W4A2_Screenshots.docx

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