How Can I Extract Maximum and Minimum Voltages from EKG Graphs in Excel?

  • Thread starter Thread starter Ush
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary

Discussion Overview

The discussion revolves around extracting maximum and minimum voltages from EKG graphs using Excel. Participants explore the challenges posed by varying periods and noise levels in the data, focusing on the identification of significant peaks and troughs in the EKG signals.

Discussion Character

  • Technical explanation
  • Conceptual clarification
  • Debate/contested
  • Experimental/applied

Main Points Raised

  • One participant seeks a method to extract maximum and minimum voltages from EKG graphs with over 2500 voltage values per 12-second reading.
  • Another participant questions the definition of maxima and minima, particularly regarding the influence of noise on peak identification.
  • Clarification is provided that the focus is on the QRS wave, which consists of large, sharp peaks in the EKG data.
  • Concerns are raised about noise levels being comparable to maximum voltage levels, complicating peak identification.
  • Suggestions are made to distinguish desired peaks from noise based on the amount the peak rises above the noise and the reversal of slope.
  • A participant proposes that the minimum voltage could be defined as the first reversal of slope from negative to positive following a maximum.
  • Further analysis indicates that a voltage rise of at least 0.5 mV without a reversal of slope could help in defining maximums.
  • Some participants indicate that the issues have been resolved, but questions remain about the causes of low-frequency artifacts in the EKG data.
  • It is noted that the noise may be attributed to breathing, and the context of the discussion is linked to a physics lab experiment involving EKG apparatus and other equipment.

Areas of Agreement / Disagreement

Participants express varying views on how to define maxima and minima in the presence of noise, and while some issues appear to be resolved, the discussion remains open regarding the specifics of peak identification and noise management.

Contextual Notes

Participants highlight the importance of clearly defining objectives when analyzing EKG data, and there are unresolved questions about the influence of noise and the specific criteria for identifying peaks and troughs.

Who May Find This Useful

This discussion may be useful for individuals involved in biomedical engineering, data analysis of physiological signals, or those conducting experiments related to EKG readings in a physics or engineering context.

Ush
Messages
97
Reaction score
0
I have various EKG graphs. I need all of the maximum and minimum voltages for each period. The periods are not all the same length. The maximums and minimums all vary.
Is there any way I can do this?
Note: it'll be hard selecting chunks of data and then finding it from that because there's nearly 2500+ values for voltage per a 12 second reading.

An example of a EKG graph is below.
[PLAIN]http://img210.imageshack.us/img210/184/examplefw.jpg

thank you
 
Last edited by a moderator:
Physics news on Phys.org
From your data I'm not sure what you mean by maxima, minima and period. Are the peaks inside the noise also considered maxima? If not, how far above the noise must a peak rise before it is considered a peak?

In problems of this sort it is important to carefully define your objective. As you refine your definition, many times the solution becomes obvious.
 
I was referring to the QRS wave (the large, sharp peaks)
please see attachment below.
 

Attachments

  • example.jpg
    example.jpg
    29.2 KB · Views: 502
also;
some of the noise is at the same level at the maximums for some of the EKG's
see below

[PLAIN]http://img268.imageshack.us/img268/5008/examplevn.jpg
=/
 
Last edited by a moderator:
Good analysis.

Can you think of a way of distinguishing between the peaks you want and the ones you don't. Obviously voltage won't work. What about the amount it rises above the noise? The peak itself might be distinguished by a reversal of slope.

Is the minimum the the first reversal of slope from negative to positive after a maximum?
 
The minimum is the first reversal of slope after the maximum
I'm not sure about another way to define maximums. btw, thank you so much for helping me, I appreciate it =)
 
looking at the graph again. It's apparent that the voltage rises at least 0.5mv without reversal of slope. The noise goes up and down many many times, none of it reaches 0.5mv without reversal of slope.
Can this be used to help define maximum?
 
--Issue is solved.
 
Ush said:
--Issue is solved.

Glad to hear that. BTW, what was causing all of the low-frequency artifacts? Was the patient moving a lot? Which lead is this from, Lead-II?
 
  • #10
Lead-I
the subject was as still as possible- the noise is most likely from breathing, The relationship between exercise and voltage were being tested so it's not too surprising. EKG's usually do have a fair bit of noise-
This is part of a physics course.. Each lab we're given different equipment and instructions on how to use the equipment. We have to look at how the equipment works and then make up some sort of hypothesis we can test and then perform the experiment and write a formal report on our findings. For this particular lab we were given an EKG apparatus, voltmeter, conductive paper and power supply-
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K
Replies
2
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 3 ·
Replies
3
Views
3K
Replies
5
Views
6K
  • · Replies 3 ·
Replies
3
Views
14K
Replies
1
Views
3K
Replies
1
Views
9K