Random Samples with Excel

Step by Step instructions Download Practice Workbook   Excel has a simple formula we can utilize to obtain a random sample (e.g., cases, citations, city, etc.)   Some agencies can run a case management report that generates the following information: case #, assigned date, assigned investigator, crime category, city and case status.   If we want to obtain a random …

Subtotals with Excel

The video demonstrates how to use the Subtotal Function in Excel to: Assume you have a list of case numbers assigned to a specific detective, precinct, district, city, etc. Use the Subtotal function to quickly add data and get case totals by detective, precinct, district, city, etc. The Subtotal function will provide an overall count for each category (e.g.,  detective, …

Pivot Tables for Case Assignments

The video demonstrates how to use pivot tables in excel to: Determine the total number of cases assigned to detective/s Sort by the number of cases assigned to a detective by month Determine the total number of cases assigned to a group of detectives BY CONSULTING ANALYST, MAYRA LOPEZ