View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ben
 
Posts: n/a
Default Linear Regression by set Slope (not intercept)

Jerry, i do not understand the usage of average(Y-X).
As Y-X is just a value, taking the average of it does nothing.

What i intent on doing is fitting lines with slope=1 to a small set of
close values.

Could you please elaborate