To Address the Concern Regarding Use of Force by Police

To address the concern regarding use of force by police officers, the local police department decided to offer (mandatory) "use of force training" to officers who fall into the upper 30% of the frequency of overall force used by individual officers (in 2015).
a. Compute the mean.
b. Compute the standard deviation.
c. Compute the z score.
d. Indicate the area under the normal curve (AUC) listed in the z-score table.
e. Indicate the percent ranking for each police officer.
f. List the officer IDs of the individuals who will be required to attend the "use of force training."
$$\begin{array} { | c | c | } \hline \text { Officer ID } & \begin{array} { c } \text { No. of } \\\text { incidences/use of } \\\text { force/2015 }\end{array} \\\hline 5556 & 26 \\\hline 5557 & 36 \\\hline 5558 & 15 \\\hline 5559 & 58 \\\hline 5560 & 12 \\\hline 5561 & 29 \\\hline 5562 & 17 \\\hline 5562 & 41 \\\hline 5562 & 9 \\\hline 5563 & 47 \\\hline 5564 & 12 \\\hline 5565 & 25 \\\hline 5566 & 51 \\\hline 5567 & 43 \\\hline 5568 & 22 \\\hline\end{array}$$