Averaging data sets in an XY Scatter Plot
Averaging data sets in an XY Scatter Plot
(OP)
I have multiple sets of data of Force vs. Time (the times are different for each set of data), i would like to be able to average these 5 sets of data into a single line using excel. Basicly a running average between all the lines. Is this possible? or should i ask, what is the easiest way of doing this?
Thanks for any feedback!
-Ted
M.E.
Thanks for any feedback!
-Ted
M.E.





RE: Averaging data sets in an XY Scatter Plot
Add each extra set to the chart using Chart | Add Data...
selecting add as new points and x-values in first column.
Add trendline to the result.
Alternately, stack all the data in two columns, and just plot it.
RE: Averaging data sets in an XY Scatter Plot
all of these lines
averaged together to get --> this average line
----------------
-----------------------
__________ Avg.would =
-----------------
RE: Averaging data sets in an XY Scatter Plot
RE: Averaging data sets in an XY Scatter Plot
These are the lines that i have, I would like to generate another line that is the average of these 5 lines...not a straight line, one that averages each point from each of the five lines...so essentially it will look like the others, just at an average...like this
this is somethign that i doctored, does anyone know if Excel is capable of doing somethign like this automatically?
RE: Averaging data sets in an XY Scatter Plot
RE: Averaging data sets in an XY Scatter Plot
See other threads for advice on interpolation
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Averaging data sets in an XY Scatter Plot
In this way, your datapoints will all be at the same X values, and you can average them.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Averaging data sets in an XY Scatter Plot