Running Means & Decadal Averages for Noisy Precipitation
This lesson is part of the course
In this lesson
You smooth 30 years of annual precipitation with a 5-year centred running mean, compare decadal averages with AVERAGEIFS and find the wettest 5-year period.
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