Daily to Monthly: AVERAGEIFS, SUMIFS & Wet Days
This lesson is part of the course
In this lesson
You turn 59 days of station readings into monthly statistics: the month of each date, the daily mean temperature, the monthly mean, the monthly precipitation total and the number of wet days.
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
- Daily to Monthly: AVERAGEIFS, SUMIFS & Wet Days Locked
- Temperature Anomalies vs the 1991–2020 Baseline Locked
- Linear Trend per Decade: SLOPE × 10 & a Trendline Locked
- Heating & Cooling Degree Days Locked
- Extremes: Hot Days, Tropical Nights & the Longest Dry Spell Locked
- Running Means & Decadal Averages for Noisy Precipitation Locked
- Return Periods: Ranking Annual Maxima with the Weibull Formula Locked
- Unit Conversions & a Simple Heat Index Locked