How do I fit xy data to a 6th order polynomial for use in an equation?

[Randy]

I have X and Y column data, and want to set a cell equal
to the trendline values of that data, but I want the
trendline equation to represent a 6th order polynomial,
not a linear trendline.
My only option now is to add a trendline to a graph of the
data, and then re-write that equation in a cell, but i
don't want to have to create a graph and re-write the
equation every time. Any Ideas?
Randy

 

[Jerry W. Lewis]

=LINEST(B1:B6,A1:A6^{1,2,3,4,5,6})
array entered (Ctrl-Shift-Enter

Depending on your data, the chart trendline may be significantly more
accurate than LINEST(). David Braden has posted VBA code to extract the
coefficients directly from the chart into cells

http://groups.google.com/[email protected]

Jerry

 

[Tom Ogilvy]

Use linest

You can see how Bernard Liengme solves for the coefficients of a polynomial
curve using LINEST. Perhaps you can adapt a similar approach to working
with your 6th order polynomial equation.

http://www.stfx.ca/people/bliengme/ExcelTips/Polynomial.htm