othogonal regression

atrom · March 17th, 2003, 3:35 pm

Hi GuysDoes anyone know how to do an orthoganol regression in excel or the formula. Does anyone know how to implement this. Ur help would be appreciated.atrom

Flex · March 18th, 2003, 12:58 pm

I suggest google + orthogonal regression, maybe add some excel to it too.[hint] Maybe you even find some post in this forum, which gives you the intentionthat you could have even used the search-function of this forum

[/hint]

adannenberg · March 18th, 2003, 2:55 pm

The problem doesn't have an analytic solution, but that's ok if you don't mind using Newton-Raphson or something fancier. Check out http://mathworld.wolfram.com/LeastSquar ... fsets.html for more detail.

patch22 · March 18th, 2003, 5:46 pm

i have asked this question on a thread before, do a search on orthogonal AND excel, there is an answer.