How does one average blood pressure readings? Please give an actual
example, such as 152/65.

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



Old Red One wrote:
>
> How does one average blood pressure readings? Please give an actual
> example, such as 152/65.

--

Dave Peterson

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


On Mon, 24 Jul 2006 17:00:27 -0700, "Old Red One" <(E-Mail Removed)> wrote:

>How does one average blood pressure readings? Please give an actual
>example, such as 152/65.
>

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

"Old Red One" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> How does one average blood pressure readings? Please give an actual
> example, such as 152/65.
>

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

"Biff" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
> "Old Red One" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> How does one average blood pressure readings? Please give an actual
>> example, such as 152/65.
>>
>
>

"Biff" <(E-Mail Removed)> wrote in message
news:ucwK%(E-Mail Removed)...
> 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
>
> "Biff" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>> "Old Red One" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> How does one average blood pressure readings? Please give an actual
>>> example, such as 152/65.

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.

Biff wrote...
>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

Biff wrote...
>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.

>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)

I thought about using an array AVERAGE, although I didn't think about using
INT(SUBSTITUTE(A1:A3,"/",".")).

Very clever!

Biff

"Harlan Grove" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Biff wrote...
>>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.
>

"Old Red One" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> "Biff" <(E-Mail Removed)> wrote in message
> news:ucwK%(E-Mail Removed)...
>> 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
>>
>> "Biff" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>>
>>> "Old Red One" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> How does one average blood pressure readings? Please give an actual
>>>> example, such as 152/65.
>
> 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