In the formula

=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)

what do the "{" mean

Does anybody know how to find the area under the curve of a trendline
(6th
degree polynomial in my case).

In general, here is one way...

Select 7 horizontal cells, and array enter the following equation:

=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)

I used Range Names to refer to the X & Y data located in columns.
This gives you the 7 coefficients,

In general, knowing that you equation is:
a+b*x+c*x^2+d*x^3+e*x^4+f*x^5+g*x^6

we take the integral to arrive at the following equation.

a*x+(b*x^2)/2+(c*x^3)/3+(d*x^4)/4+(e*x^5)/5+(f*x^6)/6+(g*x^7)/7

In two cells, set x to the upper limit, and lower limit of your range.
Subtract the two values to get the "Area."

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"Josh" wrote in message
...
I'm sorry about that, the browser did not change to the confirmation
screen,
so I did not realize that the question was posted. On another note, do you
know of any answers to this question?

"David Biddulph" wrote:

Please don't multipost.

Learn the difference between multiposting & crossposting:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Josh" wrote in message
...
Does anybody know how to find the area under the curve of a trendline
(6th
degree polynomial in my case).

Thanks in advance for any help.

It demarks 1,2,3,4,56 as an array (or vector) of numbers
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
...
In the formula

=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)

what do the "{" mean

Does anybody know how to find the area under the curve of a trendline
(6th
degree polynomial in my case).

In general, here is one way...

Select 7 horizontal cells, and array enter the following equation:

=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)

I used Range Names to refer to the X & Y data located in columns.
This gives you the 7 coefficients,

In general, knowing that you equation is:
a+b*x+c*x^2+d*x^3+e*x^4+f*x^5+g*x^6

we take the integral to arrive at the following equation.

a*x+(b*x^2)/2+(c*x^3)/3+(d*x^4)/4+(e*x^5)/5+(f*x^6)/6+(g*x^7)/7

In two cells, set x to the upper limit, and lower limit of your range.
Subtract the two values to get the "Area."

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"Josh" wrote in message
...
I'm sorry about that, the browser did not change to the confirmation
screen,
so I did not realize that the question was posted. On another note, do
you
know of any answers to this question?

"David Biddulph" wrote:

Please don't multipost.

Learn the difference between multiposting & crossposting:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Josh" wrote in message
...
Does anybody know how to find the area under the curve of a trendline
(6th
degree polynomial in my case).

Thanks in advance for any help.

The {} denote an array constant. The commas indicate new colums. If x is an
nx1 column of numbers, then x^{1,2,3,4,5,6} is an nx6 array of numbers where
the first column contains the original x's, the 2nd column contains x^2
values, ...

Jerry

" wrote:

In the formula

=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)

what do the "{" mean

Does anybody know how to find the area under the curve of a trendline
(6th
degree polynomial in my case).

In general, here is one way...

Select 7 horizontal cells, and array enter the following equation:

=LINEST(Ys,Xs^{1,2,3,4,5,6},TRUE,FALSE)

I used Range Names to refer to the X & Y data located in columns.
This gives you the 7 coefficients,

In general, knowing that you equation is:
a+b*x+c*x^2+d*x^3+e*x^4+f*x^5+g*x^6

we take the integral to arrive at the following equation.

a*x+(b*x^2)/2+(c*x^3)/3+(d*x^4)/4+(e*x^5)/5+(f*x^6)/6+(g*x^7)/7

In two cells, set x to the upper limit, and lower limit of your range.
Subtract the two values to get the "Area."

--
HTH :)
Dana DeLouis
Windows XP & Office 2007


"Josh" wrote in message
...
I'm sorry about that, the browser did not change to the confirmation
screen,
so I did not realize that the question was posted. On another note, do you
know of any answers to this question?

"David Biddulph" wrote:

Please don't multipost.

Learn the difference between multiposting & crossposting:
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html
--
David Biddulph

"Josh" wrote in message
...
Does anybody know how to find the area under the curve of a trendline
(6th
degree polynomial in my case).

Thanks in advance for any help.