Originally Posted by

**sbe70** Hello,

Sorry to say but I studied this in class 20 years ago. Now it is gone. So I need help here.

I have 5-10 data points that I want to approximate a nonlinear polynominal to. I need to write the solution in excel, in the visual basic editor, meaning I want to use an iterative approach and not a "inverse matrix" solution. Can someone please help me here.

Ex)

x=2012, 2013, 2014, 2015, 2016

y= 5937, 5343, 4310, 3887, 0

Preferably, I want to have zero error at the boundaries but if the difference between the total least square error for "zero boundrary solution" and "without zero boundary error constraint" is too big I can skip the boundary conditions.

Would approciate if solution is written in a form that it is easy to see how I can code it in VB, flow chart maybe.....

Thanks in advance from an "old" student that has not been able to remember this knowledge 20 years later.....

/sbe