Smoothing: Moving Average vs Raw Noise (with a Chart)
This lesson is part of the course
In this lesson
You smooth 5-minute readings with a 30-minute moving average, compare how many raw values and how many averages cross the alarm limit and chart both.
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
- Timestamps & Sampling Intervals: Finding the Gaps Locked
- Resampling to Hourly Averages with HOUR & AVERAGEIFS Locked
- Threshold Excursions: Count, Minutes & the Longest Excursion Locked
- Sensor Uptime & Data Completeness % Locked
- Calibration Drift vs a Reference Sensor: SLOPE & FORECAST Locked
- Smoothing: Moving Average vs Raw Noise (with a Chart) Locked
- Alert Rules with Hysteresis: ON above X, OFF below Y Locked
- Compliance Report: Daily Status, Time in Range, MKT & a Chart Locked