×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Averaging data sets in an XY Scatter Plot

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.

RE: Averaging data sets in an XY Scatter Plot

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.

RE: Averaging data sets in an XY Scatter Plot

(OP)
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 =

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


RE: Averaging data sets in an XY Scatter Plot

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).

RE: Averaging data sets in an XY Scatter Plot

(OP)


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

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

RE: Averaging data sets in an XY Scatter Plot

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.

RE: Averaging data sets in an XY Scatter Plot

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.

RE: Averaging data sets in an XY Scatter Plot

(OP)
Thanks guys! It's much apprechiated!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources