Homework 6: Terry Stop, Analysis of Office Race and Initial Call Type.

Analyze two text fields in the Terry Stop data.

The goals of this homework are:

Instructions

Continue to work with the Terry stop worksheet from the last homework assignment. If you have not saved this worksheet you can start with this data.
  1. Create a worksheet to analyze the Officer Race field.
  2. Perform basic counts on the Officer Race field.
  3. Analyze the frequency of each race given.
  4. Provide a Pie chart exploring this data.
  5. Start a new worksheet for the analysis of the initial call type.
  6. Perform basic counts on the initial call type field.
  7. Analyze the frequency of each call type
  8. Provide some form of chart to represent the top ten known stop types.
  9. Provide a summary table of the number of incidents which occurred less than 10 times.
  10. (This is worth 20% of the homework score) Using word, provide an analysis of the Office Race and the Initial Call Type fields.

Submit

Please submit both your word document and your worksheet to the D2L Assignment folder Homework 6 by the due date.