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

The goals of this homework are:

• Practice analysis of text fields.

Instructions

1. Create a worksheet to analyze the Officer Race field.
   • Correctly label this worksheet
   • Add an appropriate comment to the top of this worksheet.
2. Perform basic counts on the Officer Race field.
   • 
3. Analyze the frequency of each race given.
   • Produce a unique list of officer races.
   • Compute the number of times each race was involved in a Terry Stop.
   • Sort these by frequency.
   • Format the counts as numbers, with no decimal points and a comma when appropriate.
   • 
4. Provide a Pie chart exploring this data.
   • Make sure that this chart is well labeled and readable.
   • 
5. Start a new worksheet for the analysis of the initial call type.
   • Correctly label this worksheet
   • Add an appropriate comment to the top of this worksheet.
6. Perform basic counts on the initial call type field.
   • NULL is a term for not available. Replace this with NA and perform the appropriate counts.
7. Analyze the frequency of each call type
   • Produce a unique list of the different initial call types.
   • Count the number of initial call types.
   • Format the numbers with no decimal places and a comma if needed.
   • Add a rank field, that computes the rank 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