Follow up area under the curve

[James]

In the formula

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

what do the "{" mean

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."

 

[Bernard Liengme]

It demarks 1,2,3,4,56 as an array (or vector) of numbers
best wishes

 

[Guest]

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