Having looked at LINREGR (aka LINEST in uk-version) in Excel 2003, I cannot get it to do anything but linear regression.
Some have posted documents on the web saying the opposit, in fact that it should be possible to use LINREGR to do polynomial fitting of data sets.
The attachment should give koefficients and constant for a fifth order polynomium Y= a*x^1+b*x^2+c*x^3+d*x^4+e*x^5+f.
Can anyone help me here - even to know that there are more undocumented differences between Linest and linregr will ease me.
Bookmarks