Comparing two trendlines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Groupshelp@gmail.com - 10 Oct 2006 03:56 GMT

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?

Reply to this Message

Jerry W. Lewis - 10 Oct 2006 05:31 GMT

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

> 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
[quoted text clipped - 6 lines]
>
> Can anyone help me?

Reply to this Message