Weekly Averages & the Trend: AVERAGEIFS, SLOPE & a Line Chart
This lesson is part of the course
In this lesson
You condense six weeks of readings into weekly means, measure the trend in mmHg per week with SLOPE and chart both lines.
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
- Cleaning a Home-Reading Log: Duplicates & Implausible Values Locked
- Morning vs Evening Averages with AVERAGEIFS Locked
- Mean Arterial Pressure & Pulse Pressure Locked
- A Category for Every Reading: Threshold Tables & Approximate Lookup Locked
- Weekly Averages & the Trend: AVERAGEIFS, SLOPE & a Line Chart Locked
- Variability: Standard Deviation, CV, Range & Average Real Variability Locked
- Clinic vs Home: White-Coat & Masked Patterns Locked
- A Summary for the Doctor's Visit: Counts per Category, a Highlight Rule & a Chart Locked