Heart rate every 5 seconds

[Wheats142]

Hi all,

I am stuck on what feels like a simple problem, but I can't solve it.

I have used a heart rate monitor to record the heart rate of participants running on a treadmill. I programmed the heart rate incorrectly, instead of taking the heart rate every 5 seconds, it took the heart rate after every beat. I therefore have been left with a ridiculously long data sheet, 18394 rows.

What I would like is to take an average heart rate every 5 seconds of elapsed time to best mimic how the monitor should have been set.

I have tried converting the time to seconds and using the following formula:

=AVERAGEIFS(C:C,B:B,">5",B:B,"<10.1")

That works perfectly but I can't drag it down. to try and solve the copy and update formula problem I tried creating 2 extra columns with the 'greater than' and 'less than' values in, for example; 5 - 10.1, 10 - 15.1, 15 - 20.1, and so on. For some reason though using those cell figures as the criteria just comes up with the most annoying result ever.... #DIV/0!

Any ideas? I have attached the first minute of data results, please feel free to take a gander.

Kind regards

Wheats

[Richard Buttrey]

Hi,

Perhaps in R2 copied down

Please Login or Register  to view this content.

[Pete_UK]

With your 5-second increments in column P, as in your example, you can put this formula in Q2:

=AVERAGEIFS(C:C,B:B,">="&P2,B:B,"<"&P2+5)

and then copy down.

Hope this helps.

Pete

[José Augusto]

Hi
Use in E2 the value 0
Use in E3, format as time, and copy down the following formula

Please Login or Register  to view this content.

Use in F3 and copy down the following formula

Please Login or Register  to view this content.

Regards