Blood Pressure Data Analysis: Home Readings, Averages, Categories & Trends

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• 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.
• Average a 7-day home-monitoring protocol by session, leave out the first day like many protocols do, and measure the morning–evening difference.
• Derive two numbers from every reading, the pulse pressure and the mean arterial pressure, average them and count the readings with a wide pulse pressure.
• Look up a level for the systolic and for the diastolic value in two threshold tables, take the higher one and turn it into a category name.
• Condense six weeks of readings into weekly means, measure the trend in mmHg per week with SLOPE and chart both lines.
• Measure how much the morning readings swing: the standard deviation, the coefficient of variation, the range and the average change from one day to the next.
• 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.
• Turn two weeks of readings into a one-screen summary: readings per category, the mean as SYS/DIA, a rule that highlights the highest readings and a column chart.