Averaging data sets in an XY Scatter Plot

[TedMac]

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.

 

[MintJulep]

Plot the first set as an X-Y chart. Points only, no connecting lines.

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.

 

[TedMac]

I don't think that excell is able to do what I am looking for it to do. I've done the same test(a clamp test) 5 different times with slightly varying max values what i want to do is to average all of the raw data together, resulting in 1 Average line. Everything that i've been able to find online and what-not just explains who to combine sets of data...i need to Average all of the points together....something like this

all of these lines
averaged together to get --> this average line

----------------

-----------------------

__________ Avg.would =

-----------------

 

[jghrist]

You can use all of the data as one set of data in two columns (x and y) for a least-squares fit into a single line using LINEST (if linear or polynomial using additional derived variables like y²) or LOGEST (if logarithmic).

 

[TedMac]

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?

 

[melone]

Can you create a new data set that just uses the AVG() function?

 

[GregLocock]

You need to create an interpolated version of each data set, at constant small increments of x. then you will have 5 graphs with the same x intervals, so you can then get an average.

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.

 

[joerd]

Greg's right. Interpolate each curve at a given set of X values, for example using the interp function in XLXTRFUN, which is a free add-in from

http://www.netrax.net/~jdavita/XlXtrFun/XlXtrFun.htm

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.

 

[TedMac]

Thanks guys! It's much apprechiated!