Cleaning a Home-Reading Log: Duplicates & Implausible Values
This lesson is part of the course
In this lesson
You flag the readings an app synced twice, mark implausible values with limits kept in cells, count the clean readings and see how much the cleaning changes the mean.
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