how to plot ONE x-y curve of two datas with different x values?

[b83503104]

I have this data:
x: (1.1) (3.6) (6.0) (7.5) (9.2) ...
y: (4.2) (5.6) (6.3) (9.4) (9.6) ...

and this data:
x: (2.3) (3.2) (5.4) (6.7) (7.2) ...
y: (1.2) (2.4) (3.3) (6.4) (8.9) ...

Now I want a x-y chart with a SINGLE smooth curve, showing the average
result of these two datas. By average, I mean that, suppose I have
two curves, I want a curve which is always in the middle of them.
As you can see, my problem is that the x data is not very regular, and
the x data of both datas usually do not coincide.
Thanks!

 

[Bernie Deitrick]

You need to create a single table of all your x values, and interpolate to
find the missing values for each data set. Then you can average your y
values.

HTH,
Bernie
MS Excel MVP

 

[Bernard Liengme]

Make a chart with the first set of data
Select the second set of data (x & y value); use Copy command
Click on chart to activate
Use Edit|PasteSpecial-> New Series

Best wishes

 

[b83503104]

This seems to generate two curves.
Is there a way to generate one curve, which is the mean of the two curves?

Thanks

 

[Bernie Deitrick]

My technique will generate one curve, which is the mean of the two curves.
Did you try?

HTH,
Bernie
MS Excel MVP

 

[b83503104]

Hi, I tried, but maybe I did something wrong in the process.
This is the first set of data
x 3 5 7 9
y 1 2 3 4

This is the second set of data
x 1 2 5 8
y 2 3 4 6

I selected XY Scatter plot with data points connected by smoothed
lines, added a series using the first set of data, then pressed
Finish. This generates a chart with a single line.
Then I selected the second set of data (all the 8 numbers), did a copy
with Ctrl-c, clicked on the chart to activate, use
Edit|PasteSpecial->New Series.
Then, within the dialog window, I tried both the default with
"Categories (X values) in First Row" unchecked, and checked, and both
didn't get me the mean curve.
I'd be gladful for your further help!

 

[Bernie Deitrick]

I will send you a working example. I hope that your yahoo address
works.....

HTH,
Bernie
MS Excel MVP

 

[snowgoon17]

I also want to plot one curve from two different sets of data. However
does this technique apply only to data that is linear? How do
interpolate data that is not linear? Thanks