Problem Assignment

Step 1: open the January.xls, go to the Step1 sheet and sort by premise. This should give you a list of offenses, starting with premise code 106. Data analysis sorting 154–165. 

Step 2: go to the Step 2 sheet and sort by DOW. Next, go to the Data Subtotal menu. At the Subtotals menu, you will be prompted to fill information in three areas. The first area will be each change in DOW. The second area will be Function: choose Count. The third area needs to have DOW checked. This will give you the total number of crimes by each day of the week.

Step 3: go to the Step 3 sheet and conduct a subtotal of the average age of the victim (C_Age) by watch. Hint: sort by watch, then conduct your subtotals using the average function for age at every change of the watch.

Step 4: go to the Step 4 sheet and create a custom list for "Murder," "Rape," Robbery," "Agg. Assault" and "Other Sex." Sort the Crime column in ascending order. Remember, the custom list should be created under Tools/Options/Custom Lists.