(A) If the X-values are the same for each series the Y-value of the average
is simply the average of the respective y-values.
(B) So, I assume yr X-values are not equal, though within a comparable
scale. You cld try to interpolate / extrapolate the xy-pairs to obtain a
kind of best-fit curve, with Add Trendline you can choose a polynomial fit
which gives you say 10 estimated curves. Now the one y'r looking for is the
average of Y-values belonging to that fit, identical as in (A).
HTH,
Henk
"jessie joe" wrote:
Hello!
I would like to get the average curve from several curves on a plot. Is
there a way to do this in Excel?
(Background infromation: I have, say, 10 sets of XY points and I want
to take the average of these to obtain a set of average X and Y points
and plot them. However, each of these 10 sets have a different amount
of XY points and I can't simply take the average across the row. Any
solutions?)
Thanks!
--
jessie joe
------------------------------------------------------------------------
jessie joe's Profile: http://www.excelforum.com/member.php...o&userid=36054
View this thread: http://www.excelforum.com/showthread...hreadid=558432