Anders wrote:
>
> I am using the least-mean-square method to calculate the best straight
> line to a number of meassured points. But how do I change the formulas
> if I want one of my meassured points to be fixed (the line must go
> throu that point). This is possible in Excel, but only to fix the
> y-value at x=0. I presume it is mathematically possible but havn't
> found any formula for it.
There are, as usual, infinitely many ways that you *can* do it. I can
think of about three plausible ones off the top of my head.
The question you need to answer first is - why do you want to do it?
This affects what the correct way to do it would be (and whether it
would be a smart thing to do at all!)
-Robert Dawson
.
.
=================================================================
Instructions for joining and leaving this list, remarks about the
problem of INAPPROPRIATE MESSAGES, and archives are available at:
. http://jse.stat.ncsu.edu/ .
=================================================================