Iterative process,
bioyyy wrote:
B.R.,
Thanks for replying, but it's not what I am looking for is to minimise the
sum of squared residuals (SSR) of y after the initial slope and intercept are
determined. So that more reliable slope and intercept estimations are
obtained. Usually it takes about 3-5 iterations. BUT I really don't know how
to this. Thanks again,
-----------------------------
To iterate solutions in some custom method you desire, use ToolsSolver. It
allows you to specifiy some cell to be minimized by twiddling other specified
cells. You can run wild!
Bill
|