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

  • Thread starter Thread starter Randy
  • Start date Start date
R

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
 
=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
 
Back
Top