Simplest approach would be to transform the x-axis data so that the desired fixed point was at x = 0, and transform the y-axis so the desired fixed point was at 0, then tell Excel to force the line to go through (x,y) = (0,0).
You can do this by subracting (or adding) a fixed value to the x's and another fixed value to the y's. Cheers, Jay 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. > > Any help would be appreciated! > > /Anders > . > . > ================================================================= > Instructions for joining and leaving this list, remarks about the > problem of INAPPROPRIATE MESSAGES, and archives are available at: > . http://jse.stat.ncsu.edu/ . > ================================================================= -- Jay Warner Principal Scientist Warner Consulting, Inc. 4444 North Green Bay Road Racine, WI 53404-1216 USA Ph: (262) 634-9100 FAX: (262) 681-1133 email: [EMAIL PROTECTED] web: http://www.a2q.com The A2Q Method (tm) -- What do you want to improve today? . . ================================================================= Instructions for joining and leaving this list, remarks about the problem of INAPPROPRIATE MESSAGES, and archives are available at: . http://jse.stat.ncsu.edu/ . =================================================================
