AQI Sub-index: Truncate, Find the Breakpoints & Interpolate
This lesson is part of the course
In this lesson
You convert ten daily PM2.5 means into US AQI values: truncate the concentration, find its breakpoint row with MATCH, read the category and interpolate the index linearly.
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