Blood Pressure Data Analysis: Home Readings, Averages, Categories & Trends
Clean a home-monitor log, average morning and evening readings with AVERAGEIFS, derive pulse pressure and mean arterial pressure, classify every reading with threshold tables, measure the weekly trend with SLOPE, quantify variability, compare clinic and home averages and build a summary for a doctor's visit: 8 graded labs on one fictional person's synthetic readings. Educational only, not medical advice.
The first lesson is free — no account needed.
About this course
A blood pressure data course that analyses one fictional person's synthetic home-monitor readings in a spreadsheet, for people who track their own readings, carers, nursing and health science students and health data analysts. You clean a home-reading log of duplicate syncs and implausible values, average morning and evening readings with AVERAGEIFS and leave out the first day as many protocols do, derive pulse pressure and mean arterial pressure, give every reading a category with threshold tables and an approximate lookup, condense six weeks into weekly means and measure the trend with SLOPE, quantify variability with the standard deviation, CV and average real variability, compare clinic and home averages for white-coat and masked patterns, and build a one-screen summary with a chart for a doctor's visit. Synthetic readings and illustrative thresholds, guidelines differ by region. Educational only, not medical advice. The first lab is free.
Lessons
- Cleaning a Home-Reading Log: Duplicates & Implausible ValuesFree
- Morning vs Evening Averages with AVERAGEIFS Pro
- Mean Arterial Pressure & Pulse Pressure Pro
- A Category for Every Reading: Threshold Tables & Approximate Lookup Pro
- Weekly Averages & the Trend: AVERAGEIFS, SLOPE & a Line Chart Pro
- Variability: Standard Deviation, CV, Range & Average Real Variability Pro
- Clinic vs Home: White-Coat & Masked Patterns Pro
- A Summary for the Doctor's Visit: Counts per Category, a Highlight Rule & a Chart Pro