O
Old Red One
How does one average blood pressure readings? Please give an actual
example, such as 152/65.
example, such as 152/65.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Put each of the blood pressure readings in their own column:
So A2:A999 would hold the top (systolic) reading and
B2:B999 would hold the bottom (diastolic) reading.
Then you could use:
=average(a2:a999) to get the average sytolic
and
=average(b2:b999) to get the average diastolic
So A2:A999 would hold the top (systolic) reading and
B2:B999 would hold the bottom (diastolic) reading.
Then you could use:
=average(a2:a999) to get the average sytolic
and
=average(b2:b999) to get the average diastolic
G
Gord Dibben
To get averages of sistolic(high number) and diastolic(low number) pressures you
would have to have them in separate columns.
You would then take an average of each column.
Sistolic in Column A =AVERAGE(A:A)
Diastolic in Column B =AVERAGE(B:B)
Gord Dibben MS Excel MVP
would have to have them in separate columns.
You would then take an average of each column.
Sistolic in Column A =AVERAGE(A:A)
Diastolic in Column B =AVERAGE(B:B)
Gord Dibben MS Excel MVP
B
Biff
Hi!
Do you mean you want the average of:
152/65
147/72
147/70
If so, split the values into separate cells then it's just a simple
=AVERAGE(.......) formula.
Use Text to Columns to split the values.
Select the range of cells in question, assume A1:A3
Make sure B1:B3 are empty otherwise any data in those cells will be
overwritten.
Goto the menu Data>Text to Columns
Select Delimited
Next
Select Other
In the little box to the right enter a forward slash: /
Click Finish.
Then you can just use the average formula.
Biff
Do you mean you want the average of:
152/65
147/72
147/70
If so, split the values into separate cells then it's just a simple
=AVERAGE(.......) formula.
Use Text to Columns to split the values.
Select the range of cells in question, assume A1:A3
Make sure B1:B3 are empty otherwise any data in those cells will be
overwritten.
Goto the menu Data>Text to Columns
Select Delimited
Next
Select Other
In the little box to the right enter a forward slash: /
Click Finish.
Then you can just use the average formula.
Biff
B
Biff
Just for the heck of it...........
A1 = 152/65
A2 = 147/72
A3 = 147/70
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,FIND("/",A1:A3)-1)))/ROWS(A1:A3),0)&"/"&ROUND(SUMPRODUCT(--(MID(A1:A3,FIND("/",A1:A3)+1,5)))/ROWS(A1:A3),0)
Returns: 149/69
I don't know anything about blood pressures but you can shorten the formula
if the first value is always 3 digits and the second value is always 2
digits:
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,3)))/ROWS(A1:A3),0)&"/"&ROUND(SUMPRODUCT(--(RIGHT(A1:A3,2)))/ROWS(A1:A3),0)
Biff
A1 = 152/65
A2 = 147/72
A3 = 147/70
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,FIND("/",A1:A3)-1)))/ROWS(A1:A3),0)&"/"&ROUND(SUMPRODUCT(--(MID(A1:A3,FIND("/",A1:A3)+1,5)))/ROWS(A1:A3),0)
Returns: 149/69
I don't know anything about blood pressures but you can shorten the formula
if the first value is always 3 digits and the second value is always 2
digits:
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,3)))/ROWS(A1:A3),0)&"/"&ROUND(SUMPRODUCT(--(RIGHT(A1:A3,2)))/ROWS(A1:A3),0)
Biff
O
Old Red One
Biff said:Just for the heck of it...........
A1 = 152/65
A2 = 147/72
A3 = 147/70
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,FIND("/",A1:A3)-1)))/ROWS(A1:A3),0)&"/"&ROUND(SUMPRODUCT(--(MID(A1:A3,FIND("/",A1:A3)+1,5)))/ROWS(A1:A3),0)
Returns: 149/69
I don't know anything about blood pressures but you can shorten the
formula if the first value is always 3 digits and the second value is
always 2 digits:
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,3)))/ROWS(A1:A3),0)&"/"&ROUND(SUMPRODUCT(--(RIGHT(A1:A3,2)))/ROWS(A1:A3),0)
Biff
Many, Many thanks. I got 149/70 but I input A1 as 152/68.
152/68
147/72
147/70
149/70
Did you work up this formula on your own? Again thanks, Buck Jordan.
H
Harlan Grove
Biff wrote...
There's a shorter way to deal with this using array entry.
=ROUND(AVERAGE(INT(SUBSTITUTE(A1:A3,"/","."))),0)&"/"
&ROUND(AVERAGE(--MID(A1:A4,FIND("/",A1:A3)+1,4)),0)
Second value could be over 100, and that's very bad.
Since 110/60,110/60,110/60,200/132 is worse than
125/78,125/78,125/78,125/78, I doubt means are as meaningful as medians
or percentiles if the
Just for the heck of it...........
A1 = 152/65
A2 = 147/72
A3 = 147/70
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,FIND("/",A1:A3)-1)))/ROWS(A1:A3),0)&"/"
&ROUND(SUMPRODUCT(--(MID(A1:A3,FIND("/",A1:A3)+1,5)))/ROWS(A1:A3),0)
There's a shorter way to deal with this using array entry.
=ROUND(AVERAGE(INT(SUBSTITUTE(A1:A3,"/","."))),0)&"/"
&ROUND(AVERAGE(--MID(A1:A4,FIND("/",A1:A3)+1,4)),0)
....Returns: 149/69
I don't know anything about blood pressures but you can shorten the formula
if the first value is always 3 digits and the second value is always 2
digits:
Second value could be over 100, and that's very bad.
Since 110/60,110/60,110/60,200/132 is worse than
125/78,125/78,125/78,125/78, I doubt means are as meaningful as medians
or percentiles if the
H
Harlan Grove
Biff wrote...
There's a shorter way to deal with this using array entry.
=ROUND(AVERAGE(INT(SUBSTITUTE(A1:A3,"/","."))),0)&"/"
&ROUND(AVERAGE(--MID(A1:A4,FIND("/",A1:A3)+1,4)),0)
Second value could be over 100, and that's very bad.
Since 110/60,110/60,110/60,200/132 is worse than
125/78,125/78,125/78,125/78, I doubt means are as meaningful as
percentiles or maximums if the goal is early warning for high blood
preasure.
Just for the heck of it...........
A1 = 152/65
A2 = 147/72
A3 = 147/70
=ROUND(SUMPRODUCT(--(LEFT(A1:A3,FIND("/",A1:A3)-1)))/ROWS(A1:A3),0)&"/"
&ROUND(SUMPRODUCT(--(MID(A1:A3,FIND("/",A1:A3)+1,5)))/ROWS(A1:A3),0)
There's a shorter way to deal with this using array entry.
=ROUND(AVERAGE(INT(SUBSTITUTE(A1:A3,"/","."))),0)&"/"
&ROUND(AVERAGE(--MID(A1:A4,FIND("/",A1:A3)+1,4)),0)
....Returns: 149/69
I don't know anything about blood pressures but you can shorten the formula
if the first value is always 3 digits and the second value is always 2
digits:
Second value could be over 100, and that's very bad.
Since 110/60,110/60,110/60,200/132 is worse than
125/78,125/78,125/78,125/78, I doubt means are as meaningful as
percentiles or maximums if the goal is early warning for high blood
preasure.
B
Biff
There's a shorter way to deal with this using array entry.
I thought about using an array AVERAGE, although I didn't think about using
INT(SUBSTITUTE(A1:A3,"/",".")).
Very clever!
Biff
=ROUND(AVERAGE(INT(SUBSTITUTE(A1:A3,"/","."))),0)&"/"
&ROUND(AVERAGE(--MID(A1:A4,FIND("/",A1:A3)+1,4)),0)
I thought about using an array AVERAGE, although I didn't think about using
INT(SUBSTITUTE(A1:A3,"/",".")).
Very clever!
Biff
B
Biff
Old Red One said:Many, Many thanks. I got 149/70 but I input A1 as 152/68.
152/68
147/72
147/70
149/70
Did you work up this formula on your own? Again thanks, Buck Jordan.
This is a hobby for me!
Thanks for the feedback.
Biff
G
GSalisbury
I happen to have workbook for this exact task.Old Red One said:How does one average blood pressure readings? Please give an actual
example, such as 152/65.
It's self-contained Excel97 - no macros.
You can enter up to four sets readings (high/low/pulse) across a line and
each line is a day.
The date and times rounded to nearest five minutes are automatically posted.
The min, maxes and averages are all automatically calculated.
I'd be happy to send it to you as an example.
Geo. Salisbury
O
Old Red One
GSalisbury said:I happen to have workbook for this exact task.
It's self-contained Excel97 - no macros.
You can enter up to four sets readings (high/low/pulse) across a line and
each line is a day.
The date and times rounded to nearest five minutes are automatically
posted.
The min, maxes and averages are all automatically calculated.
I'd be happy to send it to you as an example.
Geo. Salisbury
It would be most interesting to see;lease do send it. Is it your own work?
Please also give your correct e-mail address. Thanks, Buck Jordan.
[email protected].
G
GSalisbury
Yes it is my own construction but I did get some good pointers here in thisOld Red One said:It would be most interesting to see;lease do send it. Is it your own work?
Please also give your correct e-mail address. Thanks, Buck Jordan.
[email protected].
NG.
I was working on the date aspect, for example, and someone else posted a
rounding dates query in Nov, 2005 and Bob Phillips posted a perfect reply
which I was able to adapt for my needs. Also, at that same time, I posted a
request for help resolving a "circular reference..." issue and Peo Sjoblom
provided a pointer to a Tools>Options>Calculation Iteration check box which
was exactly the fix for my situation.
News Groups rule!
My e-mail is pretty much as my header says: salsburyg at comcast dot net.
Substitute the "at" for an at-sign "@" and the "dot" for a dot "." and
remove all spaces of course.
I'd appreciate a critique.
Thx
Geo. S.
B
bplumhoff
Hello,
Another one:
=ROUND(AVERAGE(--REPLACE(A1:A3,FIND("/",A1:A3),9,"")),0)&"/"&ROUND(AVERAGE(--REPLACE(A1:A3,1,FIND("/",A1:A3),"")),0)
But this is a little bit slower than Biff's (quickest) and Harlan's
solution.
Regards,
Bernd
Another one:
=ROUND(AVERAGE(--REPLACE(A1:A3,FIND("/",A1:A3),9,"")),0)&"/"&ROUND(AVERAGE(--REPLACE(A1:A3,1,FIND("/",A1:A3),"")),0)
But this is a little bit slower than Biff's (quickest) and Harlan's
solution.
Regards,
Bernd