On 27/05/2014 17:55, Peter T wrote:
"isabelle" wrote in message
hi,
the Regression tool uses the worksheet function LINEST
http://office.microsoft.com/en-us/ex...010342762.aspx
http://office.microsoft.com/en-us/ex...005209155.aspx
x = Application.LinEst(Range("A2:A5"), Range("B2:B5"), False)
isabelle
Indeed the tool uses LinEst but can get more stats like this
x = Application.LinEst(Range("A2:A5"), Range("B2:B5"), True, True)
Returns a 5x2 array of stats as shown on the help page you referred to.
The regression tool returns other stats that LinEst doesn't, though LinEst
can also return the polyniomial cooefficients of a 'best fit' curved line.
Be aware that it is only marginally numerically stable if you try to fit
anything more than a quadratic on data with a x axis offset.
By comparison the polynomial fit in the charts is done correctly but
doesn't by default display its answers with enough significant digits.
--
Regards,
Martin Brown