Comparing two trendlines

[Groupshelp]

I am trying to create a table of the difference between two polynomial
trendlines on a graph. The data has about 1200 data points, but the Y
values are only between 0%-100%.

Basically the graphs shows that when line1 is zero, line 2 is about
18%... and they converge at 100%, the relationship is pretty smooth but
I can't extract the Y values of one trendline and place it next to the
values of the next trendline..

Can anyone help me?

 

[Guest]

You cand use the TREND function to calcualte trendline values for
polynomials. If the known x_data values are in a column, then
=TREND(x,y_data,x_data^{1,2,3})
would calculate the cubic trend at x. If the known x_data values are in a
row, then
=TREND(x,y_data,x_data^{1;2;3})

Jerry