Exceedance Days vs the WHO Guideline: COUNTIF, COUNTIFS & the 99th Percentile
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Units: ppb ↔ µg/m³ with Molar Mass & Reference TemperatureFree
- Hourly to 24-Hour Means & the 75 % Data-Completeness Rule Pro
- AQI Sub-index: Truncate, Find the Breakpoints & Interpolate Pro
- Overall AQI: Highest Sub-index, Main Pollutant & Category Pro
- Exceedance Days vs the WHO Guideline: COUNTIF, COUNTIFS & the 99th Percentile Pro
- Diurnal Pattern: Mean NO2 by Hour of Day (AVERAGEIFS & Chart) Pro
- Weekday vs Weekend: The Traffic Signature in NO2 Pro
- Emissions Inventory Basics: Activity × Emission Factor Pro