Outliers

Error and Uncertainty in Google Sheets

Evan Kramer

Instructor

Defining risk

  • Exposure to danger
    • Likelihood
      • How frequently occurring
    • Consequences
      • Severity
  • Example: earthquakes
    • Rare
    • Severe

Likelihood-consequence matrix for assessing risk

Error and Uncertainty in Google Sheets

Defining outliers

  • Outside normal range

    • Skew data
    • Low likelihood
    • (Potentially) severe

  • Examples

    • Home prices
    • Website hits

Scatterplot with outliers in website hits circled

Error and Uncertainty in Google Sheets

SORTing outliers

  • SORT() function
    • range: Cells to sort
    • sort_column: Column to sort by
    • is_ascending: Whether to sort low to high

Scatterplot with outliers in website hits circled

Error and Uncertainty in Google Sheets

FILTERing outliers

  • FILTER() function
    • range: Cells to filter
    • condition1: Filter to apply
      • >, <=, etc.
      • A2:A20 = "WEST"

Scatterplot with outliers in website hits circled

Error and Uncertainty in Google Sheets

Data table of Nashville car crashes by precinct

Error and Uncertainty in Google Sheets

Let's practice!

Error and Uncertainty in Google Sheets

Preparing Video For Download...