Using Excel to find blood pressure average?
I record my blood pressure(Systolic / Distolic) & heart rate on a daily basis for many days, for example:
Sys/Dis Heart rate
111/8149
108/8050
105/7948
122/8447
114/7951
I’d like very much to be able to get a collective ave. of the above five days as well as the BP as ???/?? ??.
Have been trying to use a formula but so far unsuccessful. Any help would be greatly appreciated. Thanx.
Tagged with: amp • blood pressure systolic • bp • daily basis • heart rate
Filed under: how to lower blood pressure
just use
=AVERAGE(cells you want to get the average of)
if 111/81 are together in one column your gonna need to split them up so your data would look like
111 81 49
with each number being in a separate column. Then take the the average of each column.
You can have excel split your data for you automatically, or put in a macro to return the data correctly formatted, but if this is just for personal use, it is probably more trouble than its worth.
to display in the format of ???/?? ??
either use
using d21 being the average of the first Sys figure
e21 being the average of the second and
f21 being the average of the heart rate
=CONCATENATE(D21,"/",E21," ",F21)|(to show as text)
or
=D21&"/"&E21&" "&F21 (to display as a number)