Hourly to 24-Hour Means & the 75 % Data-Completeness Rule
This lesson is part of the course
In this lesson
You turn four days of hourly PM2.5 readings with gaps into daily statistics: valid hours, data completeness, the 24-hour mean and a Valid/Incomplete flag.
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