Crime rates are indicators of reported crime activity standardized by population. They are more refined indicators for comparative purposes than are volume figures.
A crime rate, defined as the number of offenses per 100,000 population, is derived by first dividing a jurisdiction’s population by 100,000 and then dividing the number of offenses by the resulting figure.
Example:
a. Population for Jurisdiction, 75,000
b. Number of known burglaries for Jurisdiction for a year, 215
Divide 75,000 by 100,000 = .75
Divide 215 by .75 = 286.7
The burglary rate is 286.7 per 100,000 inhabitants.
The number .75 can now be divided into the totals of any offense class to produce a crime rate for that offense. The same procedure may be used to obtain arrest rates per 100,000.
Excel Formula
COLUMN B COLUMN C COLUMN D
ROW 6 75,000 215 =SUM(C6/B6)*100000