Down and outlier
Imagine you're a public safety official trying to reduce the number of injuries due to car crashes. You want to know how frequently car crashes result in injuries. You've already made some predictions, but you want to see where your predictions are going wrong. You'll do some counting and filtering to address any outliers you find.
Four reminders:
- Recall that the
UNIQUE()function returns a list of unique values for a given row or column. This will help you summarize the data. - The
SORT()function can be used to sort the values of a given range/array (in ascending order by default). - The
COUNTIF()function is helpful for counting cells that meet certain criteria. - Remember that absolute deviation refers to the difference between your prediction and the actual value.
This exercise is part of the course
Error and Uncertainty in Google Sheets
Exercise instructions
- Edit cell
G2to sort the list of unique values in ascending order. - In cell
H2, count the number of times your prediction matched the actual value (i.e., 0 absolute deviation).- To do this, you will need to count the rows where the deviation you calculated in
G2appears in the columnE.
- To do this, you will need to count the rows where the deviation you calculated in
- In cells
H3:H10, count the number of rows for each respective absolute deviation. - In cells
I2:I10, calculate percentages (i.e., frequencies) by dividing these counts by the total number of crashes.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise