View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Scholes Mark Scholes is offline
external usenet poster
 
Posts: 16
Default Polynomial least squares fit

Hi,
I have a graph of two values and I need to know, what the
formula is that connects all to points. The trend function
in the graph gives

y = 0.0557x4 - 51.355x3 + 18559x2 - 3E+06x + 2E+08

I need the last two terms too more places.

Is there a spread sheet function for this, a macro or
anything.

MarkS