Follow up area under the curve

J

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

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top