How to Average Graphs with Different Time Indices?

Click For Summary

Discussion Overview

The discussion revolves around the challenge of averaging multiple sets of voltage data that have different time indices. Participants explore methods for creating an average curve that accurately represents the data despite the discrepancies in time sampling.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested
  • Mathematical reasoning

Main Points Raised

  • One participant suggests combining the data into a single set of ordered pairs (voltage, time) without regard for the time index.
  • Another participant emphasizes the need for a single spline curve to represent the average of the data, indicating that simply combining the graphs is insufficient.
  • There is a suggestion that the problem resembles a regression issue, complicated by non-normally distributed errors.
  • A weighted average is proposed as a potential method to address the differing time indices.
  • One participant notes that some datasets may be stretched in time relative to others, complicating the averaging process further.

Areas of Agreement / Disagreement

Participants express differing views on how to approach the averaging of the data. While some agree on the need for a regression approach, there is no consensus on the specific methods or assumptions to be used.

Contextual Notes

Participants acknowledge the complexity introduced by the non-uniform time indices and the potential skewness of the data, which may affect the choice of averaging method.

u-zara
Messages
4
Reaction score
0
I have 10 sets of data which I have to analyze. The data represents a change in voltage over time and I want to come up with an "average" curve to represent the 10 sets of data. The problem is that the time index for each data is different so I can't simply average the voltage. Is there any method which I can use to solve this problem? I've attached an image of the graph with 3 sets of the data so you understand what I'm dealing with. Thanks in advance.
 

Attachments

  • graph.PNG
    graph.PNG
    12.6 KB · Views: 615
Physics news on Phys.org
I take it you have reason to believe that the three plots are for the same physics?

The time index does not matter - just combine the three plots as a single set of ordered pairs (v,t). The time step ti-ti-1 need not be constant.
 
Thanks for the reply. However I'm not just thinking of combining the graphs. I want a curve which is an average of all the data, for example a single spline curve which represents the data.
 
u-zara said:
Thanks for the reply. However I'm not just thinking of combining the graphs. I want a curve which is an average of all the data, for example a single spline curve which represents the data.

That sounds suspiciously like a regression problem, but approaching it that way is going to be a little complicated (e.g. the errors are clearly not normally distributed).
 
Yeah - it's very skewed.
u-zara said:
Is there any method which I can use to solve this problem?
... and what problem was that?
The problem is that the time index for each data is different so I can't simply average the voltage.
... that's right, you need to use a weighted average.

As Number-Nine says, this is a regression problem with non-normal statistics.
You can, however, use the physics of the situation to guide the shape of the regressed curve - and then you have to decide what sort of regression you will be happy with.

Of course, you can just make a guess to the curve and adjust the parameters by eye until you get something reasonable. The human visual system is quite good at this sort of thing but you may have to be more rigorous than that.
 
It's a bit hard to tell from the fog of datapoints, but it looks to me that the time axis problem is worse than merely having different sample instants; some of the datasets look stretched in time relative to others. Is that what you meant when you said the time index was different?
 

Similar threads

  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 76 ·
3
Replies
76
Views
7K
  • · Replies 3 ·
Replies
3
Views
3K
Replies
3
Views
1K
  • · Replies 19 ·
Replies
19
Views
8K
  • · Replies 1 ·
Replies
1
Views
4K
  • · Replies 7 ·
Replies
7
Views
8K
Replies
1
Views
2K