Diurnal Pattern: Mean NO2 by Hour of Day (AVERAGEIFS & Chart)
This lesson is part of the course
In this lesson
You extract the hour from two weeks of hourly roadside NO2 readings, average every hour of the day, find the peak hour and chart the daily cycle.
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