Fitting a polynomial to a graph.

[Rich2189]

If you have a set of results on a graph that appears to have a straight line of best fit you can use regression to obtain its algebraic equation.

But how can you do this if your results show a slight curve? How do you map a polynomial onto a graph using your results?

Thanks,

Rich

[zaza]

Using least-squares fitting.

Do a search on these forums if you want code. It must have come up many times before.

zaza

[VBAhack]

Do a search on these forums if you want code. It must have come up many times before.
zaza

Here's a very recent forum discussion:

http://www.vbforums.com/showthread.php?t=452604

[Rich2189]

Thanks for the pointers guys, I used this post here POST

Managed to get the same answer that MS Excel provided which is a good sign .