Clinic vs Home: White-Coat & Masked Patterns
This lesson is part of the course
In this lesson
You average the clinic readings the way many protocols do, compare them with the home mean, flag each against its own threshold and name the pattern with nested IF.
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