Exceedance Days vs the WHO Guideline: COUNTIF, COUNTIFS & the 99th Percentile
This lesson is part of the course
In this lesson
You compare a year of daily PM2.5 means at both Riverton stations with the WHO 2021 24-hour guideline: exceedance days per station, joint exceedances, exceedances in Q1 and the 99th percentile.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Units: ppb ↔ µg/m³ with Molar Mass & Reference Temperature Locked
- Hourly to 24-Hour Means & the 75 % Data-Completeness Rule Locked
- AQI Sub-index: Truncate, Find the Breakpoints & Interpolate Locked
- Overall AQI: Highest Sub-index, Main Pollutant & Category Locked
- Exceedance Days vs the WHO Guideline: COUNTIF, COUNTIFS & the 99th Percentile Locked
- Diurnal Pattern: Mean NO2 by Hour of Day (AVERAGEIFS & Chart) Locked
- Weekday vs Weekend: The Traffic Signature in NO2 Locked
- Emissions Inventory Basics: Activity × Emission Factor Locked