A likely story

You have estimated the severity of the consequences, but you still need to calculate the likelihood of the event occurring to measure risk. This will help you make decisions about which precinct is the riskiest place to drive (and consequently which one could use more support).

To calculate how likely crashes are in each region, you'll want to divide the number of crash-related injuries in the precinct by the number of vehicles involved in crashes. After calculating likelihood and consequences, you can use the matrix described in the video to calculate total risk to determine which precinct needs the most help.

Remember that the SUMIF() function is useful for summing up only the events that meet certain criteria. Remember to specify the range to check, the criterion, and the range to sum.